1.查找整个员工的集合
@Override public List<Login> findAll() { List<Login> empList = new ArrayList<>(); Connection connection = null; PreparedStatement statement = null; ResultSet resultSet = null; Login login = null; try { connection = JDBCUtil.getConnection(); String sql = "select * from emp"; statement = connection.prepareStatement(sql); resultSet = statement.executeQuery(); while (resultSet.next()){ login = new Login(resultSet.getInt("id"), resultSet.getString("ename"), resultSet.getInt("job_id"), resultSet.getInt("mgr"), resultSet.getDate("joindate"), resultSet.getDouble("salary"), resultSet.getInt("dept_id")); empList.add(login); } } catch (SQLException throwables) { throwables.printStackTrace(); } return empList; }
2.dao层的删除方法
@Override public int del(int loginNo) { Connection connection = null; PreparedStatement statement = null; String sql = "delete from emp where id = ?"; int count = 0; try { connection = JDBCUtil.getConnection(); statement = connection.prepareStatement(sql); statement.setInt(1, loginNo); count = statement.executeUpdate(); } catch (SQLException throwables) { throwables.printStackTrace(); }finally { JDBCUtil.close(null,statement,connection); } return count; }
3.dao层的增加方法
@Override public int add(Login login) { Connection connection = null; PreparedStatement statement = null; int count =0; try { connection = JDBCUtil.getConnection(); //如果是事务的自动提交为false,那么就需要手动commit提交事务数据 //connection.setAutoCommit(true); String sql = "insert into emps(id,ename,job_id,mgr,joindate,salary,dept_id) values(?,?,?,?,?,?,?)"; //pstm.setDate(5, (Date)emp.getEmpDate()); //new java.sql.Date(java.util.Date.getTime()); //日期转换 statement = connection.prepareStatement(sql); statement.setInt(1, login.getId()); statement.setString(2,login.getEname()); statement.setInt(3,login.getJob_id()); statement.setInt(4,login.getMgr()); statement.setDate(5, (Date) login.getJoindate()); statement.setDouble(6,login.getSalary()); statement.setInt(7,login.getDept_id()); count = statement.executeUpdate(); } catch (SQLException throwables) { throwables.printStackTrace(); }finally { JDBCUtil.close(null,statement,connection); } return count; }
4.dao层的方法有
、import com.fs.modle.Login;import java.util.List;/** * @author: jpeng * @date: 2024/7/25 9:09 * @description: 数据访问的接口层 * 规范dao层的功能方法 */public interface LoginDao { /** * 新增 * @param login 员工 * @return 结果 */ int add(Login login); public int mod(Login login); public int del(int login); /** * 查询所有员工集合 * @return 员工集合 */ public List<Login> findAll(); public Login loadByid(int loginNo); public Login login(int empno, String ename);}
5.服务层的实现方法
package com.fs.service.imp;import com.fs.dao.LoginDao;import com.fs.dao.imp.LoginDaoImp;import com.fs.modle.Login;import com.fs.service.LoginService;import java.util.List;public class LoginServiceImp implements LoginService { LoginDao loginDao = new LoginDaoImp(); @Override public int add(Login login) { int count = loginDao.add(login); return count; } @Override public int mod(Login login) { return 0; } @Override public int del(int login) { return loginDao.del(login); } @Override public List<Login> findAll() { return loginDao.findAll(); } @Override public Login loadByid(int loginNo) { return loginDao.loadByid(loginNo); } @Override public Login login(int id, String ename) { //登录的对象 Login login = loginDao.login(id,ename); return login; }}