register.jsp

来自「一个用MYECLIPSE开发的网上购物系统。 基本功能都已经实现」· JSP 代码 · 共 81 行

<%@ page language="java" import="java.util.*" import="java.sql.*"
contentType="text/html;charset=gb2312" %>
<%request.setCharacterEncoding("gb2312");%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<jsp:useBean id = "connBean" scope="session" class="db.DbAccess"/>
<% 
	String id = request.getParameter("username").trim();
    String pass = request.getParameter("password").trim();   
    String email = request.getParameter("email").trim();          
    String firstName = request.getParameter("firstname").trim();
    String lastName = request.getParameter("lastname").trim();
    String addr1 = request.getParameter("address1").trim();
    String addr2 = request.getParameter("address2").trim();
    String city = request.getParameter("city").trim();
    String state = request.getParameter("state").trim();
    String zipCode = request.getParameter("zip").trim();
    String country = request.getParameter("country").trim();
    String phone = request.getParameter("phone").trim();   
    
    String lang = request.getParameter("languagePreference");
    String favPet = request.getParameter("favouriteCategory");
    String ckList= request.getParameter("listOption");
    int listOpt = 1;
    int bannerOpt = 1;
   if ( ckList == null ) {
        listOpt = 0;     
    } 
    String ckBanner = request.getParameter("bannerOption");
   if ( ckBanner == null ) {
        bannerOpt = 0;
    }          
	
	try{
			Connection conn = connBean.getConnection();
			if(conn != null){
				java.sql.Statement dstmt = conn.createStatement(); 
   			 	String insertSignon = "INSERT INTO signon VALUES('"
                             	  + id + "', '" + pass + "')";
                             	  
                String insertAccount = "INSERT INTO account(userid, email, firstname," 
                                  + " lastname, addr1, addr2, city, state, zip,"
                              	  + " country, phone) VALUES('"
                              	  + id + "', '" + email + "', '" + firstName + "', '"
                                  + lastName + "', '" + addr1 + "', '" + addr2 + "', '"
                                  + city + "', '" + state + "', '" + zipCode + "', '"
                                  + country + "', '" + phone + "')"; 
                                  
                String insertProfile = "INSERT INTO profile(userid, langpref, favcategory,"
                                  + " mylistopt, banneropt) VALUES('"
                                  + id + "', '" + lang+ "', '" + favPet + "', " 
                                  + String.valueOf(listOpt) + ", " 
                                  + String.valueOf(bannerOpt) + ")";
                             
              int lingNum = dstmt.executeUpdate(insertSignon);
              if(lingNum == 1){
                	dstmt.executeUpdate(insertAccount);
               	 	dstmt.executeUpdate(insertProfile);
                	out.println("register success!");
                }
              else
              		out.println("userName exist in database, choose another");
        	}
        }
       catch(Exception e){
       		out.println(e.getMessage());
        }
%>
<style type="text/css">
<!--
.style1 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #993399;
}
-->
</style>

<a href="default.jsp" class="style1" herf="default.jsp">返回</a>