Ibatis初步小结
SqlMapConfig.xml

User.xml


IUserDao.java
package com.cs;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 UserDaoImpl implements IUserDao {private static SqlMapClient sqlmapper = null;static {try {Reader reader = Resources.getResourceAsReader("com/cs/SqlMapConfig.xml");sqlmapper = SqlMapClientBuilder.buildSqlMapClient(reader);} catch (IOException e) {e.printStackTrace();}}public void addUser(User user) {try {sqlmapper.insert("inserUser", user);} catch (SQLException e) {e.printStackTrace();}}public void delUser(int id) {try {sqlmapper.delete("deleteUser", 12);} catch (SQLException e) {e.printStackTrace();}}public void modifyUser(User user) {try {sqlmapper.update("modifyUser", user);} catch (SQLException e) {e.printStackTrace();}}public List selectAllUser() {List list = null;try {list = sqlmapper.queryForList("selectAllUser");} catch (SQLException e) {e.printStackTrace();}return list;}public User selectUserById(int id) {User user = null;try {user = (User)sqlmapper.queryForObject("selectUserById",id);} catch (SQLException e) {e.printStackTrace();}return user;}public List selectUserByName(String name) {List list = null;try {list = sqlmapper.queryForList("selectUserByName", name);} catch (SQLException e) {e.printStackTrace();}return list;}/** * @param args */public static void main(String[] args) {IUserDao userdao = new UserDaoImpl();//      添加USER//User user = new User();//user.setId(100);//user.setName("cs");//user.setSex(1);//user.setAddress(2);//userdao.addUser(user);////List list = userdao.selectAllUser();//for(int i=0;i<list.size();i++) {//System.out.println(list.get(i));//}//修改USER//User user = new User();//user.setId(100);//user.setName("cs");//user.setSex(2);//user.setAddress(1);//userdao.modifyUser(user);//删除USER//userdao.delUser(12);//模糊查询//List list = userdao.selectUserByName("zk");//查询所有USERList list = userdao.selectAllUser();for(int i=0;i<list.size();i++) {System.out.println(list.get(i));}//    根据ID查询//User user = userdao.selectUserById(1);//System.out.println(user);}}