框架第一天作业

empTest:

public class empTest {
    public static void main(String[] args){
        try {
            InputStream inputStream = Resources.getResourceAsStream("Mybatis-config.xml");
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession session = factory.openSession();
            EmployeesMapper employeesMapper = session.getMapper(EmployeesMapper.class);
            Employees employees =  employeesMapper.findById(1);
            System.out.println(employees.getEmployee_id()+"\t"+employees.getFirst_name()+"\t"+employees.getLast_name()+"\t"+employees.getSalary()+"\t"+employees.getPhone_number()+"\t"+employees.getDepartment_id());
            boolean a = employeesMapper.add("AB","CD","1234567",20000.0,80);

            System.out.println(a);
            boolean b = employeesMapper.delete(10087);

            System.out.println(a);

            boolean c = employeesMapper.update(10086, "gai","gai", "1234567", 12345.0, 80);
            System.out.println(c);

            session.close();
        }catch (Exception e) {
            e.printStackTrace();
        }
    }
}

测试了查找和增加

控制台输出：

数据库：