registeraction.java

这是 一个 考试测试系统。哈哈 个 考试测试系统。哈哈

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

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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.edgedu.connection.GetConn;
import com.edgedu.struts.form.EmployeeForm;

public class RegisterAction extends Action {

	// 查询数据库总纪录数
	public int count() {
		int i = 0;
		String sql = "select count(*) from employee";

		try {
			//------------是否是执行完毕后自动关闭连接？
			ResultSet rs = new GetConn().getConn().createStatement()
					.executeQuery(sql);
	
			while (rs.next()) {
				i = Integer.parseInt(rs.getString(1));
			}

		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i++;
		
	}

	// 注册用户
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws SQLException {

		// 取得表单内容
		EmployeeForm reg = (EmployeeForm) form;
		RegisterAction ra = new RegisterAction();
		int i = ra.count();
	

		String sql = "INSERT INTO employee  VALUES(?,?,?,?) ";
		PreparedStatement pst = null;
		Connection conn = null;

		// 创建连接,执行语句
		try {
			i++;
			conn = new GetConn().getConn();
			pst = conn.prepareStatement(sql);
			pst.setInt(1, i);
			pst.setString(2, reg.getName());
			pst.setString(3, reg.getPassword());
			pst.setString(4, reg.getTruename());
			// 别忘记了这一句
			pst.executeUpdate();
			request.setAttribute("message", "success");
		} catch (SQLException e) {
			System.out.println("创建连接,执行语句出错！");
			request.setAttribute("message", "error");
			}
		
	
			
		return mapping.findForward("register");

	}
}