程序人生网站首页 程序人生

02-mybatis注解开发-xml完成基本的crud

发布时间：2025-02-02 18:46:37编辑：雪饮阅读（）

新建module，pom参考

<?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">
<modelVersion>4.0.0</modelVersion>

<groupId>org.example</groupId>
<artifactId>SpringProject2Module9</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>

<name>SpringProject2Module9 Maven Webapp</name>

<url>http://www.example.com</url>

<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>8</maven.compiler.source>
    <maven.compiler.target>8</maven.compiler.target>
</properties>

<dependencies>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.32</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
</dependencies>
</project>

src\main\resources\sqlMapConfig.xml作为mybatis配置文件参考如：

<?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"/>

    <typeAliases>
        <typeAlias type="sp29.domain.User" alias="user"/>
    </typeAliases>
    <typeHandlers>
        <typeHandler handler="sp29.handler.DateTypeHandler"/>
    </typeHandlers>
    <environments default="developement">
        <environment id="developement">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>


    <mappers>
        <mapper resource="sp29/mapper/UserMapper.xml"></mapper>
    </mappers>

</configuration>

由于数据库里面的birthday字段是从1970年到现在的时间戳的秒数，所以这里配置了

来对入库和出库的时间戳进行相应的处理。

src\main\java\sp29\handler\DateTypeHandler.java如：

package sp29.handler;

import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

public class DateTypeHandler extends BaseTypeHandler<Date> {
    //将java类型转换成数据库需要的类型
    public void setNonNullParameter(PreparedStatement preparedStatement, int i, Date date, JdbcType jdbcType) throws SQLException {
        long time = date.getTime();
        preparedStatement.setLong(i,time);
    }

    //将数据库中类型转换成java类型
    //String参数要转换的字段名称
    //ResultSet 查询出的结果集
    public Date getNullableResult(ResultSet resultSet, String s) throws SQLException {
        //获得结果集中需要的数据(long) 转换成Date类型返回
        long along=resultSet.getLong(s);
        Date date=new Date(along);
        return date;
    }

   //将数据库中类型转换成java类型
    //这里的int 参数是字段名称所在数据表中的位置
    public Date getNullableResult(ResultSet resultSet, int i) throws SQLException {
        long along=resultSet.getLong(i);
        Date date=new Date(along);
        return date;
    }

    //将数据库中类型转换成java类型
    public Date getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
        long along=callableStatement.getLong(i);
        Date date=new Date(along);
        return date;
    }
}

然后编写UserMapper.xml如D:\os\SpringWebApp\SpringProject2Module9\src\main\resources\sp29\mapper\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="sp29.dao.UserMapper">
    <insert id="save" parameterType="user">
        insert into user values(#{id},#{username},'',#{password},'',#{birthday})
    </insert>

    <update id="update" parameterType="user">
        update user set username=#{username},password=#{password} where id=#{id}
    </update>

    <delete id="delete" parameterType="int">
        delete from user where id=#{id}
    </delete>

    <select id="findById" parameterType="int" resultType="user">
        select * from user where id=#{id}
    </select>

    <select id="findAll" resultType="user">
        select * from user
    </select>
</mapper>

以及其的接口类D:\os\SpringWebApp\SpringProject2Module9\src\main\java\sp29\dao\UserMapper.java:

package sp29.dao;

import sp29.domain.User;

import java.util.List;

public interface UserMapper {
    public List<User> findAll();
    public User findById(int id);
    public void delete(int id);
    public void update(User user);
    public void save(User user);
}

这样以来基本的crud就完成了。

不过所需要的User类如D:\os\SpringWebApp\SpringProject2Module9\src\main\java\sp29\domain\User.java:

package sp29.domain;

import java.util.Date;
import java.util.List;

public class User {

    private int id;
    private String username;
    private String password;
    private Date birthday;

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public int getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", birthday=" + birthday +
                '}';
    }
}

对应的properties数据库配置文件如：D:\os\SpringWebApp\SpringProject2Module9\src\main\resources\jdbc.properties:

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://192.168.217.132/mybatis
jdbc.username=root
jdbc.password=1448169a3cb137d7

以及日志分析的配置D:\os\SpringWebApp\SpringProject2Module9\src\main\resources\log4j.properties:

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=debug, stdout

最后编写增删改查的测试类,并结合before将每个测试方法获取mapper的公共代码抽取如D:\os\SpringWebApp\SpringProject2Module9\src\test\java\sp29\MapperTest.java:

package sp29;

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.Before;
import org.junit.Test;
import sp29.dao.UserMapper;
import sp29.domain.User;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class MapperTest {
    private UserMapper mapper;
    @Before
    public void before() throws IOException{
        InputStream resourceAsStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession=sqlSessionFactory.openSession(true);
         mapper=sqlSession.getMapper(UserMapper.class);
    }
    @Test
    public void testSave(){
        User user=new User();
        user.setUsername("kasumi");
        user.setPassword("abc");
        mapper.save(user);
    }
    @Test
    public void testUpdate(){
        User user=new User();
        user.setId(17);
        user.setUsername("kasumi");
        user.setPassword("123");
        mapper.update(user);
    }
    @Test
    public void testDelete(){
        mapper.delete(17);
    }
    @Test
    public void testFindById(){
        User user=mapper.findById(1);
        System.out.println(user);
    }
    @Test
    public void testFindAll(){
        List<User> userList=mapper.findAll();
        for (User user:userList) {
            System.out.println(user);
        }
    }
}

关键字词：mybatis,crud,xml

上一篇：06-mybatis的多表操作-多对多配置实现

下一篇：03-mybatis注解开发-注解完成基本的crud

您当前的位置： 首页 > 慢生活 > 程序人生 网站首页程序人生

02-mybatis注解开发-xml完成基本的crud

相关文章

您当前的位置：首页 > 慢生活 > 程序人生网站首页程序人生