Java开发基础-JDBC-对其技术的支持—02

最新推荐文章于 2024-05-18 11:09:56 发布

2301_82243769

最新推荐文章于 2024-05-18 11:09:56 发布

阅读量299

点赞数 4

分类专栏：程序员文章标签： java 开发语言

本文链接：https://blog.csdn.net/2301_82243769/article/details/138310268

版权

程序员专栏收录该内容

219 篇文章 0 订阅

订阅专栏

this.mgr = mgr;

}

public Date getHiredate() {

return hiredate;

}

public void setHiredate(Date hiredate) {

this.hiredate = hiredate;

}

public Double getSal() {

return sal;

}

public void setSal(Double sal) {

this.sal = sal;

}

public Double getComm() {

return comm;

}

public void setComm(Double comm) {

this.comm = comm;

}

public Integer getDeptno() {

return deptno;

}

public void setDeptno(Integer deptno) {

this.deptno = deptno;

}

2.编写数据库操作类EmpDao：【封装CURD】

public class EmpDao {

//查询所有

public List findAll(){

Connection conn = null;

List empList = new ArrayList();

try {

conn = DBUtil.getConnection();

String sql = "select * from emp ";

PreparedStatement ps = conn.prepareStatement(sql);

ResultSet rs = ps.executeQuery();

while(rs.next()){

Emp e =new Emp();

e.setEmpno(rs.getInt(“empno”));

e.setEname(rs.getString(“ename”));

e.setJob(rs.getString(“job”));

e.setMgr(rs.getInt(“mgr”));

e.setHiredate(rs.getDate(“hiredate”));

e.setSal(rs.getDouble(“sal”));

e.setComm(rs.getDouble(“comm”));

e.setDeptno(rs.getInt(“deptno”));

empList.add(e);

}

return empList;

} catch (SQLException e) {

e.printStackTrace();

}

return empList;

}

public Emp findById(int id){

Connection conn =null;

try {

conn = DBUtil.getConnection();

String sql = "select * from emp "

+“where empno =?”;

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1, id);

ResultSet rs = ps.executeQuery();

if(rs.next()){

Emp e =new Emp();

e.setEmpno(rs.getInt(“empno”));

e.setEname(rs.getString(“ename”));

e.setJob(rs.getString(“job”));

e.setMgr(rs.getInt(“mgr”));

e.setHiredate(rs.getDate(“hiredate”));

e.setSal(rs.getDouble(“sal”));

e.setComm(rs.getDouble(“comm”));

e.setDeptno(rs.getInt(“deptno”));

return e;

}

} catch (SQLException e) {

e.printStackTrace();

throw new RuntimeException(“根据ID查询员工失败！”,e);

}finally{

DBUtil.close(conn);

}

return null;

}

public boolean save(Emp emp){

Connection conn = null;

try {

conn = DBUtil.getConnection();

String sql = “insert into emp values(”

+“?,?,?,?,?,?,?,?)”;

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1, emp.getEmpno());

ps.setString(2, emp.getEname());

ps.setString(3, emp.getJob());

ps.setInt(4, emp.getMgr());

ps.setDate(5, emp.getHiredate());

ps.setDouble(6,emp.getSal());

ps.setDouble(7, emp.getComm());

ps.setInt(8, emp.getDeptno());

int count = ps.executeUpdate();

if(count>0){

return true;

}else{

return false;

}

} catch (SQLException e) {

e.printStackTrace();

throw new RuntimeException(“保存员工失败！”,e);

}finally{

DBUtil.close(conn);

}

public void update(Emp emp){

Connection conn = null;

try {

conn = DBUtil.getConnection();

String sql = "update emp set "

+“ename =?,”

+“job =?,”

+“mgr =?,”

+“hiredate =?,”

+“sal =?,”

+“comm =?,”

+"deptno =? "

+“where empno=?”;

PreparedStatement ps = conn.prepareStatement(sql);

ps.setString(1, emp.getEname());

ps.setString(2, emp.getJob());

ps.setInt(3, emp.getMgr());

ps.setDate(4, emp.getHiredate());

ps.setDouble(5,emp.getSal());

ps.setDouble(6, emp.getComm());

ps.setInt(7, emp.getDeptno());

ps.setInt(8, emp.getEmpno());

ps.executeUpdate();

} catch (SQLException e) {

e.printStackTrace();

throw new RuntimeException(“修改员工失败！”,e);

}finally{

DBUtil.close(conn);

}

public boolean delete(int id){

Connection conn =null;

try {

conn = DBUtil.getConnection();

String sql = "delete from emp "

+“where empno =?”;

PreparedStatement ps = conn.prepareStatement(sql);

ps.setInt(1, id);

int count = ps.executeUpdate();

if(count>0){

return true;

}else{

return false;

}

} catch (SQLException e) {

e.printStackTrace();

throw new RuntimeException(“根据ID删除员工失败！”,e);

}finally{

DBUtil.close(conn);

}

3.编写EmpDao测试类

最后

即使是面试跳槽，那也是一个学习的过程。只有全面的复习，才能让我们更好的充实自己，武装自己，为自己的面试之路不再坎坷！今天就给大家分享一个Github上全面的Java面试题大全，就是这份面试大全助我拿下大厂Offer，月薪提至30K！

我也是第一时间分享出来给大家，希望可以帮助大家都能去往自己心仪的大厂！为金三银四做准备！
一共有20个知识点专题，分别是：