Spring-AOP-JDBC-DAO-XML语法-Servet入门

liuboss 2020-11-16

531

3.切面的名次解释，

切面= 切入点+额外功能。

几何学= 点+相同性质

******************************************************************

一，Spring与mybatis整合开发

回顾mybatis入门教程

创建数据库---创建User类进行数据库中对应字段的对应，实现get/set/

toString 方法注意必须实现空方法和全参数方法不然会报错

package com.liuboss.demo;




import java.io.Serializable;


public class User implements Serializable {
    private int id;
    private String name;
    private String pwd;


    public User() {
    }


    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }


    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                '}';
    }


    public int getId() {
        return id;
    }


    public void setId(int id) {
        this.id = id;
    }


    public String getName() {
        return name;
    }


    public void setName(String name) {
        this.name = name;
    }


    public String getPwd() {
        return pwd;
    }


    public void setPwd(String pwd) {
        this.pwd = pwd;
    }
}

2.进行log4j配置文件的导入。

3.创建UserDao接口，实现查询接口

package com.liuboss.demo;


public interface UserDao {
    public void save(User user);
}

4.创建UserMapper.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="com.liuboss.demo.UserDao">
    <insert id="save" parameterType="user">
        insert into user(id,name,pwd) values (#{id},#{name},#{pwd})
    </insert>


</mapper>

5.创建SQL主配置文件进行相应的配置。连接数据库。

并将UserMapper.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">
<!--mybatis核心配置文件-->
<configuration>
    <typeAliases>
        <typeAlias type="com.liuboss.demo.User" alias="user"/>
    </typeAliases>
    <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?useSSL=true&amp;serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

6.创建测试文件进行测试插入数据 mybatis入门代码实现‘’

package com.liuboss.demo;


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 java.io.IOException;
import java.io.InputStream;


public class TestMybatis {
    public static void main(String[] args) throws IOException {
        InputStream inputStream = Resources.getResourceAsStream("Mybatis-config.xml");
        SqlSessionFactory build = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession = build.openSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        User user = new User();
        user.setId(17);
        user.setName("明朝那些事！！");
        user.setPwd("123456");
        mapper.save(user);
        sqlSession.commit();


    }
}

数据库

文章转载自liuboss，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

Spring-AOP-JDBC-DAO-XML语法-Servet入门

评论