register.java

J2EE平台是一种比较 优秀的开发平台 此为其上一个比较大的案例开发

package UserAdmin;
/**
功能：注册用户
@version 1.0.1

*/
import java.io.FileInputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
public class Register extends HttpServlet
{
	public void doGet(HttpServletRequest req, HttpServletResponse res)
		throws ServletException, IOException
	{
		res.setContentType("text/html;charset=gb2312");
		HttpSession session = req.getSession();
		ServletContext sc = session.getServletContext();
		PrintWriter out = res.getWriter();
		//获取提交信息；由于编码问题，不能直接将取得的信息存入数据库，必须先将其编码转换成数据库能识别的编码；
		String username =
			new String(req.getParameter("username").getBytes(), "ISO8859-1");
		//在用户输入用户名的时候最好能将输入的前后空格消去*
		String password =
			new String(req.getParameter("password").getBytes(), "ISO8859-1");
		String name =
			new String(req.getParameter("name").getBytes(), "ISO8859-1");
		String sex =
			new String(req.getParameter("sex").getBytes(), "ISO8859-1");
		String idnumber =
			new String(req.getParameter("idnumber").getBytes(), "ISO8859-1");
		String address =
			new String(req.getParameter("Address").getBytes(), "ISO8859-1");
		String postcode =
			new String(req.getParameter("postcode").getBytes(), "ISO8859-1");
		String tel =
			new String(req.getParameter("Tel").getBytes(), "ISO8859-1");
		String email =
			new String(req.getParameter("email").getBytes(), "ISO8859-1");
		String fax =
			new String(req.getParameter("fax").getBytes(), "ISO8859-1");
		String question =
			new String(req.getParameter("question").getBytes(), "ISO8859-1");
		String answer =
			new String(req.getParameter("answer").getBytes(), "ISO8859-1");
		String CompanyName =
			new String(req.getParameter("CompanyName").getBytes(), "ISO8859-1");
		String CompanyAddr =
			new String(req.getParameter("CompanyAddr").getBytes(), "ISO8859-1");
		String CompanyKind =
			new String(req.getParameter("CompanyKind").getBytes(), "ISO8859-1");
		//获取服务器信息；
		Properties properties = new Properties();
		properties.load(new FileInputStream(sc.getRealPath("conn.properties")));
		String DriverName = properties.getProperty("DriverName");
		String BaseName = properties.getProperty("BaseName");
		String ServerName = properties.getProperty("ServerName");
		String port = properties.getProperty("port");
		String uName = properties.getProperty("username");
		String psd = properties.getProperty("password");
		try
		{
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			//建立数据库连接；
			String url =
				"jdbc:oracle:thin:@" + ServerName + ":" + port + ":" + BaseName;
			Class.forName(DriverName);
			Connection jbc = DriverManager.getConnection(url, uName, psd);
			String search = "select * from USER_REG where USER_NAME=?";
			PreparedStatement ps;
			ps = jbc.prepareStatement(search);
			ps.setString(1, username);
			ResultSet rs = ps.executeQuery();
			boolean isEmpty = !rs.next();
			if (!isEmpty)
			{
				//用户名已经存在，提示用户重新注册；
				res.sendRedirect(
					res.encodeURL("./UserAdmin/registererror.jsp"));
			}
			else
			{
				//*取出最大USER_ID
				//*最大USER_ID+1,存入数据库
				//用户名不存在，将用户信息存入数据库；
				String register =
					"insert into USER_REG(USER_NAME,USER_PWD,NAME,SEX,USER_IDCARD,USER_ADD,USER_ZIP,USER_TEL,USER_EMAIL,USER_FAX,QUESTION,ANSWER,COMPANYNAME,COMPANYKIND,COMPANYADDR)"
						+ "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
				PreparedStatement psr;
				psr = jbc.prepareStatement(register);
				psr.setString(1, username);
				psr.setString(2, password);
				psr.setString(3, name);
				psr.setString(4, sex);
				psr.setString(5, idnumber);
				psr.setString(6, address);
				psr.setString(7, postcode);
				psr.setString(8, tel);
				psr.setString(9, email);
				psr.setString(10, fax);
				psr.setString(11, question);
				psr.setString(12, answer);
				psr.setString(13, CompanyName);
				psr.setString(14, CompanyKind);
				psr.setString(15, CompanyAddr);
				psr.executeUpdate();
				psr.close();
				//提示用户注册成功；
				res.sendRedirect(res.encodeURL("./UserAdmin/registerok.jsp"));
			}
			ps.close();
			jbc.close();
		}
		catch (Exception ex)
		{
			throw new ServletException(ex.getMessage());
		}
	}
	public void doPost(HttpServletRequest req, HttpServletResponse res)
		throws ServletException, IOException
	{
		doGet(req, res);
	}
	public static void main(String[] args)
	{
		System.out.println("Hello World!");
	}
}