Struts与hibernate整合关键代码(课堂案例)

1.表结构

DDL信息

create table
CREATE TABLE `sys` (    `id` int(11) NOT NULL AUTO_INCREMENT,    `username` varchar(50) NOT NULL,    `password` varchar(50) NOT NULL,    `realname` varchar(50) DEFAULT NULL,    `company` varchar(50) DEFAULT NULL,    PRIMARY KEY (`id`)  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='系统用户表'

2.UserDAO

package com.lc.dao;

import org.hibernate.*;
import com.lc.pojo.*;

public class UserDAO {

	public void addUser(Sys sys){
		//创建session
		Session s = HibernateSessionFactory.getSession();
		//创建事务处理对象
		Transaction t = s.beginTransaction();
		//执行操作
		s.save(sys);
		//提交事务
		t.commit();
		//关闭session
		s.close();
	}
	
	public void delUser(Sys sys){
		Sys mySys = null;
		//创建session
		Session s = HibernateSessionFactory.getSession();
		//创建事务处理对象
		Transaction t = s.beginTransaction();
		//执行操作
		mySys = (Sys)s.get(sys.getClass(), sys.getId());
		s.delete(mySys);
		//提交事务
		t.commit();
		//关闭session
		s.close();
	}
}

3.添加用户-AddUserAction

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.lc.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.lc.dao.UserDAO;
import com.lc.pojo.Sys;
import com.lc.struts.form.SysForm;

/** 
 * MyEclipse Struts
 * Creation date: 08-29-2012
 * 
 * XDoclet definition:
 * @struts.action path="/AddUserAction" name="SysForm" scope="request" validate="true"
 */
public class AddUserAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		SysForm SysForm = (SysForm) form;// TODO Auto-generated method stub
		UserDAO user = new UserDAO();
		Sys sys = new Sys(SysForm.getUsername(), SysForm.getPassword(), SysForm.getRealname(), SysForm.getCompany());
		user.addUser(sys);
		return null;
	}
}

4.删除用户-DelUserAction

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.lc.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.lc.dao.UserDAO;
import com.lc.pojo.Sys;
import com.lc.struts.form.DelForm;

/** 
 * MyEclipse Struts
 * Creation date: 08-29-2012
 * 
 * XDoclet definition:
 * @struts.action path="/DelUserAction" name="DelForm" scope="request" validate="true"
 */
public class DelUserAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		DelForm DelForm = (DelForm) form;// TODO Auto-generated method stub
		UserDAO user = new UserDAO();
		Sys sys = new Sys();
		sys.setId(Integer.parseInt(DelForm.getUserid()));
		user.delUser(sys);
		return null;
	}
}