package com.ctgusec.zhupan.model;
import java.sql.SQLException;
import java.util.List;
import com.ctgusec.zhupan.interf.IBatisService;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class ExampleMain implements IBatisService{
private static final String resource = "SqlMapConfig.xml";
public void updateUser() {
// 首先初始化iBatis获得一个SqlMapClient对象
com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
try {
java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (Exception e) {
e.printStackTrace();
}
// sqlMap系统初始化完毕,开始执行update操作
try {
//sqlMap.startTransaction();这句话是必须要写的,有了这句话才能开启事物,否则ibatis默认是自动提交的
sqlMap.startTransaction();
User user = new User();
user.setId("1");
user.setName("ddddddddddddddddddddddddd随碟附送答复是少发斯蒂芬的手法撒旦法发生的法案是飞洒撒旦法发发发发萨芬是");
user.setSex("2");
sqlMap.update("updateUser", user);
//sqlMap.commitTransaction();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void insertFatherTable() {
// 首先初始化iBatis获得一个SqlMapClient对象
com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
try {
java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (Exception e) {
e.printStackTrace();
}
// sqlMap系统初始化完毕,开始执行update操作
try {
sqlMap.startTransaction();
Father father = new Father();
father.setName("3");
father.setSex("3");
father.setStartTime("3");
father.setEndTime("3");
sqlMap.insert("insertFather", father);
//sqlMap.commitTransaction();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
@SuppressWarnings("unchecked")
public List<User> getUser() {
// 首先初始化iBatis获得一个SqlMapClient对象
com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;
List<User> user = null;
try {
java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (Exception e) {
e.printStackTrace();
}
// sqlMap系统初始化完毕,开始执行getAllUser操作
try {
sqlMap.startTransaction();
user = sqlMap.queryForList("getAllUser", "2");
//sqlMap.commitTransaction();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
return user;
}
// public static void main(String[] args) {
// update();
// List<User> user = getUser();
// for (int i = 0; i < user.size(); i++) {
// System.out.println(((User) user.get(i)).getName());
// }
// }
}