我的JAVAEE 记录成长
第一次尝试开发竞赛报名系统
登陆页面login.jsp
%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.util.*" %>
<html>
<head>
<title>欢迎进入网页制作大赛报名系统</title>
</head>
<center><IMG SRC="C:\tomcat-6.0.30\webapps\myapp\Data\top.gif" width=500 height=80 ></center>
<body background="C:\tomcat-6.0.30\webapps\myapp\Data\1.jpg">
<marquee scrolldelay="200" scrollamount="15"><b><font color="red" size="5">为了给阜阳师范学院学子留下一辈子最美好的财富，特开展此次竞赛，欢迎同学们踊跃参加…… </b> </marquee>
<center> <table><tr><tr></tr><td>
<center><table>
<tr>
<td><div align="center" ><font color="blue" size="5">系统登录
</div></td>
</tr>
<form name="loginForm" action="denglu.jsp" method="post">
<tr>
<td height="28"><span name="uid" maxlength="20" style="width:150"></td></tr><br>
<tr>
<td><span name="upwd" maxlength="20" style="width:150"></td></tr><br>
<center>
<tr><td><div align="center">
<input type="submit" value="登录" >
<input type="button" value="注册" onclick="window.open('register.jsp')">
</div></td></tr> </td>
</form>
</table></center><tr> </tr><tr> </tr><tr> </tr><td>
<textarea cols=80 rows=15>最新公告:
亲爱的同学们，欢迎参加2011年网页设计大赛，
请于一周内注册信息，并核对信息!!!
2011年11月10日
黄春武</textarea></td><tr></center>
</body>
</html>
特殊身份登陆验证denglu.jsp
<%@ page contentType="text/html;charset=GB18030"%>
<%@ page import="java.util.*" %>
<%
if(request.getParameter("uid").equals("vac")&&request.getParameter("upwd").equals("19910402"))
{
session.setAttribute("login","ok");
session.setMaxInactiveInterval(-1);
%>
<jsp:forward page="chenggong.jsp"/>
<%
}else{
out.println("用户名或密码输入错误！");
}
%>
chenggong.jsp页面
<%@ page contentType="text/html;charset=GB18030"%>
<%@ page import="java.util.*" %>
<%@ include file="checkvalid.jsp" %>
<html>
<head>
<title>~WELCOME TO MY HOMEPAGE~</title>
</head>
<body>
<center>
~WELCOME TO MY HOMEPAGE~
</center>
</body>
</html>
checkvalid.jsp页面
<%@ page import="java.util.*" %>
<%
if(session.getAttribute("login")==null||!session.getAttribute("login").equals("ok")){
response.sendRedirect("login.htm");
}
%>
注册页面register.jsp
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.util.*" %>
<html>
<head>
<title>用户注册页面</title>
</head>
<body><fieldset><legend><font color="#ff666" size="5">新考生注册</legend>
<form name="registernew" action="registernew.jsp" method="post">
<table align="center">
<td>用户名:</td>
<td><input type="text" size="25" name="Name"></td><tr>
<td>密码:</td>
<td><input type="text" size="25" name="passward1"></td><tr><tr>
<td>重复密码:</td>
<td><input type="text" size="25" name="passward2"></td><tr><tr><tr>
<td>学院:</td>
<td><input type="text" size="25" name="xueyuan"></td><tr><tr><tr>
<td>专业:</td>
<td><input type="text" size="25" name="zhuanye"></td><tr><tr><tr>
<td>年级:</td>
<td><input type="text" size="25" name="nianji"></td><tr><tr><tr>
<td>TEL:</td>
<td><input type="text" size="25" name="number"></td><tr><tr><tr>
<td>性别:</td>
<td align="center"><input type="radio" size="25" name="gender" value="男" checked="true">男
<input type="radio" size="25" name="gender" selected value="女" checked="true">女</td></table><br>
<center> <input type="submit" value="提交">
<input type="reset" value="重置"></td></center></fieldset>
</form></body></html>
注册数据存入数据库registernew.jsp 怎么失败了
<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB18030"%>
<%@ page import="java.util.*" %>
<%
request.setCharacterEncoding("GB18030");
String susername,spassward,school,scho,sclass,stel,sgender;
susername=request.getParameter("Name");
spassward=request.getParameter("passward1");
school=request.getParameter("xueyuan");
scho=request.getParameter("zhuanye");
sclass=request.getParameter("nianji");
stel=request.getParameter("number");
sgender=request.getParameter("gender");
String insertquery= "insert into student values('"+susername+"','"+spassward+"','"+school+"','"+scho+"','"+sclass+"','"+stel+"','"+sgender+"'"); ）没有打最后在论坛提问才找到的！！！
String selectquery="select * from student where Name='"+susername+"'";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn= DriverManager.getConnection("jdbc:mysql://localhost/test","root","root");
stmt= conn.createStatement();
rs=stmt.executeQuery(selectquery);
if(rs.next()){
response.sendRedirect("register.jsp");
return;}
else{
stmt.executeUpdate(insertquery);}
}catch(SQLException ex)
{
ex.printStackTrace();
response.sendRedirect("login.jsp");}
finally{
stmt.close();
conn.close();}
%>
