hibernate简单程序，实现从页面对数据库的增删改查（主从表关联）

      前段时期一直使用三层来写从页面对数据库的增删改查，今天用hibernate框架来实现从页面对数据库的增删改查，

首先介绍下今天我们要实现的功能，

1、用户能够注册，2、注册成功后直接跳到登录页面，3、登录成功后直接跳到对公司、人员的增删改查，

4、要有对人员界面的分页功能

一、首先看下文件的目录

unity里面写的是配置文件的session接口工具，dao层就是各种增删改查的方法

1、首先得配置文件：hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory >
	<!-- 配置数据库连接信息 -->
	<property name="connection.driver_class">
	com.mysql.jdbc.Driver
	</property>
	
	<property name="connection.url">
	jdbc:mysql://localhost:3306/company
	</property>
	
	<property name="connection.username">
	root
	</property>
	
	<property name="connection.password">
	DCX5201314
	</property>
	
	<!-- 数据库方言-->
	<property name="dialect">
	 org.hibernate.dialect.MySQL5Dialect
	</property>
	
	<!-- 非必要的 -->
	<property name="hbm2ddl.auto">update</property><!-- 可以反向生成表 -->
	
	<!-- 映射配置文件 -->
	<mapping  resource="entity/user.hbm.xml"/>
	<mapping  resource="entity/bm.hbm.xml"/>
	<mapping  resource="entity/ry.hbm.xml"/>
		
	</session-factory>
</hibernate-configuration>

2、配置untitl.java

package unity;
public class unitl {

	public Session lj(){
		
		//新建Configuration对象
		Configuration cfg=new Configuration().configure();

		//通过Configuration创建SessionFactory对象
		ServiceRegistry registry = new StandardServiceRegistryBuilder()
			.applySettings(cfg.getProperties())
			.build();
        SessionFactory sf = cfg.buildSessionFactory(registry);
        //创建session
        Session session=sf.openSession();
		return session;
		
	}
}

3、首先我们先写用户的注册、登录

配置文件：user.hbm.xml

<hibernate-mapping >
    <class name="entity.user" table="user" >   
        <id name="id" >
             <!-- 设置主键 -->
            <generator class="native"></generator>
        </id>     
        <property name="name" />
        <property name="pwd" />       
    </class>
</hibernate-mapping>

user.java文件（定义数据库里面的属性）

package entity;

public class user {

	private int id;
	private String name;
	private String pwd;

	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
}

Userzhuceservlet.java文件（servlet层）

public class Userzhuceservlet extends HttpServlet {

	dao.selectone se=new dao.selectone();
	public Userzhuceservlet() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out = response.getWriter();
		this.doPost(request, response);
		out.flush();
		out.close();
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out = response.getWriter();
		//用type接受页面的值
		String type=request.getParameter("type");
		if ("1".equals(type)) {
			System.out.println("haha");
			//调用条件查询的方法
			zhuce(request, response);
		}
		else if ("2".equals(type)) {
			login(request, response);
		}
		out.flush();
		out.close();
	}
	
	/*************注册********************************************/
	public void zhuce(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		String name=request.getParameter("name");
		String pwd=request.getParameter("pwd");
		int a=se.selllt(name,pwd);
		if (a>0) {
			response.sendRedirect("login.jsp");
		}
	}
	/*************登录********************************************/
	public void login(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		String name=request.getParameter("name");
		String pwd=request.getParameter("pwd");
		int a=se.login(name,pwd);
		if (a>0) {
			System.out.println("登录成功");
			response.sendRedirect("index.jsp");
		}else {
			System.out.println("登录失败");
		}
	}
	public void init() throws ServletException {
		// Put your code here
	}

}

selectone.java文件（名字起的有点问题，是用户的Dao层文件）

public class selectone {

