用JAVA写个简单的员工信息系统吧

闲来无事写个员工信息系统。

连接的My SQL数据库，其中需要导一些jar包，大家自行百度maven repository下载吧~

接下来上代码，有问题可以评论区讨论：

test（测试）类：

package empmanager.test;

import empmanager.dao.EmpDao;
import empmanager.dao.impl.EmpDaoImpl;
import empmanager.model.Emp;
import org.junit.Test;

import java.util.Date;
import java.util.List;

public class TestEmpDao {

    private EmpDao empDao = new EmpDaoImpl();
    @Test
    public void testFindAll(){
        List<Emp> list = empDao.findAll();
        System.out.println(list);
    }

    @Test
    public void testFindByID(){
        Emp Eid = empDao.findByID(1);
        System.out.println(Eid);
    }
    @Test
    public void testAddEmp(){
        Emp emp = new Emp(15,"Vic",1003,7,new Date(),5000.0,2000.0,10);
        boolean b = empDao.addEmp(emp);
        System.out.println(b);
    }
    @Test
    public void testUpdateEmp(){
        boolean bool = empDao.updateEmp(1,13000.0);
        System.out.println(bool);
    }
    @Test
    public void testDeleteEmp(){
        boolean b = empDao.deleteEmp(2);
        System.out.println(b);
    }
}

DruidUtil（工具）类：我用的是druid连接池

package empmanager.util;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DruidUtil {
    private static DataSource dataSource;
    /**
     * 静态代码块 加载配置文件
     */
    static {
        Properties props = new Properties();
        try {
            props.load(new FileInputStream("src/druid/druid.properties"));
            // 获取连接池
            dataSource = DruidDataSourceFactory.createDataSource(props);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    /**
     * 获取连接
     * @return
     * @throws SQLException
     */
    public static Connection getConnection() {
        Connection conn = null;
        try {
            conn = dataSource.g