zhuce.jsp

网上聊天室.用JSP+SQL+SERVLET+ SERVER 2000数据库等构建而成

<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ page import="java.sql.*,java.io.*"%>
<%@ include file="include.inc"%>

<%
	Class.forName(CLASSFORNAME);
	Connection con=DriverManager.getConnection(SERVER,USER,PWD);
	Statement stmt=con.createStatement();
	
	String username=request.getParameter("username");
	String password1=request.getParameter("password1");
	String password2=request.getParameter("password2");
	String nicheng=request.getParameter("nicheng");
	
	if(username.equals(""))
	{
		out.println("<script language='javascript'>alert('请填写完整信息');parent.location.href='zhuce.html';</script>");
	}
	else if(password1.equals(""))
	{
		out.println("<script language='javascript'>alert('请填写完整信息');parent.location.href='zhuce.html';</script>");
	}
	else if(nicheng.equals(""))
	{
		out.println("<script language='javascript'>alert('请填写完整信息');parent.location.href='zhuce.html';</script>");
	}	
	else if(!password1.equals(password2))
	{
		out.println("<script language='javascript'>alert('两次密码不一致');parent.location.href='zhuce.html';</script>");		
	}
	else
	{
		String str="select * from user_info where username='"+username+"'";
		ResultSet rs=stmt.executeQuery(str);
		if(!rs.next())
		{
			try
			{
			PreparedStatement pstmt=con.prepareStatement("insert into user_info (username,password,nicheng) values(?,?,?)");
			pstmt.setString(1,username);
			pstmt.setString(2,password1);
			pstmt.setString(3,nicheng);
			pstmt.executeUpdate();

			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
			out.println("<script language='javascript'>alert('注册成功');parent.location.href='login.html';</script>");
			con.close();
			stmt.close();
			rs.close();
		}
		else
		{
			out.println("<script language='javascript'>alert('用户名已经存在');parent.location.href='zhuce.html';</script>");
			con.close();
			stmt.close();
			rs.close();
		}
	}
%>