@Override
public Task findById(int task_id) throws Exception {
Task Task = null;
String sql = "SELECT * FROM t_task WHERE task_id=?";
this.pstmt = this.conn.prepareStatement(sql);
this.pstmt.setInt(1, task_id);
ResultSet rs = this.pstmt.executeQuery();
if (rs.next()) {
Task = new Task();
Task.setTask_id(rs.getInt("task_id"));
Task.setTask_staffid(rs.getInt("task_staffid"));
Task.setTask_supplierid(rs.getInt("task_supplierid"));
Task.setTask_num(rs.getInt("task_num"));
Task.setTask_unit(rs.getString("task_unit"));
Task.setTask_state(rs.getString("task_state"));
Task.setTask_categoryid(rs.getInt("task_categoryid"));
Task.setTask_time(rs.getTimestamp("task_time"));
Task.setTask_offtime(rs.getTimestamp("task_offtime"));
}
this.pstmt.close();
return Task;
}
@Override
public List<Task> findAll(String keyWord) throws Exception {
List<Task> result = new ArrayList<Task>();
String sql = "SELECT * FROM t_task WHERE supplierid LIKE ?";
this.pstmt = this.conn.prepareStatement(sql);
this.pstmt.setString(1, "%" + keyWord + "%");
ResultSet rs = this.pstmt.executeQuery();
Task Task = null;
while (rs.next()) {
Task = new Task();
Task.setTask_id(rs.getInt("task_id"));
Task.setTask_staffid(rs.getInt("task_staffid"));
Task.setTask_supplierid(rs.getInt("task_supplierid"));
Task.setTask_num(rs.getInt("task_num"));
Task.setTask_unit(rs.getString("task_unit"));
Task.setTask_state(rs.getString("task_state"));
Task.setTask_categoryid(rs.getInt("task_categoryid"));
Task.setTask_time(rs.getTimestamp("task_time"));
Task.setTask_offtime(rs.getTimestamp("task_offtime"));
result.add(Task);
}
this.pstmt.close();
return result;
}
@Override
public boolean doCreate(Task Task) throws Exception {
boolean flag = false;
String sql =
"INSERT INTO t_task(task_staffid,task_supplierid,task_num,task_unit,task_state,task_categoryid,task_time,task_offtime) VALUES (?,?,?,?,?,?,?,?)";
this.pstmt = this.conn.prepareStatement(sql);
this.pstmt.setInt(1, Task.getTask_staffid());
this.pstmt.setInt(2, Task.getTask_supplierid());
this.pstmt.setInt(3, Task.getTask_num());
this.pstmt.setString(4, Task.getTask_unit());
this.pstmt.setString(5, Task.getTask_state());
this.pstmt.setInt(6, Task.getTask_categoryid());
this.pstmt.setTimestamp(7, Task.getTask_time());
this.pstmt.setTimestamp(8, Task.getTask_offtime());
if (this.pstmt.executeUpdate() > 0) {
flag = true;
}
this.pstmt.close();
return flag;
}