当前位置:首页 » 《随便一记》 » 正文

JAVA EE——案例:员工管理系统

14 人参与  2023年03月29日 17:45  分类 : 《随便一记》  评论

点击全文阅读


目录

1.题目 

2.文件目录 

3. 引入依赖——pom.xml

4.配置文件——myBatis-config.xml

5.映射文件——EmployeeMapper.xml

6.java类——Employee.java

7.接口类——EmployeeMapper.java

8.测试类——MyBatisTest.java

(1)根据id查询员工信息

(2)新增员工信息

(3)根据id更新员工信息

(4)根据id删除员工信息

9.数据库运行截图

(1)根据id查询员工信息

(2)新增员工信息

(3)根据id更新员工信息

(4)根据id删除员工信息


1.题目 

在数据库创建一个employee表,在MyBatis环境下完成一个员工管理系统。该系统实现以下几个功能。

 (1)在MyBatisTest测试类中添加findByIdTest()方法,用于根据id查询员工信息。

 (2)在MyBatisTest测试类中添加insertEmployeeTest()方法,用于新增员工信息。

 (3)在MyBatisTest测试类中添加updateEmployeeTest()方法,用于根据id更新员工信息。

 (4)在MyBatisTest测试类中添加deleteEmployeeTest()方法,用于根据id删除员工信息。

员工编号(id)员工名称(name)员工年龄(age)员工职位(position)
1张三20员工
2李四18员工
3王五35经理

2.文件目录 

3. 引入依赖——pom.xml

<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">    <parent>        <artifactId>mybatistest</artifactId>        <groupId>org.example</groupId>        <version>1.0-SNAPSHOT</version>    </parent>    <modelVersion>4.0.0</modelVersion>    <groupId>org.example1</groupId>    <artifactId>Mybatis_demo2</artifactId>    <packaging>jar</packaging>    <dependencies>        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.5.2</version>        </dependency>        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>8.0.28</version>        </dependency>        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.12</version>            <scope>test</scope>        </dependency>    </dependencies></project>

4.配置文件——myBatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <environments default="development">        <environment id="development">            <transactionManager type="JDBC"/>            <dataSource type="POOLED">                <property name="driver" value="com.mysql.jdbc.Driver"/>                <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>                <property name="username" value="root"/>                <property name="password" value="12345678"/>            </dataSource>        </environment>    </environments>    <mappers>        <mapper resource="mappers/EmployeeMapper.xml"/>    </mappers></configuration>

5.映射文件——EmployeeMapper.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"        "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="org.example1.mapper.EmployeeMapper">    <select id="findById" resultType="org.example1.pojo.Employee">        select * from employee where id = 01    </select>    <insert id="insertEmployee">        insert into employee values(02,'李四',18,'员工')    </insert>    <update id="updateEmployee">        update employee set name='刘六',age=27,position='经理' where id=02    </update>    <delete id="deleteEmployee">        delete from employee where id = 03    </delete></mapper>

6.java类——Employee.java

package org.example1.pojo;public class Employee {    private Integer id;    private String name;    private Integer age;    private String position;    public Employee(Integer id, String name, Integer age, String position) {        this.id = id;        this.name = name;        this.age = age;        this.position = position;    }    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public Integer getAge() {        return age;    }    public void setAge(Integer age) {        this.age = age;    }    public String getPosition() {        return position;    }    public void setPosition(String position) {        this.position = position;    }    @Override    public String toString() {        return "Employee{" +                "id=" + id +                ", name='" + name + '\'' +                ", age=" + age +                ", position='" + position + '\'' +                '}';    }}

7.接口类——EmployeeMapper.java

