spring mvc应用之用户管理系统

package com.cjg.user.persistence; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import java.util.List; import com.cjg.user.domain.UserInfoVo; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder; public class UserInfoDaoImpl { /*public SqlMapClient sqlMap; public SqlMapClient getSqlMapClientTemplate() { String resource = "conf/sql-map-config.xml"; try { Reader reader = Resources.getResourceAsReader(resource); SqlMapConfigParser sqlMapConfigParser = new SqlMapConfigParser(); SqlMapClient sqlMap = sqlMapConfigParser.parse(reader); System.out.println("==================reader" + reader); return sqlMap; } catch (IOException e) { e.printStackTrace(); } return null; }*/ //定义ibaits客户端 public SqlMapClient sqlMap; //获得ibaits客户端方法 public SqlMapClient getSqlMapClientTemplate() { String resource = "conf/sql-map-config.xml"; try { Reader reader = Resources.getResourceAsReader(resource); XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder(); sqlMap = xmlBuilder.buildSqlMap(reader); } catch (IOException e) { e.printStackTrace(); } return sqlMap; } //增加用户 public void insertUser(UserInfoVo user) throws SQLException { getSqlMapClientTemplate().insert("insertUser", user); } //查看所有用户 @SuppressWarnings("unchecked") public List selectUser(UserInfoVo user) throws SQLException { try { List list=getSqlMapClientTemplate().queryForList("selectUser",user); return list; } catch (Exception e) { e.printStackTrace(); // To change body of catch statement use // File | Settings | File Templates. } return null; } //更新用户 public void updateUser(UserInfoVo user) throws SQLException { try { System.out.println("id" + user.getUiId() + "dfddf" + user.getPassword()); getSqlMapClientTemplate().update("updateUser", user); } catch (Exception e) { e.printStackTrace(); // To change body of catch statement use // File | Settings | File Templates. } } //删除用户 public void deleteUser(UserInfoVo user) throws SQLException { try { getSqlMapClientTemplate().delete("deleteUser", user); } catch (Exception e) { e.printStackTrace(); // To change body of catch statement use // File | Settings | File Templates. } } //查找单个用户 public UserInfoVo findSingleUser(UserInfoVo user) throws SQLException { try { return (UserInfoVo) getSqlMapClientTemplate().queryForObject( "findSingleUser", user); } catch (Exception e) { e.printStackTrace(); // To change body of catch statement use // File | Settings | File Templates. } return null; } }