java封装model 和 controller之间的数据和控制的三层架构

package main.demo.dao.impl; import main.demo.Entity.Emp; import main.demo.dao.EmpDao; import main.demo.mapper.RowMapper; import main.demo.mapper.impl.EmpRowMapper; import main.demo.utile.DBUtil; import main.demo.utile.DaoUtil; import main.demo.utile.DateUtil; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanHandler; import org.apache.commons.dbutils.handlers.BeanListHandler; import org.apache.commons.dbutils.handlers.ScalarHandler; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import java.text.ParseException; import java.util.ArrayList; import java.util.List; import java.util.ResourceBundle; public class EmpDaoImpl implements EmpDao { private static QueryRunner queryRunner = new QueryRunner(DBUtil.getDataSource()); private DaoUtil daoUtil = new DaoUtil(); private RowMapper rowMapper = new EmpRowMapper(); @Override public int insertEmp(Emp emp) throws SQLException, ParseException { StringBuilder stringBuilder = new StringBuilder("insert into emp (name,salary,joinDate,job,deptNo) values"); stringBuilder.append("(?,?,?,?,?)"); Connection connection = DBUtil.getConnection(); // String.valueOf(stringBuilder) // int resultSet = DaoUtil.commandUpdate(String.valueOf(stringBuilder),emp.getName(),emp.getSalary(), // DateUtil.changeUtilDateToSqlDate(emp.getJoinDate()),emp.getJob(),emp.getDeptNo()); // //使用commons-dbutils的jar包来时现增删查改 int resultSet1 = queryRunner.update(stringBuilder.toString(), emp.getName(), emp.getSalary(), DateUtil.changeUtilDateToSqlDate(emp.getJoinDate()), emp.getJob(), emp.getDeptNo()); // PreparedStatement preparedStatement = connection.prepareStatement(stringBuilder.toString()); // preparedStatement.setString(1,emp.getName()); // preparedStatement.setFloat(2,emp.getSalary()); // preparedStatement.setDate(3, DateUtil.changeUtilDateToSqlDate(emp.getJoinDate())); // preparedStatement.setString(4,emp.getJob()); // preparedStatement.setInt(5,emp.getDeptNo()); // int resultSet = preparedStatement.executeUpdate(); return resultSet1; } @Override public List query() throws SQLException { StringBuilder stringBuilder = new StringBuilder("select empNo,name,salary,joinDate,job,deptNo from emp "); List<Emp> list = daoUtil.commandQuery(String.valueOf(stringBuilder), rowMapper,null); // queryRunner.query(String.valueOf(stringBuilder),new ResourceBundle(Emp)<>) List<Emp> query = queryRunner.query(String.valueOf(stringBuilder), new BeanListHandler<Emp>(Emp.class)); return query; } @Override public Emp findByname(String name) throws SQLException { StringBuilder stringBuilder = new StringBuilder("select empNo,name,salary,joinDate,job,deptNo from emp where name = ?"); Emp query = queryRunner.query(String.valueOf(stringBuilder), new BeanHandler<Emp>(Emp.class),name); return query; } @Override public float findSinger(Object o) throws SQLException { StringBuilder stringBuilder = new StringBuilder("select max(salary) from emp"); float salary = queryRunner.query(String.valueOf(stringBuilder), new ScalarHandler<>()); return salary; } @Override public List findNumPage(int t) throws SQLException { StringBuilder stringBuilder = new StringBuilder("select empNo,name,salary,joinDate,job,deptNo from emp limit ?,?"); // List<Emp> list = daoUtil.commandQuery(String.valueOf(stringBuilder), rowMapper,(t-1)*2,2); List<Emp> query = queryRunner.query(String.valueOf(stringBuilder), new BeanListHandler<Emp>(Emp.class),(t-1)*2,2); return query; } }