Eclipse+Java+Swing实现企业人事管理系统

}

public static List findAllDept() {

try {

String sql = “select * from tb_dept”;

List tbDept = template.query(sql, new BeanPropertyRowMapper(TbDept.class));

return tbDept;

} catch (DataAccessException e) {

e.printStackTrace();

return null;

}

}

public static int findDeptIdByName(String item) {

String sql = “select * from tb_dept where name=?”;

TbDept dept = template.queryForObject(sql, new BeanPropertyRowMapper(TbDept.class), item);

return dept.getId();

}

public static List findAllDeptExceptZero() {

try {

String sql = “select * from tb_dept where id<>0”;

List tbDept = template.query(sql, new BeanPropertyRowMapper(TbDept.class));

return tbDept;

} catch (DataAccessException e) {

e.printStackTrace();

return null;

}

}

public static TbDept findDeptByName(String name) {

try {

String sql = “select * from tb_dept where name=?”;

TbDept dept = template.queryForObject(sql, new BeanPropertyRowMapper(TbDept.class), name);

return dept;

} catch (DataAccessException e) {

e.printStackTrace();

return null;

}

}

public static void addDept(TbDept d2) {

try {

String sql = “insert into tb_dept(name) values (?)”;

template.update(sql, d2.getName());

} catch (DataAccessException e) {

e.printStackTrace();

}

}

public static void deleteDeptById(int id) {

try {

String sql = “delete from tb_dept where id=?”;

template.update(sql, id);

} catch (DataAccessException e) {

e.printStackTrace();

}

}

public static void updateDept(int id, String input) {

try {

String sql = “update tb_dept set name = ? where id = ?”;

template.update(sql, input, id);

} catch (Exception e) {

e.printStackTrace();

}

}

}

[](()PersonDao.java

---

package com.sjsq.dao;

import java.util.List;

import com.sjsq.model.TbPerson;

import org.springframework.dao.DataAccessException;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.JdbcTemplate;

import com.sjsq.tools.JDBCUtils;

import com.sjsq.tools.PwEncryption;

public class PersonDao {

private static JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

public static TbPerson queryRecordByNum(String num) {

try {

String sql = “select * from tb_person where record_number=?”;

TbPerson tbRecord = template.queryForObject(sql, new BeanPropertyRowMapper(TbPerson.class), num);

return tbRecord;

} catch (DataAccessException e) {

e.printStackTrace();

return null;

}

}

public static List findAllPerson() {

try {

String sql = “select * from tb_person”;

List tbPerson = template.query(sql, new BeanPropertyRowMapper(TbPerson.class));

return tbPerson;

} catch (DataAccessException e) {

e.printStackTrace();

return null;

}

}<