spring + hibernate批量加入

 

    

applicationContext.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans
	xmlns="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;//注入DAOSupport
	
	public 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);//执行添加方法
		}	
	}
}