	//调用工具包
	static unitl unitl=new unitl();
	static Session session=unitl.lj();
	
	
	/****************注册************************************/
	public int selllt(String name,String pwd){
		int a=0;
		//3、开启事务
        Transaction ts=session.beginTransaction();
        //执行数据库操作
        //添加操作
        user u=new user();
        u.setName(name);
        u.setPwd(pwd);
        session.save(u);
        System.out.println("注册成功");
        //提交
		ts.commit();
		//关闭session
		//session.close();
		a=1;
		return a;
	}
	
	/****************登录************************************/
	public int login(String name,String pwd){

        //执行数据库操作
		//编写hql
		String hql="select name from user where name=? and pwd=?";
		List<String> list=session.createQuery(hql)
		.setString(0, name)
		.setString(1, pwd)
		.list();
		int a=list.size();
		System.out.println(list.size());
//		for(String na:list){
//			System.out.println(na+"=====");
//		}
		//关闭session
		//session.close();
		
		return a;
	}
}

zhuce.jsp部分代码

<body>
    <h1>欢迎来到人力资源管理系统</h1>
    <form action="Userzhuceservlet" method="post">
    <input type="hidden" value="1" name="type">
           <tr> <td>要注册的用户名 ：</td><td><input type="text" name="name"/></td></tr>
           <tr> <td> 密码：</td><td><input type="password" name="pwd"/></td></tr>
           <tr><td><input type="submit" value="确认"></td></tr>
    </form>
  </body>

login.jsp代码：

<body>
    <h1>欢迎来到人力资源登录系统</h1>
    <form action="Userzhuceservlet" method="post">
    <input type="hidden" value="2" name="type">
           <tr><td> 用户名 ：</td><td><input type="text" name="name"/></td><br/></tr>
            <tr> <td>密码：</td><td><input type="password" name="pwd"/></td><br/></tr>
            
              <tr><td><input type="submit" value="确认"></td></tr>
    </form>
  </body>

至于head、left、right、等页面参考我之前的文章http://blog.csdn.net/qq_34178998/article/details/76578233这里就不在重复写了

4、再写部门的增删改查

配置bm.hbm.xml文件：

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping >

    <class name="entity.bm" table="bm"  >
       
        <id name="id" >
             <!-- 设置主键 -->
            <generator class="native"></generator>
        </id>
        <property name="bmname" />

        
    </class>

</hibernate-mapping>

bm.java文件

public class bm {

	private int id;
	private String bmname;

	public bm(int id,String bmname){
		this.id=id;
		this.bmname=bmname;
	}
	
    public bm(int id){
		this.id=id;
	}
	
	public bm(){
		
	}
	
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getBmname() {
		return bmname;
	}
	public void setBmname(String bmname) {
		this.bmname = bmname;
	}
}

BmServlet.java文件代码：

package servlet;
public class BmServlet extends HttpServlet {

	BmDao bd=new BmDao();
	public BmServlet() {
		super();
	}
	
	
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out = response.getWriter();
		this.doPost(request, response);
		out.flush();
		out.close();
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		PrintWriter out = response.getWriter();
		//用type接受页面的值
		String type=request.getParameter("type");
		if ("1".equals(type)) {        //添加部门的方法
			addbm(request, response);
		}
		
		else if ("2".equals(type)) {    //查询所有部门的方法
			selectall(request, response);
		}
		
		else if ("3".equals(type)) {    //根据ID删除部门
			selectry(request, response);
		}
		
		else if ("4".equals(type)) {    //根据修改部门
			update(request, response);
		}
		
