尚矽谷-mybatis的CRUD操作，矽谷-mybatiscrud

尚矽谷-mybatis的CRUD操作，矽谷-mybatiscrud

項目結構：

User實體類代碼：

package com.atguigu.mybatis.bean;public class User {private int id;private String name;private int age;public User() {super();}public User(int id, String name, int age) {super();this.id = id;this.name = name;this.age = age;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", age=" + age + "]";}}

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.atguigu.mybatis.bean.userMapper"><!-- CRUD操作 --><insert id="addUser" parameterType="User">insert into users(name,age) values(#{name},#{age})</insert><delete id="deleteUser" parameterType="int">delete from users where id=#{id}</delete><update id="updateUser" parameterType="User">update users set name=#{name},age=#{age} where id=#{id}</update><select id="getUser" parameterType="int" resultType="User">select * from users where id=#{id}</select><select id="getAllUsers" resultType="User">select * from users</select></mapper>

UserMapper註解類代碼（要麼用xml方式，要麼用註解方式）：

package com.atguigu.mybatis.test2;import java.util.List;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import com.atguigu.mybatis.bean.User;public interface UserMapper {@Insert("insert into users(name,age) values(#{name},#{age})")public int add(User user);@Delete("delete from users where id=#{id}")public int deleteById(int id);@Update("update users set name=#{name},age=#{age} where id=#{id}")public int update(User user);@Select("select * from users where id=#{id}")public User getById(int id);@Select("select * from users")public List<User> getAll();}

擷取SqlSessionFactory工廠的MybatisUtils代碼：

package com.atguigu.mybatis.utils;import java.io.InputStream;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class MybatisUtils {public static SqlSessionFactory getFactory() {String resource = "conf.xml";InputStream inputStream = MybatisUtils.class.getClassLoader().getResourceAsStream(resource);SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);return factory;}}

設定檔conf.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><properties resource="db.properties"/><!-- 為實體類定義別名,簡化sql映射xml檔案中的引用--><typeAliases><!-- <typeAlias type="com.atguigu.mybatis.bean.User" alias="User"/> --><!-- 該包下的所有類以其簡單類名為實體類別名（如：User類的別名為User） --><package name="com.atguigu.mybatis.bean"/></typeAliases><!-- development : 開發模式work : 工作模式 --><environments default="development"><environment id="development"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="${driver}" /><property name="url" value="${url}" /><property name="username" value="${name}" /><property name="password" value="${password}" /></dataSource></environment></environments><mappers><mapper resource="com/atguigu/mybatis/bean/userMapper.xml"/><mapper class="com.atguigu.mybatis.test2.UserMapper"/></mappers></configuration>

測試類別Test2代碼：

package com.atguigu.mybatis.test2;import java.util.List;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.junit.Test;import com.atguigu.mybatis.bean.User;import com.atguigu.mybatis.utils.MybatisUtils;/* * 測試: CRUD操作的XML的實現和註解實現 */public class Test2 {//--------------------------------測試XML的實現@Testpublic void testAdd(){SqlSessionFactory factory=MybatisUtils.getFactory();//預設是手動提交的SqlSession session=factory.openSession();String statement="com.atguigu.mybatis.bean.userMapper.addUser";int insert=session.insert(statement, new User(-1, "KK", 23));//提交事務session.commit();session.close();System.out.println(insert);}@Testpublic void testUpdate(){SqlSessionFactory factory=MybatisUtils.getFactory();//預設是手動提交SqlSession session=factory.openSession(true);String statement = "com.atguigu.mybatis.bean.userMapper.updateUser";int update =session.update(statement,new User(3, "KKK111", 25));session.close();System.out.println(update);}@Testpublic void testDelete(){SqlSessionFactory factory=MybatisUtils.getFactory();//預設是手動提交SqlSession session=factory.openSession(true);String statement = "com.atguigu.mybatis.bean.userMapper.deleteUser";int delete =session.delete(statement,3);session.close();System.out.println(delete);}@Testpublic void testGetUser(){SqlSessionFactory factory=MybatisUtils.getFactory();//預設是手動提交SqlSession session=factory.openSession(true);String statement = "com.atguigu.mybatis.bean.userMapper.getUser";User user=session.selectOne(statement, 1);session.close();System.out.println(user);}@Testpublic void testGetAll(){SqlSessionFactory factory=MybatisUtils.getFactory();//預設是手動提交SqlSession session=factory.openSession(true);String statement = "com.atguigu.mybatis.bean.userMapper.getAllUsers";List<User> list=session.selectList(statement);session.close();System.out.println(list);}//--------------------------------測試註解的實現@Testpublic void testAdd2(){SqlSessionFactory factory=MybatisUtils.getFactory();SqlSession session=factory.openSession(true);UserMapper mapper=session.getMapper(UserMapper.class);int add=mapper.add(new User(-1, "SS", 34));session.close();System.out.println(add);}}

資料庫配置代碼db.properties：

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/mybatisname=rootpassword=123456

可以在src下加入log4j的設定檔,列印日誌資訊：

      -->首先添加   log4j-1.2.16.jar

      -->然後：

        log4j.properties（方式一）

        log4j.properties，log4j.rootLogger=DEBUG, Console#Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%nlog4j.logger.java.sql.ResultSet=INFOlog4j.logger.org.apache=INFOlog4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUG

log4j.xml（方式二）

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"><appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" /></layout></appender><logger name="java.sql"><level value="debug" /></logger><logger name="org.apache.ibatis"><level value="debug" /></logger><root><level value="debug" /><appender-ref ref="STDOUT" /></root></log4j:configuration>