开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
register_confirm.jsp
资源名称：JSP购物车(SQLserver版).rar　[点击查看]
上传用户：sanhemotor
上传日期：2010-01-25
资源大小：381k
文件大小：3k
源码类别：

电子政务应用

开发平台：

Java

register_confirm.jsp：源码内容
  1. <%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
  2. <html>
  3. <head>
  4. <title>注册确认</title>
  5. <link rel=stylesheet href="style.css" type="text/css">
  6. </head>
  7. <body>
  8. <center>
  10. <% 
  11.   String name=request.getParameter("name");
  12.   String password=request.getParameter("password");
  13.   String e_mail=request.getParameter("e_mail");
  14.   String telephone=request.getParameter("telephone");
  15.   String address=request.getParameter("address");
  17.   String query="select * from customer_info where name='"+name+"'";                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
  18. String  sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  19.  Class.forName(sDBDriver);
  21. String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Web";
  22. String username="sa";
  23. String pwd="";
  24. Connection connWeb=DriverManager.getConnection(sConnStr,username,pwd);
  25. Statement stmt=connWeb.createStatement(); 
  26. ResultSet rs=stmt.executeQuery(query);
  27. if(rs.next())
  28. {
  29.   rs.close();
  30.   session.putValue("register_message","用户名已存在，请重新注册！");
  31. %>
  32. <jsp.forward page="register.jsp"/>
  33. <% }
  34. else
  35. {
  36. rs.close();
  37. }
  40. %>
  41. <FORM METHOD=POST ACTION="do_register.jsp">
  42. <INPUT TYPE="hidden" name="name" value="<%=name%>">
  43. <INPUT TYPE="hidden" name="password" value="<%=password%>">
  44. <INPUT TYPE="hidden" name="e_mail" value="<%=e_mail%>">
  45. <INPUT TYPE="hidden" name="telephone" value="<%=telephone%>">
  46. <INPUT TYPE="hidden" name="address" value="<%=address%>">
  47. <!--<table border="0" width="500" cellspacing="0" cellpadding="0" height="5" style="border-collapse: collapse" bordercolor="#111111">
  48.  <tr> 
  49.             <td bgcolor="#F5EFE7"> <table border="0" width="100%" cellspacing="1">
  50.                 <tr> 
  51.                   <td width="100%" ><br> 
  52.                   <div align="center">
  53.                     <center> 
  54.                     <table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  55. -->
  56. 亲爱的<%=name%>,请检查您的注册信息<br><br>
  57. <TABLE width="60%" border="1">
  58. <TABLE width="60%" border="1">
  59. <TR>
  60.    <TD>您的帐号：</TD>
  61.     <TD><%=name%></TD>
  62. </TR>
  63. <TR>
  64.    <TD>密&nbsp;&nbsp;&nbsp;码：</TD>
  65.     <TD><%=password%></TD>
  66. </TR>
  67. <TR>
  68.    <TD>E_mail：</TD>
  69.     <TD><%=e_mail%></TD>
  70. </TR>
  71. <TR>
  72.    <TD>电话号码：</TD>
  73.     <TD><%=telephone%></TD>
  74. </TR>
  75. <TR>
  76.    <TD>您的地址：</TD>
  77.     <TD><%=address%></TD>
  78. </TR>
  79. </TABLE>
  80. <br>
  81. <INPUT TYPE="submit" value="提交注册">&nbsp;&nbsp;
  82. <INPUT TYPE="button" value="返回修改" onclick="history.back()">
  83. </FORM>
  84. </CENTER>
  85. </BODY>
  86. </HTML>