← 返回学习路线

SYSTEM

代码实现

Java基础代码实现system
src/content/notes/system/代码实现.md

代码实现

  • 实体类

    public class Student {
        private Integer id;
        private String name;
        private Integer age;
        .....
    }
  • StudentMapper

    public interface StudentMapper {
        //查询全部
        public abstract List<Student> selectAll();
    
        //根据id查询
        public abstract Student selectById(Integer id);
    
        //新增数据
        public abstract Integer insert(Student stu);
    
        //修改数据
        public abstract Integer update(Student stu);
    
        //删除数据
        public abstract Integer delete(Integer id);
    }
  • config.properties

    driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://192.168.2.184:3306/db1
    username=root
    password:[已隐藏]
  • MyBatisConfig.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>
        <!--引入数据库连接的配置文件-->
        <properties resource="jdbc.properties"/>
        
        <!--配置LOG4J-->
        <settings>
            <setting name="logImpl" value="log4j"/>
        </settings>
        
        <!--起别名-->
        <typeAliases>
            <typeAlias type="bean.Student" alias="student"/>
            <!--<package name="bean"/>-->
        </typeAliases>
    
        <!--配置数据库环境,可以多个环境,default指定哪个-->
        <environments default="mysql">
            <!--id属性唯一标识-->
            <environment id="mysql">
                <!--事务管理,type属性,默认JDBC事务-->
                <transactionManager type="JDBC"></transactionManager>
                <!--数据源信息   type属性连接池-->
                <dataSource type="POOLED">
                    <!--property获取数据库连接的配置信息-->
                    <property name="driver" value="${driver}"/>
                    <property name="url" value="${url}"/>
                    <property name="username" value="${username}"/>
                    <property name="password" value="${password}"/>
                </dataSource>
            </environment>
        </environments>
    
        <!--引入映射配置文件-->
        <mappers>
            <!--mapper引入指定的映射配置 resource属性执行的映射配置文件的名称-->
            <mapper resource="StudentMapper.xml"/>
        </mappers>
    </configuration>
  • StudentMapper.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="StudentMapper">
        <select id="selectAll" resultType="student">
            SELECT * FROM student
        </select>
    
        <select id="selectById" resultType="student" parameterType="int">
            SELECT * FROM student WHERE id = #{id}
        </select>
    
        <insert id="insert" parameterType="student">
            INSERT INTO student VALUES (#{id},#{name},#{age})
        </insert>
    
        <update id="update" parameterType="student">
            UPDATE student SET name = #{name}, age = #{age} WHERE id = #{id}
        </update>
    
        <delete id="delete" parameterType="student">
            DELETE FROM student WHERE id = #{id}
        </delete>
    
    </mapper>
  • 控制层测试代码:根据 id 查询

    @Test
    public void selectById() throws Exception{
        //1.加载核心配置文件
        InputStream is = Resources.getResourceAsStream("MyBatisConfig.xml");
    
        //2.获取SqlSession工厂对象
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(is);
    
        //3.通过工厂对象获取SqlSession对象
        SqlSession sqlSession = ssf.openSession();
    
        //4.执行映射配置文件中的sql语句,并接收结果
        Student stu = sqlSession.selectOne("StudentMapper.selectById", 3);
    
        //5.处理结果
        System.out.println(stu);
    
        //6.释放资源
        sqlSession.close();
        is.close();
    }
  • 控制层测试代码:新增功能

    @Test
    public void insert() throws Exception{
        //1.加载核心配置文件
        //2.获取SqlSession工厂对象
        //3.通过工厂对象获取SqlSession对象
        SqlSession sqlSession = sqlSessionFactory.openSession(true);
    
        //4.执行映射配置文件中的sql语句,并接收结果
        Student stu = new Student(5, "周七", 27);
        int result = sqlSession.insert("StudentMapper.insert", stu);
    
        //5.提交事务
        //sqlSession.commit();
    
        //6.处理结果
        System.out.println(result);
    
        //7.释放资源
        sqlSession.close();
        is.close();
    }