spring + hibernate批量加入

 

    

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?><beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><!-- 配置数据源 --><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property><property name="url"><value>jdbc:mysql://localhost:3306/test</value></property><property name="username"><value>root</value></property><property name="password"><value>001052</value></property></bean><!-- 定义Hibernate的sessionFactory --><bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><property name="dataSource"><ref bean="dataSource" /></property><property name="hibernateProperties"><props><!-- 数据库连接方言 --><prop key="dialect">org.hibernate.dialect.MySQLDialect</prop><!-- 在控制台输出SQL语句 --><prop key="hibernate.show_sql">true</prop><!-- 格式化控制台输出的SQL语句 --><prop key="hibernate.format_sql">true</prop></props></property><!--hibernate映射文件 --><property name="mappingResources"><list><value>com/mr/user/User.hbm.xml</value></list></property></bean> <!-- 为DAOSupport注入sessionFactory --><bean id="dao" class="com.mr.dao.DAOSupport"><property name="sessionFactory"><ref local="sessionFactory"/></property></bean><!--定义控制器转发视图类 --><bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix"><value>/</value></property><property name="suffix"><value>.jsp</value></property></bean><!-- 映射的do --><bean name="/save.do" class="com.mr.main.AddUser"><property name="dst"><ref local="dao"/></property></bean></beans>

User.java:

package com.mr.user;import java.util.Date;/** * 用户信息JavaBean */public class User{private Integer id;//id值private String name;//用户名称private String business;//职务private Date addTime;//添加时间public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getBusiness() {return business;}public void setBusiness(String business) {this.business = business;}public Date getAddTime() {return addTime;}public void setAddTime(Date addTime) {this.addTime = addTime;}}

User.hbm.xml:

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping><class name="com.mr.user.User" table="tb_user3"><!-- id值 --> <id name="id" column="id" type="int"><generator class="native"/></id><!-- 名称 --><property name="name" type="string" length="45"><column name="name"/></property><!-- 职务 --><property name="business" type="string" length="45"><column name="business"/></property><!-- 信息添加时间 --><property name="addTime" type="java.util.Date"><column name="addTime"/></property></class></hibernate-mapping>

AddUser.java:

package com.mr.main;import java.util.HashMap;import java.util.Map;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.springframework.web.servlet.ModelAndView;import org.springframework.web.servlet.mvc.AbstractController;import com.mr.dao.DAOSupport;/** *批量添加信息的控制器 */public class AddUser extends AbstractController  {private DAOSupport dst;//注入DAOSupportpublic DAOSupport getDst() {return dst;}public void setDst(DAOSupport dst) {this.dst = dst;}protected ModelAndView handleRequestInternal(HttpServletRequest request,HttpServletResponse response) throws Exception {//添加信息的条数request.setCharacterEncoding("UTF-8");int count = Integer.parseInt(request.getParameter("count"));dst.InsertPatchInfo(count,request,response);//执行封装的批量添加方法Map map = new HashMap();//定义映射//设置添加成功时的提示信息map.put("succ", "信息添加成功，共添加"+count+"条信息！");return new ModelAndView("index",map);}}

DAOSupport.java:

package com.mr.dao;import java.io.UnsupportedEncodingException;import java.util.Date;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.springframework.orm.hibernate3.HibernateTemplate;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.mr.user.User;/** * 执行信息批量添加 */public class DAOSupport extends HibernateDaoSupport {public void InsertPatchInfo(int count,HttpServletRequest request,HttpServletResponse response){String name = request.getParameter("name");//用户名称String business = request.getParameter("business");//职务HibernateTemplate template = this.getHibernateTemplate();//实例化Hibernate模板for(int i = 0; i < count ; i++){//批量执行添加方法User userVO = new User();//实例化对象 userVO.setName(name+i);//设置用户名userVO.setBusiness(business);//设置职务userVO.setAddTime(new Date());//设置添加时间template.save(userVO);//执行添加方法}}}