mybatis简化的增删该查

1.程序框架

2.oracle数据库

create table t_user(
t_id number,
t_name varchar2(10),
t_password varchar2(20)
);

3.Tuser.java

package com.eduask.pojo;

public class Tuser {
private int t_id;
private String t_name;
private String t_password;
public int getT_id() {
    return t_id;
}
public void setT_id(int t_id) {
    this.t_id = t_id;
}
public String getT_name() {
    return t_name;
}
public void setT_name(String t_name) {
    this.t_name = t_name;
}
public String getT_password() {
    return t_password;
}
public void setT_password(String t_password) {
    this.t_password = t_password;
}
public Tuser(int t_id, String t_name, String t_password) {
    super();
    this.t_id = t_id;
    this.t_name = t_name;
    this.t_password = t_password;
}
public Tuser() {
    super();
    // TODO Auto-generated constructor stub
}
@Override
public String toString() {
    return "Tuser [t_id=" + t_id + ", t_name=" + t_name + ", t_password="
            + t_password + "]";
}

}

4.UserTest.java

package com.eduask.test;
import java.io.IOException;
import java.io.InputStream;
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.eduask.pojo.Tuser;
public class UserTest {
    //初始化;
    private SqlSessionFactory sessionFactory;
    @Before
    public void up() throws IOException{
        InputStream is=Resources.getResourceAsStream("configuration.xml");
        sessionFactory=new SqlSessionFactoryBuilder().build(is);
    }
    //t_userAdd
    @Test
   public void insertUserById() throws IOException {
        SqlSession session=sessionFactory.openSession();
           Tuser t=new Tuser();
           t.setT_id(1);
           t.setT_name("link");
           t.setT_password("123456");
        int result=session.insert("insertOneUsers", t);
        if(result==1){
               System.out.println("add success");
               session.commit();
      
           }else{
               System.out.println("excute failure");
           }
           session.close();
        }    
    
    //t_userDelete
        @Test
 public void deleteUserById() throws IOException {
             SqlSession session=sessionFactory.openSession();
              int result=session.delete("deleteOneUsers", 1);
              if(result==1){
                   System.out.println("delete success");
                   session.commit();
          
               }else{
                   System.out.println("delete failure");
               }
            session.close();
         }
   //t_userSelect
       @Test
 public void selectUserById() throws IOException {
         SqlSession session=sessionFactory.openSession();
          Tuser tuser=session.selectOne("selectOneUsers", 1);
        System.out.println(tuser);
        session.close();
     }
   
    
     //t_userUpdate
          @Test
 public void updateUserById() throws IOException {
         SqlSession session=sessionFactory.openSession();
         Tuser tuser=new Tuser(1, "tom", "123456");
         tuser.setT_id(1);
         int result=session.update("updateOneUsers",tuser);
          System.out.println(result);
        if(result==1){
               System.out.println("update success");
               session.commit();
      
           }else{
               System.out.println("update failure");
           }
         session.close();
    
        
          }
}
   

5.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">
<mapper namespace="com.eduask.pojo.Tuser">
<!-- 查询一条记录 -->
<select id="selectOneUsers" resultType="com.eduask.pojo.Tuser" parameterType="int">
select * from t_user where t_id=#{t_id}
</select>
<!-- 增加一条语句 -->
<insert id="insertOneUsers" parameterType="com.eduask.pojo.Tuser">
  insert into t_user values(#{t_id},#{t_name},#{t_password})
</insert>
<!--删除一条语句  -->
<delete id="deleteOneUsers" parameterType="int">
delete from t_user where t_id=#{t_id}
</delete>
<update id="updateOneUsers"  parameterType="com.eduask.pojo.Tuser">
update t_user set t_name=#{t_name} where t_id=#{t_id}
</update>
</mapper>

6.configuration.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>
<!-- <typeAliases>
<typeAlias type="com.cb.Users"/>
</typeAliases> -->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
<property name="username" value="scott" />
<property name="password" value="tiger" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/Users.xml"/>
</mappers>
</configuration>

7.执行增加语句:

数据库查询一下：

执行查询语句：

执行修改语句：

修改之后数据库查询一下：

执行删除语句：

删除之后数据库查询一下：