adduser.jsp

精通从JavaScript到Jsp范例程序设计

<%@ page 
  language="java" 
  errorPage="bookStoreErr.jsp"
  import="java.sql.*,
         java.io.*,
         xbook.common.*,
         xbook.bookstore.*;"
  contentType="text/html; charset=Big5" %>

<jsp:useBean 
  id="connPool" scope="application" 
  type="xbook.common.ConnPool" />

<jsp:useBean id="sqlBridge" scope="page" 
  class="xbook.common.SQLBridge" >
  <jsp:setProperty name="sqlBridge" property="connPool" 
    value="<%=connPool%>" />
  <jsp:setProperty name="sqlBridge" property="connectionSwitch" 
    value="on" />
</jsp:useBean>

<jsp:useBean id="userPassword" scope="page" 
  class="xbook.bookstore.LoginPassword" >
  <jsp:setProperty name="userPassword" property="sqlBridge" 
    value="<%=sqlBridge%>" />
</jsp:useBean>

<jsp:useBean id="userTbl" scope="page" 
  class="xbook.bookstore.users" >
  <jsp:setProperty name="userTbl" property="id" 
    param="id"/>
  <jsp:setProperty name="userTbl" property="name" 
    param="name"/>
  <jsp:setProperty name="userTbl" property="sex" 
    param="sex"/>
  <jsp:setProperty name="userTbl" property="age" 
    param="age"/>
  <jsp:setProperty name="userTbl" property="vocation" 
    param="vocation"/>
  <jsp:setProperty name="userTbl" property="tel" 
    param="tel"/>
  <jsp:setProperty name="userTbl" property="fax" 
    param="fax"/>
  <jsp:setProperty name="userTbl" property="addr" 
    param="addr"/>
  <jsp:setProperty name="userTbl" property="email" 
    param="email"/>
</jsp:useBean>

<%
  String password = userPassword.getPassword();
  String[] id = userTbl.getId();
  try{	  
    if( ( id == null ) || ( id[0].trim().length() == 0 ) ){
      sqlBridge.closeDB();
      throw new Exception( "叫眖