奥术大师多

                     标题不能使用默认标题吗

package db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

//数据层 /持久层
//DAO =data access object 
public class EmployeeDao implements IEmployeeDao {

	// insert //delete/update/select

	// 添加到表中
	@Override
	public Integer insert(EmployeeModel model) {
		String sql = "insert  into  employee(code,name,gender,birthday,entry_date,tel,entry_time)value (?,?,?,?,?,?,?) ";
		Connection conn = null;
		PreparedStatement ps = null;
		Integer result = null;
		try {
			conn = JdbcUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, model.getCode());
			ps.setString(2, model.getName());
			ps.setString(3, model.getGender());
			ps.setString(4, model.getBirthday());
			ps.setDate(5, model.getEntryDate());
			ps.setString(6, model.getTel());
			ps.setTimestamp(7, model.getEntryTime());
			result= ps.executeUpdate();
		} catch (SQLException e) {

			e.printStackTrace();
		} finally {
			JdbcUtil.close1(conn, ps);
		}
    return result;
    
	}

	@Override
	public Integer delect(EmployeeModel model) {
		String sql = "delete from employee where code=?";
		Integer result = null;
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = JdbcUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, model.getCode());
			result = ps.executeUpdate();
		} catch (SQLException e) {

			e.printStackTrace();
		} finally {
			JdbcUtil.close1(conn, ps);
		}
		return  result ;
		

	}

	@Override
	public Integer update(EmployeeModel model) {
		String sql = "update employee set name=?,gender=?,birthday=?,entry_date=?,tel=?,entry_time=?";
		Integer result = null;
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = JdbcUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, model.getCode());
			ps.setString(2, model.getName());
			ps.setString(3, model.getGender());
			ps.setString(4, model.getBirthday());
			ps.setDate(5, model.getEntryDate());
			ps.setString(6, model.getTel());
			ps.setTimestamp(7, model.getEntryTime());
			result = ps.executeUpdate();
		} catch (SQLException e) {

			e.printStackTrace();
		} finally {
			JdbcUtil.close1(conn, ps);

		}
		return result;
	}

	private List<Object> appendwhere(StringBuffer sql, EmployeeModel model) {
		List<Object> objs = new ArrayList<>();
		String code = model.getCode();
		if (code != null && !code.trim().isEmpty()) {
			sql.append(" and code like ? ");
			objs.add(code);
		}
		String name = model.getName();
		if (name != null && !name.trim().isEmpty()) {
			sql.append(" and name like ? ");
			objs.add(name);
		}
		String gender = model.getGender();
		if (gender != null && !gender.trim().isEmpty()) {
			sql.append(" and  gender like ? ");
			objs.add(gender);
		}

		return objs;
	}

	@Override
	public List<EmployeeModel> select(EmployeeModel model) {
		// String sql = "select code,name,gender,birthday,entry_date,entry_time,tel,from
		// employee";
		StringBuffer sql = new StringBuffer("select code,name,gender,birthday,entry_date,entry_time,tel");
		sql.append(" from employee where 1=1");
		List<Object> objs = appendwhere(sql, model);
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List<EmployeeModel> result = new ArrayList<>();
		try {
			conn = JdbcUtil.getConnection();
			ps = conn.prepareStatement(sql.toString());
			for (int i = 0; i < objs.size(); i++) {
				ps.setObject(i + 1, objs.get(i));
			}
			rs = ps.executeQuery();
			while (rs.next()) {
				EmployeeModel mdb = new EmployeeModel();
				mdb.setCode(rs.getString("code"));
				mdb.setName(rs.getString("name"));
				mdb.setGender(rs.getString("gender"));
				mdb.setBirthday(rs.getString("birthday"));
				mdb.setEntryDate(rs.getDate("entry_date"));
				mdb.setEntryTime(rs.getTimestamp("entry_time"));
				mdb.setTel(rs.getString("tel"));
				result.add(mdb);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtil.close(conn, ps,rs);
		}
		return result;
	
	}

}