MyBatis中的注解与C3P0练习_mybatis c3p0 注解-CSDN博客

本文链接：https://blog.csdn.net/User_manxxx/article/details/121360328

<?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>mybatis</artifactId>
    <version>1.0-SNAPSHOT</version>
    <repositories>
        <repository>
            <id>aliyun</id>
            <name>aliyun</name>
            <url>https://maven.aliyun.com/repository/public</url>
        </repository>
    </repositories>
    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.4</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.10</version>
        </dependency>
        <dependency>
            <groupId>com.github.jsqlparser</groupId>
            <artifactId>jsqlparser</artifactId>
            <version>2.0</version>
        </dependency>
    </dependencies>
</project>

<?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>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
            <property name="helperDialect" value="mysql"/>
            <property name="reasonable" value="true"/>
        </plugin>
    </plugins>
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="dataSource.C3P0DataSourceFactory">
                <property name = "driverClass" value = "com.mysql.jdbc.Driver"/>
                <property name = "jdbcUrl" value = "jdbc:mysql://localhost:3306/lx?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai&amp;allowPublicKeyRetrieval=true"/>
                <property name = "user" value = "root"/>
                <property name = "password" value = "root"/>
                <property name="initialPoolSize" value="5"/>
                <property name="maxPoolSize" value="20"/>
                <property name="minPoolSize" value="5"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <package name="dao"/>
    </mappers>
</configuration>

package dataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;

public class C3P0DataSourceFactory extends UnpooledDataSourceFactory {
    public C3P0DataSourceFactory(){
        this.dataSource = new ComboPooledDataSource();

    }
}

package mybatisutils;

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.Reader;

public class MyBatisUtils {
    private static SqlSessionFactory sqlSessionFactory = null;

    static{
        Reader reader = null;
        try{
            reader = Resources.getResourceAsReader("mybatis-config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (IOException e) {
            e.printStackTrace();
            throw new ExceptionInInitializerError(e);
        }
    }

    public static SqlSession openSession(){
        return sqlSessionFactory.openSession();
    }

    public static void closeSession(SqlSession session){
        if (session != null)
            session.close();
    }
}

package entity;

import java.sql.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;

public class Song {
    private Integer id;
    private String name;
    private String singer;
    private String category;
    private String writer;
    private String language;
    private Date issudate;

    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 String getSinger() {
        return singer;
    }

    public void setSinger(String singer) {
        this.singer = singer;
    }

    public String getCategory() {
        return category;
    }

    public void setCategory(String category) {
        this.category = category;
    }

    public String getWriter() {
        return writer;
    }

    public void setWriter(String writer) {
        this.writer = writer;
    }

    public String getLanguage() {
        return language;
    }

    public void setLanguage(String language) {
        this.language = language;
    }

    public Date getIssudate() {
        return issudate;
    }

    public void setIssudate(String time) {
        java.util.Date udTime = null;
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        try{
            udTime = sdf.parse(time);
        } catch (ParseException e) {
            e.printStackTrace();
        }
        long time0 = udTime.getTime();
        this.issudate = new java.sql.Date(time0);
    }

    @Override
    public String toString() {
        return "Song{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", singer='" + singer + '\'' +
                ", category='" + category + '\'' +
                ", writer='" + writer + '\'' +
                ", language='" + language + '\'' +
                ", issudate=" + issudate +
                '}';
    }
}

package dao;

import entity.Song;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface SongDAO {
    @Insert("insert into song(id, name, singer, category, writer, language, issudate) values(#{id}, #{name}, #{singer}, #{category}, #{writer}, #{language},#{issudate})")
    @SelectKey(statement = "select last_insert_id()", before=false, keyProperty = "id", resultType = Integer.class)
    public int insertSong(Song song);
    @Select("select * from song")
    public List<Song> selectAll();
    @Select("select * from song where category = #{category}")
    public List<Song> selectcategory(@Param("category") String category);
        @Insert({"<script>insert song(id, name, singer, category, writer, language, issudate) values " +
                "<foreach collection='list' item='record' separator=','>" +
                "(#{record.id}, #{record.name}, #{record.singer}, #{record.category}, #{record.writer}, #{record.language},#{record.issudate})"+
                "</foreach>" +
                "</script>"})
        public int selectBatch(@Param("list") List<Song> list);
    }

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import dao.SongDAO;
import entity.Song;
import mybatisutils.MyBatisUtils;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.Reader;
import java.util.ArrayList;
import java.util.List;

public class TestMyBatis {
    @Test
    public void testInsertSong(){
        SqlSession session = null;
        try{
            session = MyBatisUtils.openSession();
            Song song = new Song();
            song.setId(004);
            song.setName("对");
            song.setSinger("子");
            song.setCategory("流行歌曲");
            song.setWriter("子");
            song.setLanguage("汉语");
            song.setIssudate("2020-11-11");
            SongDAO songDAO = session.getMapper(SongDAO.class);
            int num = songDAO.insertSong(song);
            session.commit();
            System.out.println("本次提交了" + num + "条数据");
        }catch (Exception e){
            if (session != null)
                session.rollback();
        }finally{
            MyBatisUtils.closeSession(session);
        }
    }

    @Test
    public void TestSelectAll(){
        SqlSession session = null;
        try{
            session = MyBatisUtils.openSession();
            SongDAO songDAO = session.getMapper(SongDAO.class);
            List<Song> list = songDAO.selectAll();
            for (Song song : list){
                System.out.println(song);
            }
        }catch (Exception e){
            if (session != null)
                session.rollback();
        }finally{
            MyBatisUtils.closeSession(session);
        }
    }

    @Test
    public void selectCategory(){
        SqlSession session = null;
        try{
            session = MyBatisUtils.openSession();
            SongDAO songDAO = session.getMapper(SongDAO.class);
            List<Song> list = songDAO.selectcategory("流行歌曲");
            for (Song song : list){
                System.out.println(song);
            }
        }catch (Exception e){
            if (session != null)
                session.rollback();
        }finally{
            MyBatisUtils.closeSession(session);
        }
    }
    @Test
    public void TestPagehelper(){
        SqlSession session = null;
        try{
            session = MyBatisUtils.openSession();
            PageHelper.startPage(1, 2);
            SongDAO songDAO = session.getMapper(SongDAO.class);
            Page<Song> oage = (Page) songDAO.selectAll();
            System.out.println(oage.getTotal());
            System.out.println(oage.getPages());
            List<Song> list = oage.getResult();
            for (Song song : list)
                System.out.println(song);
        }catch (Exception e){
            if (session != null)
                session.rollback();
        }finally{
            MyBatisUtils.closeSession(session);
        }
    }
    @Test
    public void TestBatch(){
        SqlSession session = null;
        try{
            session = MyBatisUtils.openSession();
            List<Song> list = new ArrayList<>();
            for (int i = 10; i < 510; i++) {
                Song song = new Song();
                song.setId(i);
                song.setName("测试歌名");
                song.setSinger("测试歌手");
                song.setCategory("测试");
                song.setWriter("测试作者");
                song.setLanguage("汉语");
                song.setIssudate("2020-11-11");

                list.add(song);
            }
            SongDAO songDAO = session.getMapper(SongDAO.class);
            int num = songDAO.selectBatch(list);
            System.out.println(num);
            session.commit();
        }catch (Exception e){
            if (session != null)
                session.rollback();
        }finally{
            MyBatisUtils.closeSession(session);
        }
    }
}