第一步：创建一个Java Project 导入相应的jar包

在src下加入日志文件log4j.properties

1 # Global logging configuration2 #\u5728\u5f00\u53d1\u73af\u5883\u4e0b\u65e5\u5fd7\u7ea7\u522b\u8981\u8bbe\u7f6e\u6210DEBUG\uff0c\u751f\u4ea7\u73af\u5883\u8bbe\u7f6e\u6210info\u6216error3 log4j.rootLogger=DEBUG, stdout4 # Console output...5 log4j.appender.stdout=org.apache.log4j.ConsoleAppender6 log4j.appender.stdout.layout=org.apache.log4j.PatternLayout7 log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

在src下加入数据库信息文件db.properties

1 jdbc.driver=com.mysql.jdbc.Driver2 jdbc.url=jdbc:mysql://localhost:3306/mydb?characterEncoding=utf-83 jdbc.username=root4 jdbc.password=dielianhua

需要操作数据库---》创建数据库mydb 创建表user

第二步：加载spring的核心配置文件applicationContext.xml、加载Mybatis的核心配置文件sqlMapConfig.xml

1 
      2 
      3 
     
      16     17     
      18     
      19 20     
      21     
      
       23     
       24     
       25     
       26     
       27     
       28     
       29     
      30     31     
      32     
      
       33     
       34     
       35     
       36     
      37     38     
      39     
      
       40     
       41     
       42     
      43     44     
      45     
      
       46     
       47     
       48     
       49     
       50     
      51 
     

1 
      2  5 
     
       6      7     
      
        8         
        9     
      10     11 
     

第三步：创建Pojo类User.java

1 package com.cn.pojo; 2  3 public class User { 4  5     private Integer id; 6     private String uname; 7     private String upsw; 8     private String usex; 9     public Integer getId() {10         return id;11     }12     public void setId(Integer id) {13         this.id = id;14     }15     public String getUname() {16         return uname;17     }18     public void setUname(String uname) {19         this.uname = uname;20     }21     public String getUpsw() {22         return upsw;23     }24     public void setUpsw(String upsw) {25         this.upsw = upsw;26     }27     public String getUsex() {28         return usex;29     }30     public void setUsex(String usex) {31         this.usex = usex;32     }33     34     public User(Integer id, String upsw) {35         super();36         this.id = id;37         this.upsw = upsw;38     }39     public User() {40         super();41     }42     public User(Integer id, String uname, String upsw, String usex) {43         super();44         this.id = id;45         this.uname = uname;46         this.upsw = upsw;47         this.usex = usex;48     }49     @Override50     public String toString() {51         return "User [id=" + id + ", uname=" + uname + ", upsw=" + upsw + ", usex=" + usex + "]";52     }53     54 }

第四步：利用Mapper动态代理实现CRUD接口功能

1 package com.cn.mapper; 2  3 import java.io.Serializable; 4 import java.util.List; 5  6 import com.cn.pojo.User; 7  8 public interface UserMapper { 9     10     public void add(User user);11     public void deleteById(Serializable id);12     public void updateById(User user);13     public List
     
       findAll();14     public User findById(Serializable id);15     16 }
     

1 
      2  4 
     
       5 
       6 
      
        7 insert into user values(#{id},#{uname},#{upsw},#{usex}) 8 
       9 10 
      11 
      
       12 delete from user where id=#{id}13 
      14 15 
      16 
      
       17 update user set upsw=#{upsw} where id=#{id}18 
      19 20 
      21 
      22 select * from user23 24 
      25 select * from user where id=#{id}26 27 
     

第五步：编写测试类

1 package com.cn.test; 2  3 import java.util.List; 4  5 import org.junit.Test; 6 import org.springframework.context.ApplicationContext; 7 import org.springframework.context.support.ClassPathXmlApplicationContext; 8  9 import com.cn.mapper.UserMapper;10 import com.cn.pojo.User;11 12 public class TestUserMapper {13 14     ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml"); 15     UserMapper userMapper = applicationContext.getBean(UserMapper.class);16     @Test17     public void testAdd() throws Exception {18         User user = new User(0003,"格格","0099","女");19         userMapper.add(user);20     }21     @Test22     public void testDelete() throws Exception {23         userMapper.deleteById(0003);24     }25     @Test26     public void testUpdate() throws Exception {27         User user = new User();28         user.setId(0001);29         user.setUpsw("2200");30         userMapper.updateById(user);31     }32     @Test33     public void testFindAll() throws Exception {34         List
     
       users = userMapper.findAll();35         for(User user : users) {36             System.out.println(user);37         }38     }39     @Test40     public void testFindById() throws Exception {41         User user = userMapper.findById(0001);42         System.out.println(user);43     }44 }