ibatis + oracle 增删改查例子

package com.ibatis; 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 UserDao implements IUserDao { private static SqlMapClient sqlMapClient = null; static{ try { //声明配置文件的名称（映射文件被定义在其中） String resource = "com/ibatis/SqlMapConfig.xml"; //利用工具类Resources来读取到配置文件 Reader reader = Resources.getResourceAsReader(resource); //创建SqlMapClient接口的变量实例 sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException( "Error initializing MyAppSqlConfig class. Cause: " + e); } } public void add(com.ibatis.User user) { try { sqlMapClient.insert("insertUser", user); } catch (SQLException e) { e.printStackTrace(); } } @Override public void delete(int id) { try { sqlMapClient.delete("deleteUser", id); } catch (SQLException e) { e.printStackTrace(); } } @Override public List<com.ibatis.User> list() { List<User> list = null; try { list = sqlMapClient.queryForList("getUsers"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } @Override public com.ibatis.User load(int id) { User user = null; try { user = (User) sqlMapClient.queryForObject("selectById", id); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return user; } @Override public List<User> loadByUsername(String username) { System.out.println("Ddd="+username); List<User> list = null; try { list = sqlMapClient.queryForList("selectByName",username); System.out.println("list="+list); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } @Override public void update(com.ibatis.User user) { try { sqlMapClient.update("updateUser",user); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { System.out.println("dddd"); /// IUserDao userDao = new UserDao(); // for (User u:userDao.list()) { // System.out.println(u.getUsername()); // } } }