使用mybatis实现简单的增删改查功能

1.user实体类：
User

public class User {
 private int id;
 private String userName;
 private int userAge;
 private String userAddress;
 public int getId() {
  return id;
 }
 public void setId(int id) {
  this.id = id;
 }
 public String getUserName() {
  return userName;
 }
 public void setUserName(String userName) {
  this.userName = userName;
 }
 public int getUserAge() {
  return userAge;
 }
 public void setUserAge(int userAge) {
  this.userAge = userAge;
 }
 public String getUserAddress() {
  return userAddress;
 }
 public void setUserAddress(String userAddress) {
  this.userAddress = userAddress;
 } 
}

2.user映射类：
User.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">
<!-- namespace一定要写正确，在哪个包下的哪个类 -->
<mapper namespace="com.yihaomen.mybatis.inter.IUserOperation">
<select id="selectUserByID" parameterType="int" resultType="User">
select * from `user` where id = #{id}
</select>
<!-- 为了返回list 类型而定义的returnMap -->
<resultMap type="User" id="resultListUser">
<id column="id" property="id" />
<result column="userName" property="userName" />
<result column="userAge" property="userAge" />
<result column="userAddress" property="userAddress" />
</resultMap>
<!-- 返回list 的select 语句，注意 resultMap 的值是指向前面定义好的 -->
<select id="selectUsers" parameterType="string" resultMap="resultListUser">
select * from user where userName like #{userName}
</select>
<!-- 添加用户 -->
<insert id="addUser" parameterType="User"
useGeneratedKeys="true" keyProperty="id">
insert into user(userName,userAge,userAddress)
values(#{userName},#{userAge},#{userAddress})
</insert>
<!-- 修改用户 -->
<update id="updateUser" parameterType="User" >
update user set userName=#{userName},userAge=#{userAge},userAddress=#{userAddress} where id=#{id}
</update>
<!-- 修改用户 -->
<delete id="deleteUser" parameterType="User" >
delete from user where id=#{id}
</delete>
</mapper>

3.接口，实现用户增删改查功能：
IUserOperation

public interface IUserOperation {
 //根据id查询用户
 public User selectUserByID(int id);
 //查询所有用户
 public List selectUsers(String userName);
 //添加用户
 public void addUser(User user);
 //修改用户
 public void updateUser(User user);
    //删除用户
 public void deleteUser(int id); 
}

测试类：对增删改查用户进行相应的测试

public class Test {
 private static SqlSessionFactory sqlSessionFactory;
 private static Reader reader;
 static {
  try {
   reader = Resources.getResourceAsReader("Configuration.xml");
   sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  } catch (Exception e) {
   e.printStackTrace();
  }
 }
 public static SqlSessionFactory getSession() {
  return sqlSessionFactory;
 }
//查询全部用户
 public void getUserList(String userName) {
  SqlSession session = sqlSessionFactory.openSession();
  try {
   IUserOperation userOperation = session
     .getMapper(IUserOperation.class);
   List<User> users = (List<User>) userOperation.selectUsers(userName);
   for (User user : users) {
    System.out.println(user.getId() + ":" + user.getUserName()
      + ":" + user.getUserAddress());
   }
  } finally {
   session.close();
  }
 } 
 //添加用户
 public void addUser(){
  User user=new User();
  user.setUserAddress("人民广场");
  user.setUserName("飞鸟");
  user.setUserAge(80);
  //第 4 章 实现数据的增删改查 | 16
  SqlSession session = sqlSessionFactory.openSession();
  try {
  IUserOperation userOperation=session.getMapper(IUserOperation.class);
  userOperation.addUser(user);
  session.commit();
  System.out.println("当前增加的用户 id为:"+user.getId());
  } finally {
  session.close();
  } 
  } 
 //修改用户
 public void updateUser(){
  SqlSession session=sqlSessionFactory.openSession();
  try{
   IUserOperation userOperation=session.getMapper(IUserOperation.class);
   User user=userOperation.selectUserByID(3);
   user.setUserAddress("原来是魔都的浦东创新园区");
   userOperation.updateUser(user);
   session.commit();
   System.out.println("修改"+user.getId()+"成功");
  }finally{
   session.close();
  }
 }
 //删除用户
 public void deleteUser(){
  SqlSession session=sqlSessionFactory.openSession();
  try{
   IUserOperation userOperation=session.getMapper(IUserOperation.class);
   userOperation.deleteUser(1);
   session.commit();
  }finally{
   session.close();
  }
 } 
 public static void main(String[] args) {
  Test testUser = new Test();
  testUser.deleteUser();//这里只写了调用删除用户方法，要测试其他方法可调用相应的方法
 } 
}
//对用户进行相应的操作后，一定commit提交数据 ，否则不会对数据库操作

4.Configuration.xml：
Configuration.xml 是 mybatis 用来建立 sessionFactory 用的，里面主要包含了数据库连接相关东西，还有 java 类所对应的别名。

<?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 alias="User" type="com.yihaomen.mybatis.model.User"/>
</typeAliases>
<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:3308/mybaits" />
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/yihaomen/mybatis/model/User.xml"/>
</mappers>
</configuration>

最后提醒：不要忘了在项目的lib下导入所需的mybatis及mysql包