类_试_测_的_ibatis

package com.ibatis.example;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class Test
{
private static SqlMapClient sqlMap = null;
public static void main(String[] args) throws SQLException
{
buildConfig();//加载配置
getAll();//查询所有数据
//getById(1); //根据Id查询
//add();//添加对象
//del(1);//根据主键删除
//update();//修改
}
public static void buildConfig()//加载配置
{
try
{
//配置文件的位置：默认在src目录下，如果存放其他位置，就加上相应的包名如："com.ibatis.example.sqlMapConfig.xml"
String resource = "sqlMapConfig.xml"; //$NON-NLS-1$
Reader reader = Resources.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
}
catch (IOException e)
{
e.printStackTrace();
}
}
public static void getById(int key) throws SQLException//根据Id查询
{
UserInfo userInfo = null;
Object object = sqlMap.queryForObject("getUserInfo", key);
{
userInfo = (UserInfo)object;
}
System.out.println("查询到对象：" + userInfo);
}
public static void getAll() throws SQLException //查询所有UserInfo
{
sqlMap.startTransaction();
List<?> list = sqlMap.queryForList("getAllUserInfo", null);
System.out.println(list.size());
sqlMap.commitTransaction();
}
public static void login() throws SQLException //多条件查询，方式一
{
String sql = "uAddress='a' and uSex='a'";
List queryForList = sqlMap.queryForList("login", sql);
for (int i = 0; i < queryForList.size(); i++)
{
System.out.println(queryForList.get(i));
}
}
public static void login2() throws SQLException //多条件查询，方式二(建议用)
{
UserInfo userInfo = new UserInfo();
Map map = new HashMap();
map.put("name", "a");
map.put("id", 3);
//List queryForList = sqlMap.queryForList("login2", map);//返回多个结果
Object obj = sqlMap.queryForObject("login2", map, userInfo);//返回单个结果
System.out.println(obj);
}
public static void add() throws SQLException //添加
{
sqlMap.startTransaction();
UserInfo userInfo = new UserInfo(9, "a", "a", "a");
Object insert = sqlMap.insert("addUserInfo", userInfo);
System.out.println(insert);
sqlMap.commitTransaction();
}
public static void del(int key) throws SQLException //删除
{
sqlMap.startTransaction();
Object del = sqlMap.delete("delUserInfo", key);
int parseInt = Integer.parseInt(del.toString());
sqlMap.commitTransaction();
if (parseInt > 0)
{
System.out.println("删除成功");
}
}
public static void update() throws SQLException //修改
{
sqlMap.startTransaction();//开始事务
UserInfo userInfo = new UserInfo(2, "h", "h", "h");
int update = sqlMap.update("updUserInfo", userInfo);
sqlMap.commitTransaction();
System.out.println(update);
}
}