java mysql分层_java操作数据库——分层开发

1 packagecom.dao;2

3 importjava.sql.ResultSet;4 importjava.sql.SQLException;5 importjava.util.ArrayList;6 importjava.util.List;7

8 importcom.pojo.Departments;9 importcom.pojo.Talents;10

11 public class TalentManageDaoImpl extends BaseDao implementsTalentManageDao{12

13 @Override14 public ListselectAllTalent() {15 String sql = "SELECT enterprisetalent.id, enterprisetalent.`name`, workingLife, workExperience,personalProfile,department.`name`,graduateSchool from enterprisetalent,department where enterprisetalent.departmentId=department.id";16 Object[] obj ={};17 List list = new ArrayList();18 Talents tal = null;19 ResultSet rs = this.executeQuery(sql, obj);20 try{21 while(rs.next()) {22 tal = newTalents();23 tal.setId(rs.getInt("id"));24 tal.setName(rs.getString("name"));25 tal.setWorkingLife(rs.getInt("workingLife"));26 tal.setWorkExperien