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();
}
}
测试结果:
增加一行运行结果:
更新一行运行结果:
删除一行运行结果: