北大青鸟BCSP8.0-6-19考试个人简历系统

package com.bdqn.HongJinyu.dao; import com.bdqn.HongJinyu.entity.Resume; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class ResumeDaoImpl extends BaseDao implements ResumeDao { @Override /*A实现编写查询方法,并按时间降序*/ public List<Resume> FindBysex(String sex) { List<Resume> resumeList = new ArrayList<>(); Connection conn = getConnection(); PreparedStatement ps = null; ResultSet rs = null; //查询所有数据 //String sql="SELECT * FROM resume ORDER BY `birth` DESC"; StringBuffer sql = new StringBuffer("SELECT * FROM resume WHERE 1 = 1"); if (sex!=null){ sql.append(" AND sex ='"+sex+"'"); } sql.append(" ORDER BY `birth` DESC"); try { ps = conn.prepareStatement(sql.toString()); rs = ps.executeQuery(); while(rs.next()){ Resume rsue = new Resume(); rsue.setId(rs.getInt("id")); rsue.setUserName(rs.getString("userName")); rsue.setSex(rs.getString("sex")); rsue.setBirth(rs.getDate("birth")); rsue.setAddress(rs.getString("address")); rsue.setTelephone(rs.getString("telephone")); rsue.setSchool(rs.getString("school")); rsue.setStatus(rs.getInt("status")); resumeList.add(rsue); } } catch (SQLException throwables) { throwables.printStackTrace(); }finally { close(conn,ps,rs); } return resumeList; } @Override /*B实现判断电话号码是否重复*/ public int FindBytelephone(String telephone) { int numer =-1; Connection conn = getConnection(); PreparedStatement ps = null; ResultSet rs = null; String sql="SELECT COUNT(1) FROM resume WHERE telephone=?"; try { ps = conn.prepareStatement(sql); ps.setString(1,telephone); rs = ps.executeQuery(); while(rs.next()){ numer=rs.getInt(1); } } catch (SQLException throwables) { throwables.printStackTrace(); }finally { close(conn,ps,rs); } return numer; } @Override /*C实现添加的方法*/ public int AddrByesume(Resume resume) { String sql = "INSERT INTO resume(userName,sex,birth,address,telephone,school,`status`)VALUES (?,?,?,?,?,?,?)"; Object []objects = new Object[]{ resume.getUserName(), resume.getSex(), resume.getBirth(), resume.getAddress(), resume.getTelephone(), resume.getSchool(), resume.getStatus() }; return updateAll(sql,objects); } @Override /*D实现根据Id删除的方法*/ public int DeleteByid(Integer id) { String sql ="DELETE FROM resume WHERE id =?"; Object []objects =new Object[]{id}; return updateAll(sql,objects); } }