@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;
}
