@Override public int AddOperator(T_Operator tOperator) { // TODO Auto-generated method stub String sql = "insert into t_operator(t_operator.O_ID,t_operator.O_Password,t_operator.O_Name,t_operator.O_IDCard,t_operator.O_Department,t_operator.O_Adress,t_operator.O_Tel,t_operator.R_ID,t_operator.A_ID,t_operator.O_Time) values (?,?,?,?,?,?,?,?,?,?)"; int temp = -1; try { temp = DB.update( sql, tOperator.getO_ID(), tOperator.getO_Password(), tOperator.getO_Name(), tOperator.getO_IDCard(), tOperator.getO_Department(), tOperator.getO_Adress(), tOperator.getO_Tel(), tOperator.getR_ID(), tOperator.getA_ID(), new Timestamp(tOperator.getO_Time().getTime())); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return temp; }
@Override public int DeleteOperator(String OId) { // TODO Auto-generated method stub String sql = "DELETE FROM t_operator WHERE t_operator.O_ID=?"; int temp = -1; try { temp = DB.update(sql, OId); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return temp; }
@Override public int UpdateOperator(T_Operator tOperator) { // TODO Auto-generated method stub String sql = "update t_operator set t_operator.O_Name=?,t_operator.O_IDCard=?,t_operator.O_Department=?,t_operator.O_Adress=?,t_operator.O_Tel=?,t_operator.R_ID=?,t_operator.A_ID=? where t_operator.O_ID=?"; int temp = -1; try { temp = DB.update( sql, tOperator.getO_Name(), tOperator.getO_IDCard(), tOperator.getO_Department(), tOperator.getO_Adress(), tOperator.getO_Tel(), tOperator.getR_ID(), tOperator.getA_ID(), tOperator.getO_ID()); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return temp; }