		else if ("5".equals(type)) {    //根据ID查询一个部门
			selectone(request, response);
		}
		out.flush();
		out.close();
	}

	
	/***********************添加部门*********************************************************/
	public void addbm(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		String bmname=request.getParameter("bmname");
		int a=bd.addbm(bmname);
		if (a>0) {
			selectall(request, response);
			System.out.println("添加部门成功");
		}else {
			System.out.println("添加部门失败");
			response.sendRedirect("addbm.jsp");
		}
	}
	
	/***********************查询所有部门*********************************************************/
	public void selectall(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		List<bm> list=new ArrayList<bm>();
		list=bd.selectall();
		request.setAttribute("list", list);
		RequestDispatcher rd=request.getRequestDispatcher("showbm.jsp");
		rd.forward(request, response);
	}
	
	/***********************根据ID删除部门*********************************************************/
	public void delete(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("id"));
		bd.delete(id);
		selectall(request, response);
	}
	
	/***********************修改部门*********************************************************/
	public void update(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("id"));
		String newbmname=request.getParameter("newbmname");
		bd.update(id, newbmname);
		selectall(request, response);
	}
	
	
	/***********************根据点中的ID查询一个部门*********************************************************/
	public void selectone(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("id"));
		List<bm> list=bd.selectone(id);
		for(bm bb:list){
			//System.out.println(bb.getBmname()+bb.getId());
			request.setAttribute("list", bb);
		}
		//System.out.println("aa");
		RequestDispatcher rd=request.getRequestDispatcher("updatebm.jsp");
		rd.forward(request, response);
	}
	
	/***********************根据ID删除部门*********************************************************/
	public void selectry(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("id"));
		System.out.println(id);
		int a=bd.selectonee(id);
		if(a>0){
		delete(request, response);
		}
	}
	
	public void init() throws ServletException {
		// Put your code here
	}

}

BmDao.java文件：

public class BmDao {
	//调用工具包
	static unitl unitl=new unitl();
	static Session session=unitl.lj();
	int a=0;
	
	/***********添加部门****************************************************/
	public int addbm(String bmname){
		int a=0;
		//3、开启事务
        Transaction ts=session.beginTransaction();
        //执行数据库操作
        //添加操作
        bm b=new bm();
        b.setBmname(bmname);
        session.save(b);
        //提交
		ts.commit();
		//关闭session
		//session.close();
		a=1;
		return a;
	}
	
	/***********查看所有部门****************************************************/
	@SuppressWarnings("unchecked")
	public List<bm> selectall(){
		//执行数据库操作
		//编写hql
		String hql="from bm ";
		List<bm> list=session.createQuery(hql).list();
		return list;
	}
	
	/***********根据ID删除部门****************************************************/
	public int delete(int id){
		int a=0;
		//3、开启事务
        Transaction ts=session.beginTransaction();
        //执行数据库操作
        //删除操作
        bm b=(bm)session.get(bm.class, id);//注意强转
        session.delete(b);
        
        
        //提交
		ts.commit();
		//关闭session
		//session.close();
		a=1;
		return a;
	}
	
	/***********修改部门****************************************************/
	public void update(int id, String name){
		//执行数据库操作
		//编写hql
		Transaction ts=session.beginTransaction();
		bm b=(bm)session.load(bm.class, id);
		System.out.println(name);
		b.setBmname(name);
		session.update(b);
		//提交
		ts.commit();
	}
	
	/***********根据ID查询一个部门****************************************************/
	public List<bm>  selectone(int id){
		//执行数据库操作
		//编写hql
		String hql="select new bm(id,bmname) from bm where id=?";
		List<bm> list=session.createQuery(hql)
		.setInteger(0, id)
		.list();
		
//		for(bm bb:list){
//			System.out.println(bb.getBmname()+bb.getId());
//			
//		}
		return list;
	}
	
	/***********查询部门有没有人****************************************************/
	@SuppressWarnings("unchecked")
	public int  selectonee(int id){
		int a=1;
		String sql="select *from ry where bmid="+id+"";
		List<ry> list=session.createSQLQuery(sql).list();
		if(list.size()>0){
			a=0;
		}
		
		return a;
	}
}

addbm.jsp文件：

<body style="background-image:url(bg3.jpg)">
    <h1>这是添加部门界面</h1>
    <form action="BmServlet" method="post">
    <input type="hidden" value="1" name="type">
            部门：<input type="text" name="bmname"/><br/>
    <input type="submit" value="提交">
    </form>
  </body>

