ibatis学习完整实例，例子

package com.xyc.ibatis.dao; import java.sql.SQLException; import java.util.HashMap; import java.util.List; import java.util.Map; import com.ibatis.sqlmap.client.SqlMapClient; import com.xyc.ibatis.client.MyAppSqlConfig; import com.xyc.ibatis.domain.Emp; public class IbaitsDaoImpl implements IbatisDao{ private static final SqlMapClient sqlMap=MyAppSqlConfig.getSqlMapInstance(); public Emp getEmpById(int id) { Emp emp=null; try { emp=(Emp)sqlMap.queryForObject("getEmpById", id); System.out.println(emp); } catch (SQLException e) { e.printStackTrace(); } return emp; } public List getEmpListBySex() { String sex=new String("f"); List empList=null; try { empList=sqlMap.queryForList("getEmpListBySex", sex); } catch (SQLException e) { e.printStackTrace(); } return empList; } public List getDeptList() { List deptList=null; try { deptList=sqlMap.queryForList("getDeptList"); } catch (SQLException e) { System.out.println("getDeptList方法出现错误！"); e.printStackTrace(); } return deptList; } public List getPartEmpList() { Map empMap=new HashMap(); empMap.put("sex", "f"); empMap.put("job", "officer"); List parEmpList=null; try { parEmpList=sqlMap.queryForList("getPartEmpList",empMap); } catch (SQLException e) { System.out.println("getPartEmpList方法出现错误！"); e.printStackTrace(); } return parEmpList; } public void insertEmp() { Emp emp=new Emp(); emp.setDeptId(1); emp.setEmpName("ouyangfeng"); emp.setEmpSex("m"); emp.setJob("singer"); emp.setSalary(700.00); try { sqlMap.insert("insertEmp", emp); System.out.println("插入员工记录成功！"); } catch (SQLException e) { System.out.println("未能成功插入员工记录！"); e.printStackTrace(); } } public void updateEmp() { Emp emp = new Emp(); emp.setEmpId(3); emp.setSalary(900.0); emp.setEmpName("huangrong"); emp.setJob("dancer"); try { sqlMap.update("updateEmp", emp); System.out.println("更新员工成功！"); } catch (SQLException e) { e.printStackTrace(); } } public void deleteEmp() { int id=2; try { sqlMap.delete("deleteEmp", id); System.out.println("删除成功！"); } catch (SQLException e) { e.printStackTrace(); } } public Emp getDeptNameByEmpName() { String empName="jim"; Emp emp=null; try { emp=(Emp)sqlMap.queryForObject("getEmpDeptName", empName); System.out.println(emp.getEmpName()+" "+emp.getDept().getDeptName()); } catch (SQLException e) { e.printStackTrace(); } return emp; } public Emp getDynamicEmp() { Emp emp = null; Map map=new HashMap(); map.put("salary", 201.0); map.put("empName", "hameimei"); try { emp = (Emp) sqlMap.queryForObject("dynamicGetEmp",map); System.out.println(emp); } catch (SQLException e) { e.printStackTrace(); } return emp; } }