1.創建一個工程 utf-8

2、導入jar

mybatis-3.2.2.jar?核心包

依賴包：

asm-3.3.1.jar

cglib-2.2.2.jar

commons-logging-1.1.1.jar

javassist-3.17.1-GA.jar

log4j-1.2.17.jar

slf4j-api-1.7.5.jar

slf4j-log4j12-1.7.5.jar

3、配置核心文件 sqlMapConfig.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><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/mybatisdb?characterEncoding=utf-8"/><property name="username" value="root"/><property name="password" value="root"/></dataSource></environment><!-- 連接數據庫的部署環境 --><environment id="product"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="com.mysql.jdbc.Driver"/><property name="url" value="jdbc:mysql://localhost:3306/mybatisdbproduct?characterEncoding=utf-8"/><property name="username" value="root"/><property name="password" value="root"/></dataSource> </environment></environments><mappers><mapper resource="com/mapping/UserMapper.xml"/></mappers> </configuration>

?

4、創建數據庫，創建表USER

create table USER_C (ID varchar(40) not null,NAME varchar(30),AGE int,ADDRESS varchar(200),primary key (ID) );--加入測試數據insert into `user_c`(`id`,`name`,`age`,`address`) values ('1','夏言',73,'桂州村'), ('2','嚴嵩',87,'分宜縣城介橋村'), ('3','徐階',80,'明松江府華亭縣'), ('4','高拱',66,'河南省新鄭市高老莊村'), ('5','張居正',58,'江陵');

?
5、映射文件 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.domain.User"><sql id="createcols">#{id},#{name},#{age},#{address}</sql><!-- 查詢所有記錄 --><select id="listAll" resultType="com.domain.User">select * from user_c</select><!-- 查詢一條 --><select id="get" parameterType="string" resultType="com.domain.User">SELECT id,name,age,address FROM user_c WHERE id=#{id}</select><!-- 新增記錄 --><insert id="create" parameterType="com.domain.User">insert into user_c (id,name,age,address) values( <include refid="createcols"/> )</insert><!-- 刪除記錄 --><delete id="delete" parameterType="string">delete from user_c where id=#{id}</delete> </mapper>

?6.PO對象

package com.domain;public class User {private String id;private String name;private Integer age;private String address;public String getId() {return id;}public void setId(String id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}public String toString(){return "id =" + id + ";name" + name + ";address=" + address + ";age=" + age;}}

?7.寫測試類

package com.test;import java.io.IOException; import java.io.InputStream; import java.util.List; import java.util.UUID;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 com.domain.User;public class TestUser {SqlSessionFactory sqlSessionFactory;@Beforepublic void initFactory() throws IOException{String configPath = "sqlMapConfig.xml";InputStream in = Resources.getResourceAsStream(configPath);sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);}@Testpublic void testListAll(){SqlSession sqlSession = sqlSessionFactory.openSession();List<User> list = sqlSession.selectList("com.domain.User.listAll");System.out.println(list.size());}@Testpublic void testGetUser(){SqlSession sqlSession = sqlSessionFactory.openSession();User user = sqlSession.selectOne("com.domain.User.get","3");System.out.println(user.toString());}@Test //新增記錄public void testCreate(){SqlSession session = sqlSessionFactory.openSession(); //獲得SqlSessionUser u = new User();u.setId(UUID.randomUUID().toString()); //產生UUID主鍵u.setName("jack");u.setAge(22);u.setAddress("beijing");int i = session.insert("com.domain.User.create", u);session.commit();System.out.println("影響條數："+i);}@Test //新增記錄public void testDelete(){SqlSession session = sqlSessionFactory.openSession(); //獲得SqlSessionint i = session.delete("com.domain.User.delete", "");session.commit();System.out.println("影響條數："+i);}}

?

轉載于:https://www.cnblogs.com/zhangshiwen/p/4340420.html

總結

以上是生活随笔為你收集整理的mybatis 3.2.2_环境搭建的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。