showbm.jsp文件：

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> 

<body style="background-image:url(bg3.jpg)">
    <h1>这是显示页面</h1>
    <h1>显示部门种类</h1>
    <table border="1">
    <tr><td>编号</td><td>部门种类</td><td>操作</td></tr>
    <c:forEach items="${list}" var="bm"> 
    <tr>
    <td>${bm.id}</td><td>${bm.bmname}</td>
    <td><a href="BmServlet?type=5&&id=${bm.id}">修改</a><!-- 修改前先查一个 -->
    
     <a href="BmServlet?type=3&&id=${bm.id}">删除</a></td>
    
    </tr>
    </c:forEach>
    </table>
    </body>

updatebm.jsp文件

<body style="background-image:url(bg3.jpg)">
    <h1>修改类型页面</h1>
      <form action="BmServlet" method="post">
    <input type="hidden" value="4" name="type">
    <input type="hidden" value="${list.id }" name="id">
             部门：<input type="text" name="newbmname" value="${list.bmname }"><br/>
       <input type="submit" value="提交">
  </body>

5、接下来是各部门的人员

ry.hbm.xml配置文件：

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">


<hibernate-mapping >

    <class name="entity.ry" table="ry"    >
       
        <id name="id" >
             <!-- 设置主键 -->
            <generator class="native"></generator>
        </id>
        
        <property name="name"></property>
        <property name="phone"></property>
        <property name="address"></property>
         <property name="bmid"></property>      
    </class>

</hibernate-mapping>

ry.java实体文件：

package entity;

public class ry {

	private int id;
	private String name;
	private String phone;
	private String address;
	private int bmid;
	private String bmname;
	

	public ry(){}
	
	public ry(int id,String name,String phone,String address,int bmid){
		this.id=id;
		this.name=name;
		this.phone=phone;
		this.address=address;
		this.bmid=bmid;
	}
	
	public ry(int id,String name,String phone,String address){
		this.id=id;
		this.name=name;
		this.phone=phone;
		this.address=address;
	}
	
	
	
	
	

	public int getBmid() {
		return bmid;
	}

	public void setBmid(int bmid) {
		this.bmid = bmid;
	}

	public String getBmname() {
		return bmname;
	}

	public void setBmname(String bmname) {
		this.bmname = bmname;
	}

	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
}

RyServlet.java文件

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.BmDao;
import dao.RyDao;

import entity.bm;
import entity.ry;

public class RyServlet extends HttpServlet {

	BmDao bd=new BmDao();
	RyDao ry=new RyDao();
	

	
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out = response.getWriter();
		this.doPost(request, response);
		out.flush();
		out.close();
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		PrintWriter out = response.getWriter();
		//接受页面的type值
		String type=request.getParameter("type");
		if ("1".equals(type)) {    //跳到添加人员的界面前要先把部门种类查询出来
			selectbm(request, response);
		}
		
		
		else if ("2".equals(type)) { //添加人员信息
			addry(request, response);
		}
		
		else if ("3".equals(type)) { //查询所有人员信息
//			selectallry(request, response);
			select(request, response);
		}
		
		else if ("4".equals(type)) { //删除操作
			selectry(request, response);
		}
		
        else if ("5".equals(type)) { //1、修改操作，修改前先根据ID查询
			selectone(request, response);
		}
		
        else if ("6".equals(type)) { //2、修改操作，
			update(request, response);
		}
		
