struts与Hibernate联合写增删查改

首先需要在pom.xml中引用依赖

javax.servlet javax.servlet-api 4.0.1 provided

	<!--hibernate的核心依赖 -->
	<dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-core</artifactId>
		<version>5.3.10.Final</version>
	</dependency>

 <!-- 引入struts的核心 -->
<!-- https://mvnrepository.com/artifact/org.apache.struts/struts2-core -->
<dependency>
    <groupId>org.apache.struts</groupId>
    <artifactId>struts2-core</artifactId>
    <version>2.3.35</version>
</dependency>


	<!-- mysql驱动 -->
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>5.1.35</version>
	</dependency>

然后web.xml中也需要进行配置

建造hibernate.cfg.xml连接数据库 mapping中为实体类的引用

<?xml version="1.0" encoding="UTF-8"?> com.mysql.jdbc.Driver 123456 jdbc:mysql://localhost:3306/test root org.hibernate.dialect.MySQLDialect

    <property name="show_sql">true</property>
    <property name="format_sql">true</property>
    
    <mapping resource="com/xh/entity/test.hbm.xml"/>
     <mapping resource="com/xh/entity/card.hbm.xml"/>
</session-factory>

实体类也需要改变

在类中进行增删查改
public class CRUD {

private Configuration c=new Configuration().configure();
private SessionFactory f= c.buildSessionFactory();
private Session s= f.openSession();
private Transaction t = s.beginTransaction();

test ts=new test();//新的实体类


public  String select(){
	HttpServletRequest req= ServletActionContext.getRequest();//请求对象
	List<test> list = s.createQuery("from test").list();//集合
	System.out.println(list);
	req.setAttribute("list", list);
	return "select";
}


public  String add(){
	s.save(ts);
	t.commit();
	//关闭session
	s.close();
	//关闭session工厂
	f.close();
	return "add";
}

public  String delete(){
	System.out.println(ts.getId());
	test  d = s.get(test.class, ts.getId());
	s.delete(d);
	t.commit();
	//关闭session
	s.close();
	//关闭session工厂
	f.close();
	return "delete";
}
public String queryid() {
	HttpServletRequest req= ServletActionContext.getRequest();
	test  d = s.get(test.class, ts.getId());
	req.setAttribute("list", d);
	t.commit();
	//关闭session
	s.close();
	//关闭session工厂
	f.close();
	return "update";
}
public  String update(){
	System.out.println("========");
	test  d = s.get(test.class, ts.getId());
	d.setName(ts.getName());
	d.setAge(ts.getAge());
	s.update(d);
	t.commit();
	//关闭session
	s.close();
	//关闭session工厂
	f.close();
	return "delete";
}


public test getTs() {
	return ts;
}

public void setTs(test ts) {
	this.ts = ts;
}

此为struts.xml中的配置