Empdao类
package cn.hp.dao;
import cn.hp.entity.Dept;
import cn.hp.entity.Emp;
import cn.hp.util.DBHelper;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
public class EmpDao {
public Emp login(String name, String password) {
Connection conn = DBHelper.getConn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select * from emp where name=? and password=?");
ps.setObject(1, name);
ps.setObject(2, password);
rs = ps.executeQuery();
Emp emp = new Emp();
while (rs.next()) {
emp.setId(rs.getInt("id"));
emp.setName(rs.getString("name"));
emp.setPassword(rs.getString("password"));
emp.setSex(rs.getString("sex"));
emp.setDid(rs.getInt("did"));
emp.setBirthday((Date) rs.getObject("birthday"));
System.out.println(emp);
return emp;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.close(conn, ps, rs);
}
return null;
}
public List<Emp> list() {
Connection conn = DBHelper.getConn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select e.*,d.`name` dname from emp e left join dept d on e.did =d.id\t");
rs = ps.executeQuery();
List<Emp> list = new ArrayList<>();
while (rs.next()) {
Emp emp = new Emp();
emp.setId(rs.getInt("id"));
emp.setName(rs.getString("name"));
emp.setPassword(rs.getString("password"));
emp.setSex(rs.getString("sex"));
emp.setDid(rs.getInt("did"));
emp.setDname(rs.getString("dname"));
emp.setBirthday((Date) rs.getObject("birthday"));
System.out.println(emp);
list.add(emp);
}
return list;
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.close(conn, ps, rs);
}
return null;
}
public int del(Integer id) {
int i = 0;
Connection conn = DBHelper.getConn();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("delete from emp where id=?");
ps.setObject(1, id);
i = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBHelper.close(conn, ps);
}
return i;
}
public Emp findById(Integer id) {
// list()
Connection conn = DBHelper.getConn();
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement("select * from emp where id=