		out.flush();
		out.close();
	}

	
	/************先所有查询部门**************************************************/
	public void selectbm(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		List<bm> list=new ArrayList<bm>();
		list=bd.selectall();
		request.setAttribute("list", list);
		RequestDispatcher rd=request.getRequestDispatcher("addren.jsp");
		rd.forward(request, response);
	}
	
	

	/************添加人员**************************************************/
	public void addry(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		String name=request.getParameter("name");
		String phone=request.getParameter("phone");
		String address=request.getParameter("address");
		int bmid=Integer.parseInt(request.getParameter("bmid"));
		int a=ry.addry(name, phone, address, bmid);
		if (a>0) {
			System.out.println("添加人员成功");
			//查询所有人员
			selectallry(request, response);
		}
	}
	
	/************查看所有人员**************************************************/
	public void selectallry(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		List<Map<String, Object>> list=ry.selectall();
		request.setAttribute("list", list);
		RequestDispatcher rd=request.getRequestDispatcher("showry.jsp");
		rd.forward(request, response);
	}
	/************查看所有人员********************************************************************************/
	public void select(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException{
		int size=0;	
		int pagecount=0;
		int curPage=1;
		List<Map<String, Object>>list1=ry.selectall();
		size=list1.size();
		pagecount=(size%3==0)?(size/3):(size/3+1);
		String curpage=request.getParameter("curPage");
		String tz=request.getParameter("tz");
		if ("1".equals(tz)) {
			String pagedip=request.getParameter("pagedip");
			curPage=Integer.parseInt(pagedip);
		}
		else if (curpage!=null&&!curpage.isEmpty()) {
			curPage=Integer.parseInt(curpage);
		}
		request.setAttribute("pagecount", pagecount);
		request.setAttribute("curPage",curPage);
		if (curPage>=pagecount) {
			curPage=pagecount;
		}	
		List<Map<String, Object>> list=ry.selectpage(curPage);
		request.setAttribute("list",list);
		RequestDispatcher rd=request.getRequestDispatcher("showry.jsp");
		rd.forward(request, response);
		
	}

	
	
	/***********************修改前根据点中的ID查询一个*********************************************************/
	public void selectone(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("id"));
		List<ry> list=ry.selectone(id);
		for(ry rr:list){
			System.out.println(rr.getName()+rr.getId());
			request.setAttribute("list", rr);
		}
		RequestDispatcher rd=request.getRequestDispatcher("updatery.jsp");
		rd.forward(request, response);
	}
	
	/***********************修改*********************************************************/
	public void update(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("idss"));
		String nname=request.getParameter("name");
		String nphone=request.getParameter("phone");
		String naddress=request.getParameter("address");
		ry.update(id, nname, nphone, naddress);
		selectallry(request, response);
	}
	
	
	/***********************根据ID删除*********************************************************/
	public void selectry(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		int id=Integer.parseInt(request.getParameter("id"));
		System.out.println(id);
		ry.delete(id);
		selectallry(request, response);
	}
	
	public void init() throws ServletException {
		// Put your code here
	}
}

RyDao.java文件：

package dao;

public class RyDao {

	//调用工具包
	static unitl unitl=new unitl();
	static Session session=unitl.lj();
	
	/*******************添加人员信息*******************************************/
	public int addry(String name,String phone,String address,int bmid){
		int a=0;
		//3、开启事务
        Transaction ts=session.beginTransaction();
        //执行数据库操作
        
        ry r=new ry();
        r.setName(name);
        r.setPhone(phone);
        r.setAddress(address);
        r.setBmid(bmid);
        session.save(r);
        
        System.out.println("添加人员成功");
        //提交
		ts.commit();
		//关闭session
		//session.close();
		a=1;
		return a;
	}
	
