//增删改查
1 package TestDemo; 2 3 import java.io.IOException; 4 import java.io.InputStream; 5 import java.util.Date; 6 import java.util.List; 7 8 import org.apache.ibatis.io.Resources; 9 import org.apache.ibatis.session.SqlSession; 10 import org.apache.ibatis.session.SqlSessionFactory; 11 import org.apache.ibatis.session.SqlSessionFactoryBuilder; 12 import org.junit.Test; 13 14 import cn.jy.mybatis.pojo.User; 15 16 public class MybatisMapperTest { 17 //@Test 18 //public void fun() throws IOException{ 19 // //1加载核心配置文件 20 // String re="sqlMapConfig.xml"; 21 // InputStream resourceAsStream = Resources.getResourceAsStream(re); 22 // //创建SqlSessionFactory 23 // SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); 24 // //创建回话 25 // SqlSession openSession = build.openSession(); 26 // Object selectOne = openSession.selectOne("test.findUserById",10); 27 // System.out.println(selectOne); 28 //} 29 30 31 // @Test 32 // public void fun() throws IOException{ 33 // //1加载核心配置文件 34 // String re="sqlMapConfig.xml"; 35 // InputStream resourceAsStream = Resources.getResourceAsStream(re); 36 // //创建SqlSessionFactory 37 // SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); 38 // //创建回话 39 // SqlSession openSession = build.openSession(); 40 // List<User> selectList = openSession.selectList("test.findUserByUserName","小明"); 41 // for(User a:selectList){ 42 // System.out.println(a); 43 // } 44 // 45 // } 46 //插入一条数据 47 // @Test 48 // public void fun() throws IOException{ 49 // //1加载核心配置文件 50 // String re="sqlMapConfig.xml"; 51 // InputStream resourceAsStream = Resources.getResourceAsStream(re); 52 // //创建SqlSessionFactory 53 // SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); 54 // //创建回话 55 // SqlSession openSession = build.openSession(); 56 // User u=new User(); 57 // u.setUsername("张无忌"); 58 // u.setBirthday(new Date()); 59 // u.setAddress("郑州杨金路"); 60 // u.setSex("男"); 61 // int insert = openSession.insert("test.insertUser",u); 62 // openSession.commit(); 63 // System.out.println(insert); 64 // } 65 66 //更新数据 67 // @Test 68 // public void fun() throws IOException{ 69 // //1加载核心配置文件 70 // String re="sqlMapConfig.xml"; 71 // InputStream resourceAsStream = Resources.getResourceAsStream(re); 72 // //创建SqlSessionFactory 73 // SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); 74 // //创建回话 75 // SqlSession openSession = build.openSession(); 76 // User u=new User(); 77 // u.setId(27); 78 // u.setUsername("张无忌666"); 79 // u.setBirthday(new Date()); 80 // u.setAddress("郑州杨金路qy95"); 81 // u.setSex("男"); 82 // int update = openSession.update("test.updateUserById",u); 83 // openSession.commit(); 84 // System.out.println(update); 85 // } 86 //删除数据 87 @Test 88 public void fun() throws IOException{ 89 //1加载核心配置文件 90 String re="sqlMapConfig.xml"; 91 InputStream resourceAsStream = Resources.getResourceAsStream(re); 92 //创建SqlSessionFactory 93 SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); 94 //创建回话 95 SqlSession openSession = build.openSession(); 96 openSession.delete("test.deleteUserById",27); 97 openSession.commit(); 98 } 99 }
//sqlMap文件下User.xml
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE mapper 3 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 4 "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 5 <mapper namespace="test" > 6 <select id="findUserById" parameterType="Integer" resultType="cn.jy.mybatis.pojo.User"> 7 select * from user where id=#{id} 8 </select> 9 <select id="findUserByUserName" parameterType="String" resultType="cn.jy.mybatis.pojo.User"> 10 select * from user where username like "%"#{username}"%" 11 </select> 12 <insert id="insertUser" parameterType="cn.jy.mybatis.pojo.User" > 13 insert into user(username,birthday,address,sex)values(#{username},#{birthday},#{address},#{sex}) 14 </insert> 15 <update id="updateUserById" parameterType="cn.jy.mybatis.pojo.User" > 16 update user 17 set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id} 18 </update> 19 <delete id="deleteUserById" parameterType="Integer" > 20 delete from user 21 where id=#{id} 22 </delete> 23 </mapper>
//日志文件log4j.properties
1 # Global logging configuration 2 log4j.rootLogger=DEBUG, stdout 3 # Console output... 4 log4j.appender.stdout=org.apache.log4j.ConsoleAppender 5 log4j.appender.stdout.layout=org.apache.log4j.PatternLayout 6 log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
//主映射文件 加下面连接配置文件sqlMapConfig.xml
1 <?xml version="1.0" encoding="UTF-8" ?> 2 <!DOCTYPE configuration 3 PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 4 "http://mybatis.org/dtd/mybatis-3-config.dtd"> 5 <configuration> 6 7 <!-- 别名 包以其子包下所有类 头字母大小都行--> 8 <typeAliases> 9 <!-- <typeAlias type="cn.lijun.mybatis.pojo.User" alias="User"/> --> 10 <package name="cn.jy.mybatis.pojo"/> 11 </typeAliases> 12 <!-- 和spring整合后 environments配置将废除 --> 13 <environments default="development"> 14 <environment id="development"> 15 <!-- 使用jdbc事务管理 --> 16 <transactionManager type="JDBC" /> 17 <!-- 数据库连接池 --> 18 <dataSource type="POOLED"> 19 <property name="driver" value="com.mysql.jdbc.Driver" /> 20 <property name="url" 21 value="jdbc:mysql://localhost:3306/day58?characterEncoding=utf-8" /> 22 <property name="username" value="root" /> 23 <property name="password" value="root" /> 24 </dataSource> 25 </environment> 26 </environments> 27 <mappers> 28 <mapper resource="sqlMap/User.xml"/> 29 </mappers> 30 </configuration>