首页 > 编程知识 正文

mybatis和sql执行结果不一样,mybatis排序怎么写

时间:2023-05-06 11:58:56 阅读:181667 作者:4944

代码顺序--------del---- update---one---select all

package db.test2; import java.util.List; importorg.Apache.ibatis.session.SQL session; importorg.Apache.ibatis.session.sqlsessionfactory; import org.junit.Test; import db.utils.MybatisUtils; import jdbc.bean.User; public class test2{ @ testpublicvoidtestadd () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (true; string statement=' db.test2. user mapper.insertuser '; int insert=session.insert (statement,newuser(-1,' newlx ',21 ) ); //session.commit (; system.out.println(insert: ) insert; }@Testpublic void testDel () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (true; string statement=' db.test2. user mapper.deleteuser '; int del=session.delete (statement,29 ); //session.commit (; system.out.println(del: ) del; }@Testpublic void testUpdate () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (true; string statement=' db.test2. user mapper.update user '; int update=session.update (statement,newuser(4,' change ',11 ) ); //session.commit (; system.out.println(update: ) update; }@Testpublic void testSelect () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (; string statement=' db.test2. user mapper.select user '; useruser=session.selectone (statement,2 ); system.out.println(one: ) user; }@Testpublic void testSelectAll () sqlsessionfactoryfactory=mybatisutils.getfactory ); sqlsessionsession=factory.open session (; string statement=' db.test2. user mapper.selextallusers '; 列表用户=session.select list (statement; system.out.println(all: ) user; }

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。