registershow.java

购物车 购物车 购物车 购物车 购物车

package coreservlets;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class registerShow extends HttpServlet {
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
		try{
		
		String name,address,password1,password2,email;
		address="";
		String info;//用于显示注册页面错误信息
		name = request.getParameter("user");
		password1 = request.getParameter("password1");
		password2 = request.getParameter("password2");
		email = request.getParameter("email");
		
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");// .microsoft.jdbc.sqlServer.SQLServerDriver");
		Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","");
		Statement st=conn.createStatement();
		st.setMaxRows(20);
		
		if((name==null)||(password1==null)||(password2==null)||(name.trim().equals(""))||(password1.trim().equals(""))||(password2.trim().equals("")))
		{
		address="/register.jsp";
		info="用户名或密码不能为空";
		request.setAttribute("wronginfo",info);
		}
		else
		{
		if(!password1.equals(password2))
		{
		address="/register.jsp";
		info="第二次密码和第一次密码不一致";
		request.setAttribute("wronginfo",info);
		}
		else
		{

		String sqlStr = "select * from customer where username='"+name+"' and password='"+password1+"'";
		ResultSet rs=st.executeQuery(sqlStr);
		
		if (rs.next())//数据已存在在数据库中
		{
		address="/register.jsp";
		info="该用户已经存在";
		request.setAttribute("wronginfo",info);
		}
		else
		{
		
		sqlStr = "INSERT INTO customer (username,password,account,email) VALUES ('"+name+"','"+password1+"','0','"+email+"')";
		int rs1 = st.executeUpdate(sqlStr); 
		User userbean1 = new User(name,password1);
		request.setAttribute("userbean",userbean1);
		address="/welcome.jsp";
		}
		rs.close();
		}
		}
		st.close();    
	   conn.close();
		RequestDispatcher dispatcher = request.getRequestDispatcher(address);
		dispatcher.forward(request,response);
		}catch(SQLException sqle){
		sqle.printStackTrace();
	}
	catch(Exception ex){
		ex.printStackTrace();
	}
		
}
}