	/*******************查询所有人员信息*******************************************/
	@SuppressWarnings("unchecked")
	public List<Map<String, Object>> selectall(){
		//执行数据库操作
		//编写hql
		String sql="select r.id,r.name,r.phone,r.address,b.bmname from bm b, ry r where b.id=r.bmid";
		Query query=session.createSQLQuery(sql);
		List<Map<String, Object>> list=query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
		
		return list;
	}
	/*******************查询所有人员信息*******************************************/
	public List<Map<String,Object>> selectpage(int page) {
		// TODO Auto-generated method stub
		Query query = session.createSQLQuery("select r.id,r.name,r.phone,r.address,b.bmname from bm b, ry r where b.id=r.bmid");  
		query.setFirstResult((page-1)*3);
		query.setMaxResults(3);
		List<Map<String,Object>> result=query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
		return result;

	}

	
	/***********根据ID查询一个****************************************************/
	@SuppressWarnings("unchecked")
	public List<ry>  selectone(int id){
		//执行数据库操作
		//编写hql
		String hql="select new ry(id,name,phone,address) from ry where id=?";
		List<ry> list=session.createQuery(hql)
		.setInteger(0, id)
		.list();
		return list;
	}
	/*******************修改人员信息*******************************************/
	public void update(int id, String name,String phone,String address){
		//执行数据库操作
		//编写hql
		//3、开启事务
        Transaction ts=session.beginTransaction();
		//修改    
		ry r=(ry) session.load(ry.class, id);
		r.setName(name);
		r.setPhone(phone);
		r.setAddress(address);
		session.update(r);
		 //提交
		ts.commit();
	}
	/***********根据ID删除部门****************************************************/
	public int delete(int id){
		int a=0;
		//3、开启事务
        Transaction ts=session.beginTransaction();
        //执行数据库操作
        //删除操作
        ry r=(ry)session.get(ry.class, id);//注意强转
        session.delete(r);
        
        
        //提交
		ts.commit();
		//关闭session
		//session.close();
		a=1;
		return a;
	}
}

addren.jsp文件：

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<body style="background-image:url(bg3.jpg)">
   <h1>添加人员界面</h1>
    <form action="RyServlet" method="post">
    <input type="hidden" value="2" name="type">
     名字：<input type="text" name="name"/><br/>
      电话：<input type="text" name="phone"/><br/>
       住址：<input type="text" name="address"/><br/>
       部门：<select name="bmid">
       <c:forEach items="${list}" var="bm">
       <option value="${bm.id}"> ${bm.bmname }</option>
       </c:forEach>  
       </select>
    <input type="submit" value="提交">
    </form>
  </body>

showry.jsp文件：

<body style="background-image:url(bg3.jpg)">
    <h1>这是显示页面</h1>
    <h1>显示人员</h1>
    <table border="1">
    <tr><td>编号</td><td>姓名</td><td>电话</td><td>地址</td><td>部门</td><td>操作</td></tr>
    <c:forEach items="${list}" var="ry"> 
    <tr>
    <td>${ry.id}</td><td>${ry.name}</td><td>${ry.phone}</td><td>${ry.address}</td>
    <td>${ry.bmname}</td>
    
    
    <td><a href="RyServlet?type=5&&id=${ry.id}">修改</a>
  &nbsp;&nbsp;
     <a href="RyServlet?type=4&&id=${ry.id}">删除</a></td>
     </tr>
     </c:forEach>
     </table>
      <a href="RyServlet?type=3&&curPage=1">首页</a>
    <a href="RyServlet?type=3&&curPage=${curPage-1}">上一页</a> 
    <a href="RyServlet?type=3&&curPage=${curPage+1}">下一页</a>
    <a href="RyServlet?type=3&&curPage=${pagecount}">尾页</a> 总页数：${pagecount} 当前页数：${curPage}<br/>
    <form action="RyServlet?type=3" method="post">
    
跳转到<input type="text"  name="pagedip" value="${curPage}" />页 
<input type="hidden" name="tz" value="1"/>  
<input type="submit" value="跳转"  />
     
  </body>

updatery.jsp文件：

<body>
  <h1>修改内容页面</h1>
      <form action="RyServlet" method="post">
    <input type="hidden" value="6" name="type">
    <input type="hidden" name="idss" value="${list.id}"/>
    
   名字：<input type="text" name="name" value="${list.name}"/><br/>
      电话：<input type="text" name="phone" value="${list.phone}"/><br/>
       地址：<input type="text" name="address"  value="${list.address}"/><br/>
       <input type="submit" value="提交">
       </form>
       </body>

以上就是我的全部代码，部门jsp文件的c标签的包没导入，要注意一下，具体其他的页面可以参考我之前写的博客