- packagecom.ibatis.test;
- importjava.io.IOException;
- importjava.io.Reader;
- importjava.sql.SQLException;
- importjava.util.Iterator;
- importjava.util.List;
- importcom.ibatis.common.resources.Resources;
- importcom.ibatis.sqlmap.client.SqlMapClient;
- importcom.ibatis.sqlmap.client.SqlMapClientBuilder;
- importcom.wyq.pojo.User;
- publicclassTestIbatis{
- publicvoidreadSqlMapConfig(){
- }
- publicstaticvoidmain(Stringargs[]){
- Readerreader=null;
- /**//*SqlMapClient是ibatis的核心组件,提供数据操作的基础平台,可以通过
- sqlMapClientBuilder创建
- *
- **/
- SqlMapClientsqlMap=null;
- Stringresource="sqlMapConfig.xml";
- try{
- reader=Resources.getResourceAsReader(resource);
- sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
- sqlMap.startTransaction();
- /**//*//数据写入操作(insert,update,delete)
- Useruser=newUser();
- user.setName("Erica");
- user.setSex(newInteger(1));
- sqlMap.insert("User.insertUser",user);*/
- /**//*//数据查询操作(select)
- Integerkey=newInteger(1);
- Userusers=(User)sqlMap.queryForObject("User.getUsers",key);
- System.out.println("id==="+users.getId());
- System.out.println("name==="+users.getName());
- System.out.println("sex==="+users.getSex());*/
- /**//*//在指定对象中放查询结果
- Integerkey=newInteger(1);
- Useruser=newUser();
- sqlMap.queryForObject("User.getUsers",key,user);
- System.out.println("id==="+user.getId());
- System.out.println("name==="+user.getName());
- System.out.println("sex==="+user.getSex());*/
- /**//*//执行批量查询
- Listlist=sqlMap.queryForList("User.getUsers",null);
- Iteratorit=list.iterator();
- while(it.hasNext()){
- Useruser=(User)it.next();
- System.out.println("id==="+user.getId());
- System.out.println("name==="+user.getName());
- System.out.println("sex==="+user.getSex());
- }*/
- /**//*//查询指定范围内的数据
- Listlist=sqlMap.queryForList("User.getUsers",null,0,3);
- Iteratorit=list.iterator();
- while(it.hasNext()){
- Useruser=(User)it.next();
- System.out.println("id==="+user.getId());
- System.out.println("name==="+user.getName());
- System.out.println("sex==="+user.getSex());
- }*/
- sqlMap.commitTransaction();
- System.out.print("操作成功!");
- }catch(IOExceptione){
- System.out.print("读取配置文件失败!");
- }catch(SQLExceptionex){
- System.out.print("操作数据出现异常!");
- }
- }
- }
【Ibatis】(二)、ibatis测试类的具体写法
最新推荐文章于 2025-07-06 20:49:17 发布