package org.example1.mapper;import org.example1.pojo.Employee;public interface EmployeeMapper {    //新增员工信息    int insertEmployee();    //根据id查询员工信息    Employee findById();    //更新员工信息    void updateEmployee();    //删除员工信息    void deleteEmployee();}

8.测试类——MyBatisTest.java

(1)根据id查询员工信息

package org.example1.test;import org.example1.mapper.EmployeeMapper;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.example1.pojo.Employee;import org.junit.Test;import java.io.IOException;import java.io.InputStream;public class MyBatisTest {    @Test    public void insertEmployeeTest() throws IOException {        //加载核心配置文件        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        //获取SqlSessionFactoryBuilder        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();        //获取SqlSessionFactory        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);        //获取SqlSession        SqlSession sqlSession = sqlSessionFactory.openSession(true);        //获取mapper接口对象        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        //测试功能        int result = mapper.insertEmployee();        //提交事务        //sqlSession.commit();        System.out.println("result:"+result);    }    @Test    public void findByIdTest() throws IOException {        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);        SqlSession sqlSession = sqlSessionFactory.openSession(true);        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        //mapper.updateEmployee();        //mapper.deleteEmployee();        Employee employee = mapper.findById();        System.out.println(employee);    }}

(2)新增员工信息

package org.example1.test;import org.example1.mapper.EmployeeMapper;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test;import java.io.IOException;import java.io.InputStream;public class MyBatisTest {    @Test    public void insertEmployeeTest() throws IOException {        //加载核心配置文件        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        //获取SqlSessionFactoryBuilder        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();        //获取SqlSessionFactory        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);        //获取SqlSession        SqlSession sqlSession = sqlSessionFactory.openSession(true);        //获取mapper接口对象        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        //测试功能        int result = mapper.insertEmployee();        //提交事务        //sqlSession.commit();        System.out.println("result:"+result);    }    /*@Test    public void updateEmployeeTest() throws IOException {        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);        SqlSession sqlSession = sqlSessionFactory.openSession(true);        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        mapper.updateEmployee();        //mapper.deleteEmployee();        //Employee employee = mapper.findById();        //System.out.println(employee);    }*/}

(3)根据id更新员工信息

package org.example1.test;import org.example1.mapper.EmployeeMapper;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.example1.pojo.Employee;import org.junit.Test;import java.io.IOException;import java.io.InputStream;public class MyBatisTest {    @Test    public void insertEmployeeTest() throws IOException {        //加载核心配置文件        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        //获取SqlSessionFactoryBuilder        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();        //获取SqlSessionFactory        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);        //获取SqlSession        SqlSession sqlSession = sqlSessionFactory.openSession(true);        //获取mapper接口对象        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        //测试功能        int result = mapper.insertEmployee();        //提交事务        //sqlSession.commit();        System.out.println("result:"+result);    }    @Test    public void updateEmployeeTest() throws IOException {        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);        SqlSession sqlSession = sqlSessionFactory.openSession(true);        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        mapper.updateEmployee();        //mapper.deleteEmployee();        //Employee employee = mapper.findById();        //System.out.println(employee);    }}

(4)根据id删除员工信息

package org.example1.test;import org.example1.mapper.EmployeeMapper;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.example1.pojo.Employee;import org.junit.Test;import java.io.IOException;import java.io.InputStream;public class MyBatisTest {    @Test    public void insertEmployeeTest() throws IOException {        //加载核心配置文件        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        //获取SqlSessionFactoryBuilder        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();        //获取SqlSessionFactory        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);        //获取SqlSession        SqlSession sqlSession = sqlSessionFactory.openSession(true);        //获取mapper接口对象        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        //测试功能        //int result = mapper.insertEmployee();        //提交事务        //sqlSession.commit();        //System.out.println("result:"+result);    }    @Test    public void deleteEmployeeTest() throws IOException {        InputStream is = Resources.getResourceAsStream("mybatis-config.xml");        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);        SqlSession sqlSession = sqlSessionFactory.openSession(true);        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);        //mapper.updateEmployee();        mapper.deleteEmployee();        //Employee employee = mapper.findById();        //System.out.println(employee);    }}

9.数据库运行截图

(1)根据id查询员工信息

(2)新增员工信息

(3)根据id更新员工信息

(4)根据id删除员工信息

 


点击全文阅读


本文链接:http://zhangshiyu.com/post/57145.html

<< 上一篇 下一篇 >>

  • 评论(0)
  • 赞助本站

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

关于我们 | 我要投稿 | 免责申明

Copyright © 2020-2022 ZhangShiYu.com Rights Reserved.豫ICP备2022013469号-1