spring两种方法实现操作对象化

package servlet;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.Iterator;
import java.util.List;
import java.util.Locale;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.jsp.PageContext;
import javax.sql.DataSource;

import org.apache.log4j.Logger;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import org.springframework.core.io.FileSystemResource;
import org.springframework.core.io.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.SqlParameter;
import org.springframework.jdbc.object.MappingSqlQuery;
import org.springframework.jdbc.object.SqlUpdate;

import com.sun.org.apache.xalan.internal.xsltc.compiler.util.Type;

import bean.User;
/**
*
* @author zwc
*
*/
@SuppressWarnings("serial")
public class OperateSpring extends HttpServlet {
private static Logger logger = Logger.getLogger(OperateSpring.class);
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out = response.getWriter();
response.setContentType("text/html;charset=UTF-8");
response.setCharacterEncoding("UTF-8");
request.setCharacterEncoding("UTF-8");
out.println("<title>" + this.getClass().getName() + "</title>");

String path = getServletContext().getRealPath("/");
logger.info("真实路径：" + path);
ApplicationContext ac = new FileSystemXmlApplicationContext(path + "\\WEB-INF\\classes\\applicationContext.xml");

//XmlBeanFactory factory = new XmlBeanFactory(new FileSystemResource(path + "\\WEB-INF\\classes\\applicationContext.xml"));

JdbcTemplate jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
DataSource ds = (DataSource) ac.getBean("dataSource");

SelectUsers su = new SelectUsers(ds);
List<User> list = su.getAllUser();
for(Iterator<User> i = list.iterator();i.hasNext();){
User user = i.next();
out.print(user.getName() + "<br>");

这里的查找功能，

简单，O(∩_∩)O哈哈~

}
}
}

查询时候：
class SelectUsers extends MappingSqlQuery<User>{
public SelectUsers(DataSource ds){
setDataSource(ds);
setSql("select * from t_user");
compile();
}
@Override
protected User mapRow(ResultSet rs, int rowNum) throws SQLException {
User user = new User();
user.setId(rs.getInt("id"));
user.setName(rs.getString("name"));
user.setSex(rs.getInt("sex"));
return user;
}
public List<User> getAllUser(){
Object[] params = new Object[]{};
return execute(params);
}
}

更新时候；
class InsertUser extends SqlUpdate{
public InsertUser(DataSource ds){
setDataSource(ds);
setSql("insert into t_user(id,name,sex) value(?,?,?)");
declareParameter(new SqlParameter(Types.INTEGER));
declareParameter(new SqlParameter(Types.VARCHAR));
declareParameter(new SqlParameter(Types.INTEGER));
compile();
}
public int InsertByUser(User user){
Object[] params = new Object[]{
user.getId(),
user.getName(),
user.getSex()
};
return update(params);
}
}

对应的，applicationContext为：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd"
default-lazy-init="true">
<!-- 从外部加载属性文件 -->
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>classpath:/application.properties</value>
</property>
</bean>
<!-- application listener init-->
<bean id="myApplicationListener" class="listener.MyApplicationListenerImp">
</bean>
<!-- 国际化 -->
<bean id="messageSource" class="org.springframework.context.support.ResourceBundleMessageSource">
<property name="basenames" value="i18n_message"/>
</bean>

<!-- 数据源配置,使用应用内的DBCP数据库连接池 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<!-- Connection Info -->
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />

<!-- Connection Pooling Info -->
<property name="initialSize" value="${dbcp.initialSize}" />
<property name="maxActive" value="${dbcp.maxActive}" />
<property name="maxIdle" value="${dbcp.maxIdle}" />
<property name="defaultAutoCommit" value="false" />
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>


<bean id="user" class="bean.User">
<!--
用构造函数给bean赋值
<constructor-arg index="0" value="zwc" type="java.lang.String"/>
<constructor-arg index="1" value="1" type="java.lang.Integer"/>
-->
<!--
用property 给bean赋值
<property name="id" value="10010"/>
<property name="name" value="zwc"/>
<property name="sex" value="1"/>
-->
<property name="childs">
<map>
<entry key="zhangsan">
<value>${jdbc.url}</value>
</entry>
<entry key="lisi" value="${jdbc.driver}"/>
<entry key="wangwu" value="${jdbc.username}"/>
</map>
</property>
</bean>
<bean id="myLog" class="commons.MyLog"></bean>
<bean id="listener" class="commons.MyLogListener"></bean>


</beans>