SSM框架整合——配置Mybatis

SSM框架配置，简单应用

先由底层的Mybatis框架起

项目结构

1.POJO创建

根据数据库创建数据表类


生成get/set方法后toString方法也可以生成一下

---

2.创建UserDao接口

将要操作CRUD方法都写进接口

3.建立与UserDao接口对应的UserMapper.xml

<mapper namespace="com.ronghao.Dao.UserDao">

    <insert id="insertUser" parameterType="User">
        insert into user(username,phonenumber,email,password) VALUES(#{username},#{phonenumber},#{email},#{password})
    </insert>
    
    <select id="selectAllUser" resultType="User">
        select * from user;
    </select>

</mapper>

---

4.配置Mybatis

使用jdbc.properties 进行配置

jdbc.url=jdbc:mysql://localhost:3306/blog?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
jdbc.driverClass=com.mysql.jdbc.Driver

<configuration>
<!--    读取jdbc.properties-->
    <properties resource="jdbc.properties"/>
<!--    起别名，如果没有别名，在UserMapper.xml里面的参数类型要加上全限定类名-->
    <typeAliases>
        <package name="com.ronghao.pojo"/>
    </typeAliases>
<!--    JDBC环境配置-->
    <environments default="JDBC">
        <environment id="JDBC">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
<!--                通过${}字符串替代来写入配置-->
                <property name="url" value="${jdbc.url}"/>
                <property name="driver" value="${jdbc.driverClass}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
<!--        映射xml配置-->
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

---

5.创建测试类

public class test {
    UserDao mapper=null;
    SqlSession sqlSession=null;

    @Before
    public void before() throws Exception {
        InputStream resourceAsStream = Resources.getResourceAsStream("MybatisConfig.xml");
        SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
        sqlSession = build.openSession();
        mapper = sqlSession.getMapper(UserDao.class);
    }
    @After
    public void after()
    {
        sqlSession.commit();
    }
    @Test
    public void insertuser() throws Exception {
        User user=new User();
        user.setPhonenumber("123456789");
        user.setUsername("lilei");
        user.setEmail("020202@qq.com");
        user.setPassword("999999");

        mapper.insertUser(user);
        sqlSession.commit();
    }
    @Test
    public void selectUser() throws Exception {
        List<User> users = mapper.selectAllUser();
        for (User user :
                users) {
            System.out.println(user.toString());
        }
    }
}

---

我已经上传项目到我的资源上了
SSM简单整合

---

**

有遇到问题可以私信，24小时内必回

**