SSM之mybatis连接mysql，实现单表的增删改查

mysql中的表(locale)如图:

工具：IntelliJ IDEA 2019.3.4 x64

先创建一个maven工程。

项目基本架构为 ：

在pom.xml文件中导入数据库依赖包和mybatis依赖包。

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>
<dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.6</version>
    </dependency>

先创建一个实例类Locale.java

package cn.alisa.entity;

public class Locale {
    private int localeid;
    private String localename;
    private int sublocal;

    public int getLocaleid() {
        return localeid;
    }

    public void setLocaleid(int localeid) {
        this.localeid = localeid;
    }

    public String getLocalename() {
        return localename;
    }

    public void setLocalename(String localename) {
        this.localename = localename;
    }

    public int getSublocal() {
        return sublocal;
    }

    public void setSublocal(int sublocal) {
        this.sublocal = sublocal;
    }
}

再创建一个LocaleDAO.java接口类

package cn.alisa.dao;

import cn.alisa.entity.Locale;

import java.util.List;

public interface LocaleDAO {
    public void insertLocale(Locale locale);
    public void deleteLocale(int localeid);
    public void updateLocale(Locale locale);
    public List<Locale> findAll();
    public Locale findById(int localeid);
}

创建一个resources资源包，在其下方创建mybatis.cfg.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>
    <typeAliases>
        <typeAlias type="cn.alisa.entity.Locale" alias="locale"></typeAlias>
    </typeAliases>
    <environments default="alisa">
        <environment id="alisa">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://single:3306/myshops"/>
                <property name="username" value="root"/>
                <property name="password" value="****"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mappers/locale.xml"></mapper>
    </mappers>
</configuration>

创建一个locale.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="cn.alisa.dao.LocaleDAO">
    <insert id="insertLocale" parameterType="locale">
        insert into locale values(#{localeid},#{localename},#{sublocal})
    </insert>
    <delete id="deleteLocale" parameterType="int">
        delete from locale where localeid=#{localeid}
    </delete>
    <update id="updateLocale" parameterType="locale">
        update locale set localename=#{localename},sublocal=#{sublocal} where localeid=#{localeid}
    </update>
    <select id="findAll" resultType="locale">
        select * from locale
    </select>
    <select id="findById" parameterType="int" resultType="locale">
        select * from locale where localeid=#{localeid}
    </select>
</mapper>

最后创建一个测试类MyTest.java

package cn.alisa.test;

import cn.alisa.dao.LocaleDAO;
import cn.alisa.entity.Locale;
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 MyTest {
    public static void main(String[] args) throws IOException {
        //读取配置文件
        Reader reader = Resources.getResourceAsReader("mybatis.cfg.xml");
        //根据配置获得数据库会话工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        //根据操作工厂生产操作会话
        SqlSession session = factory.openSession();
        //根据会话生成对应的数据库操作接口实例
        LocaleDAO ldao = session.getMapper(LocaleDAO.class);
        //操作接口，测试效果
//        System.out.println(ldao.findAll());
//        System.out.println(ldao.findById(2).getLocalename());
        //开启事务
/*        //增加
        Locale loc = new Locale();
        loc.setLocaleid(21);
        loc.setLocalename("扬州");
        loc.setSublocal(2);
        ldao.insertLocale(loc);
        session.commit();*/
/*        //更新
        Locale loc = new Locale();
        loc.setLocaleid(21);
        loc.setLocalename("南通");
        loc.setSublocal(2);
        ldao.updateLocale(loc);
        session.commit();*/
        //删除
        ldao.deleteLocale(21);
        session.commit();
        //关闭会话
        session.close();
    }
}

测试结果：

增加一行运行结果：

更新一行运行结果：

删除一行运行结果：