Hibernate 实现批量添加数据

最新推荐文章于 2024-08-27 13:59:46 发布

lipengfei1010035021

最新推荐文章于 2024-08-27 13:59:46 发布

阅读量3.9k

点赞数 1

分类专栏：专业技术小结文章标签： csdn hibernate myeclipse java

本文链接：https://blog.csdn.net/lipfbk/article/details/38122415

版权

专业技术小结专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Hibernate 实现批量添加数据

1.Hibernate_016_BatchAddData程序目录结构：

2.lib目录下所引入的jar包：

3.MedicineDao.java源代码：

[java] view plain copy

package com.xqh.dao;
import java.util.List;
import org.hibernate.Session;
import com.xqh.model.Medicine;
import com.xqh.util.HibernateUtil;
/**
* 药品数据库操作类
*
*/
public class MedicineDao {
/**
* 批量保存药品
*
* @param ms
* List集合
*/
public void saveMedicines(List<Medicine> ms) {
Session session = null;
if (ms != null && ms.size() > 0) {
try {
session = HibernateUtil.getSession(); // 获取Session
session.beginTransaction(); // 开启事物
Medicine medicine = null; // 创建药品对象
// 循环获取药品对象
for (int i = 0; i < ms.size(); i++) {
medicine = (Medicine) ms.get(i); // 获取药品
session.save(medicine); // 保存药品对象
// 批插入的对象立即写入数据库并释放内存
if (i % 10 == 0) {
session.flush();
session.clear();
}
}
session.getTransaction().commit(); // 提交事物
} catch (Exception e) {
e.printStackTrace(); // 打印错误信息
session.getTransaction().rollback(); // 出错将回滚事物
} finally {
HibernateUtil.closeSession(session); // 关闭Session
}
}
}
}

4.Medicine.java源代码：

[java] view plain copy

package com.xqh.model;
/**
* 药品持久化类
*/
public class Medicine {
private Integer id; //id号
private String name; //药品名称
private double price; //价格
private String factoryAdd; //出厂地址
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 double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getFactoryAdd() {
return factoryAdd;
}
public void setFactoryAdd(String factoryAdd) {
this.factoryAdd = factoryAdd;
}
}

5.Medicine.hbm.xml源代码：

[html] view plain copy

<?xml version="1.0"?>
<!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.xqh.model.Medicine" table="tb_medicine_batch">
<id name="id">
<generator class="native"/>
</id>
<property name="name" not-null="true" length="200" />
<property name="price" not-null="true"/>
<property name="factoryAdd" length="200"/>
</class>
</hibernate-mapping>

6.SaveMedicine.java源代码：

[java] view plain copy

package com.xqh.servlet;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.xqh.dao.MedicineDao;
import com.xqh.model.Medicine;
public class SaveMedicine extends HttpServlet {
private static final long serialVersionUID = 3743334039515411666L;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 药品名称
String names[] = request.getParameterValues("name");
// 价格
String prices[] = request.getParameterValues("price");
// 出厂地址
String adds[] = request.getParameterValues("factoryAdd");
// 有效性判断
if(names != null && prices != null && adds != null){
if(names.length == prices.length && names.length == adds.length){
// 实例化一个List集合
List<Medicine> ms = new ArrayList<Medicine>();
Medicine m = null; // 药品对象
// 依次实例化药品对象并添加到集合中
for (int i = 0; i < names.length; i++) {
m = new Medicine(); // 实例化药品
// 对属性赋值
m.setName(names[i]);
m.setPrice(Double.parseDouble(prices[i]));
m.setFactoryAdd(adds[i]);
ms.add(m); // 添加到集合中
}
// 实例化MedicineDao对象
MedicineDao dao = new MedicineDao();
dao.saveMedicines(ms); // 批量保存药品
request.setAttribute("info", "药品信息保存成功！！！");
}
}
// 转发到result.jsp页面
request.getRequestDispatcher("result.jsp").forward(request, response);
}
}

7.CharacterEncodingFilter.java源代码：

[java] view plain copy

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.xqh.util;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
/**
* 字符编码过滤器
*/
public class CharacterEncodingFilter implements Filter{
protected String encoding = null;
protected FilterConfig filterConfig = null;
public void init(FilterConfig filterConfig) throws ServletException {
this.filterConfig = filterConfig;
this.encoding = filterConfig.getInitParameter("encoding");
}
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
if (encoding != null) {
request.setCharacterEncoding(encoding);
response.setContentType("text/html; charset="+encoding);
}
chain.doFilter(request, response);
}
public void destroy() {
this.encoding = null;
this.filterConfig = null;
}
}