jdbcTemplate

package com.org.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Map; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.PreparedStatementCreator; import org.springframework.jdbc.core.RowCallbackHandler; import org.springframework.jdbc.support.GeneratedKeyHolder; import org.springframework.stereotype.Repository; import com.org.JdbcTempBaseDao; import com.org.dao.IUserDao; import com.org.model.User; @Repository @SuppressWarnings("all") public class UserDaoImpl extends JdbcTempBaseDao implements IUserDao { @Override public List getUserList() { String sql="select * from user "; final List list= new ArrayList(); jdbcTemplate.query(sql, new RowCallbackHandler(){ @Override public void processRow(ResultSet rs) throws SQLException { User u=new User(); u.setId(rs.getInt("id")); u.setUsername(rs.getString("username")); u.setPassword(rs.getString("password")); u.setCreateDate(rs.getString("createDate")); u.setModifyDate(rs.getString("modifyDate")); u.setType(rs.getString("type")); list.add(u); } }); return list; } @Override public List getUserLists(Map map) { return null; } @Override public Integer getUserCount(Map map) { String sql = "select count(1) from User where id=? "; return getJdbcTemplate().queryForObject(sql, Integer.class,map); } @Override public User getUserById(Integer primaryKeyId) { String sql = "select id,username, password, createDate, modifyDate,type from User where id=?"; List userList = getJdbcTemplate().query(sql, new BeanPropertyRowMapper(User.class), primaryKeyId); if(userList.size() == 0) { return null; } return userList.get(0); } @Override public void delUserById(Int

package com.org.utils.encode;

import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;

import javax.servlet.jsp.tagext.TagSupport;

/***
 * @Author:liangjilong
 * @Date:2014-5-23
 * @Version:1.0
 */
public class CharacterEncode extends TagSupport {
	/**
	 * 自行定义的标签
	 */
	private static final long serialVersionUID = 4403969892682141312L;

	/**
	 * 对url中文参数进行编码
	 * @param str
	 * @return
	 */
	public static String URLEncoder（String str） {
		try {
			String temp = URLEncoder.encode（str “UTF-8“）;
			return temp;
		} catch （UnsupportedEncodingException e） {
			e.printStackTrace（）;
		}
		return str;
	}

	/**
	 * 解决不同浏览器的在对数据传输中不同的字符集问题。
	 * @param str
	 * @return
	 */
	public static String URLEncoderRep（String str） {
		try {
			String temp = URLEncoder.encode（str “UTF-8“）;
			String temp2 = temp.replace（“%“ “!“）;
			return temp2;
		} catch （UnsupportedEncodingException e） {
			e.printStackTrace（）;
		}
		return str;
	}

}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\
     文件        1184  2014-06-25 11:50  SpringMVC_jdbcTemplate\.classpath
     文件        1347  2014-06-26 11:18  SpringMVC_jdbcTemplate\.project
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\.settings\
     文件         522  2014-06-25 11:49  SpringMVC_jdbcTemplate\.settings\.jsdtscope
     文件         364  2014-06-25 11:49  SpringMVC_jdbcTemplate\.settings\org.eclipse.jdt.core.prefs
     文件         684  2014-06-25 11:50  SpringMVC_jdbcTemplate\.settings\org.eclipse.wst.common.component
     文件         412  2014-06-25 11:49  SpringMVC_jdbcTemplate\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2014-06-25 11:49  SpringMVC_jdbcTemplate\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2014-06-25 11:49  SpringMVC_jdbcTemplate\.settings\org.eclipse.wst.jsdt.ui.superType.name
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\meta-INF\
     文件          39  2014-06-25 11:49  SpringMVC_jdbcTemplate\WebRoot\meta-INF\MANIFEST.MF
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\
     文件        4166  2014-06-25 11:56  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\application-mvc.xml
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\
     文件        2519  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\baseController.class
     文件         440  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\baseDao.class
     文件         363  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\baseEntity.class
     文件         464  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\baseService.class
     文件         168  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\IbaseDao.class
     文件         176  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\IbaseService.class
     文件         690  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\IbatisbaseDao.class
     文件         697  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\JdbcTempbaseDao.class
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\controller\
     文件        5043  2014-06-26 11:18  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\controller\UserController.class
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\dao\
     文件         746  2014-06-26 11:52  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\dao\IUserDao.class
     目录           0  2014-06-26 12:03  SpringMVC_jdbcTemplate\WebRoot\WEB-INF\classes\com\org\dao\impl\
............此处省略304个文件信息