Ibatis的简单例子（增删改查，联合查询等）

package com.dao; import java.util.List; import java.sql.SQLException; import com.po.User; import com.util.DBManager; public class UserDao { public void insert(User user){ try { DBManager.sqlMapClient.insert("insert",user); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void delete(int id){ try { DBManager.sqlMapClient.delete("delete",id); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void update(User user){ try { DBManager.sqlMapClient.update("update",user); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public User find(int id){ User user=null; try { user=(User)DBManager.sqlMapClient.queryForObject("find", id); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return user; } public List<User> findByName(String name){ List<User> list=null; try { list=DBManager.sqlMapClient.queryForList("findByName",name); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public List<User> findByDeptNO(int deptNO){ List<User> list=null; try { list=DBManager.sqlMapClient.queryForList("findByDeptNo",deptNO); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public List<User> findAll(){ List<User> list=null; try { list=DBManager.sqlMapClient.queryForList("findAll"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } }