mybatis简化的增删该查

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

select * from t_user where t_id=#{t_id} insert into t_user values(#{t_id},#{t_name},#{t_password}) delete from t_user where t_id=#{t_id} update t_user set t_name=#{t_name} where t_id=#{t_id}

6.configuration.xml

7.执行增加语句:

数据库查询一下：

执行查询语句：

执行修改语句：

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

执行删除语句：

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

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。