1.项目文件分布。
2、example1.java:
package com.rhythmk.example1;
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 example1 {
private static String resource = "com\rhythmk\example1\SqlMapConfig.xml";
private static SqlMapClient sqlMapClient = null;
static {
System.out.println(System.getProperty("user.dir"));
try {
Reader reader = Resources.getResourceAsReader(resource);
sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
GetAllUser();
GetUserById(1);
}
/*
* 根据ID 获取User
*/
public static void GetUserById(Integer id) {
User user = null;
try {
sqlMapClient.startTransaction();
user = (User) sqlMapClient.queryForObject("selectById",
new Integer("1"));
System.out.println(user.getName());
sqlMapClient.commitTransaction();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void GetAllUser() {
List<User> list = null;
try {
list = (List<User>) sqlMapClient.queryForList("selectAll");
for (User user : list) {
System.out.println(user.getId() + "," + user.getName());
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
packa