regaction.java

基于j2ee中structs写软件

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

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
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.util.DB;
import com.yourcompany.struts.form.RegForm;

/** 
 * MyEclipse Struts
 * Creation date: 10-28-2008
 * 
 * XDoclet definition:
 * @struts.action path="/reg" name="regForm" input="/reg.jsp" scope="request" validate="true"
 */
public class RegAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws IOException 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws IOException {
		RegForm regForm = (RegForm) form;// TODO Auto-generated method stub
		String id=regForm.getUserId();
		String password=regForm.getUserPassword();
		String card=regForm.getUserCard();
		String name=regForm.getUserName();
		String sex=regForm.getUserSex();
		String phone=regForm.getUserPhone();
		String email=regForm.getUserEmail();
		String address=regForm.getUserAddress();
		String CONTENT_TYPE="text/html;charset=GB2312";
		response.setContentType(CONTENT_TYPE);
		PrintWriter out=response.getWriter();
		try{
			DB db=new DB();
			Connection conn=db.getConnection();
			Statement sm=conn.createStatement();
			String sql="insert into user values('"+id+"','"+password+"','"+card+"','"+name+"','"+sex+"','"+phone+"','"+email+"','"+address+"','0')";
			int rs=sm.executeUpdate(sql);
			if(rs!=0){
				out.println("<script language=javascript>alert('注册成功!')");
			    out.println("location.href='reg.jsp'</script>");
			}
			else{
				out.println("<script language=javascript>alert('注册失败!')");
			    out.println("location.href='reg.jsp'</script>");
			}
			conn.close();
		}catch(SQLException e){}
		return null;
	}
}