登陆页面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" class="style1 style2" ><font color="blue" size="5">系统登录
</div></td>
</tr>
<form name="loginForm" action="denglu.jsp" method="post">
<tr>
<td height="28"><span class="style5">用户名:</span> <input type="text" name="uid" maxlength="20" style="width:150"></td></tr><br>
<tr>
<td><span class="style5">密 码:</span> <input type="password" 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>
注册页面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 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();}
%>
怎么插入不了数据库呢,执行了SELECT * FROM student;记录为零
<%@ 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" class="style1 style2" ><font color="blue" size="5">系统登录
</div></td>
</tr>
<form name="loginForm" action="denglu.jsp" method="post">
<tr>
<td height="28"><span class="style5">用户名:</span> <input type="text" name="uid" maxlength="20" style="width:150"></td></tr><br>
<tr>
<td><span class="style5">密 码:</span> <input type="password" 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>
注册页面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 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();}
%>
怎么插入不了数据库呢,执行了SELECT * FROM student;记录为零
解决方案 »
- 发帖来讨论一下大家使用POI的一些问题,比如数据类型的转化,row的控制等
- 【求助】ibatis映射得到只有最后一条记录
- 关于filter页面控制访问权限问题....
- 可以在applicationContext.xml里配置让数据库自动生成表?
- 请问现在哪种服务器支持热布署?我是指在开发时,因为现在Tomcat6已经不支持热布署了
- 怎样用java实现不用ant来驱动middlegen?
- 狂晕的generator问题
- 發郵件附件為.html文件。我想通過郵件正文直接把.html的內容顯示在正文中。急急急(真的沒有分了,也幫忙看一下吧)
- 真郁闷:TOMCAT配置出现这样的问题:可以打开HTM文件,但是一碰到JSP就报错(100分奉上解决者,分已经给出,别处结贴)
- 如下错误:java.lang.ClassNotFoundException: javax.xml.parsers.SAXParserFactory
- struts2问题
- 数据库有数据resultset.next()却是false,急急啊
1. Class.forName("com.mysql.jdbc.Driver").newInstance();
去掉.newInstance();没有必要用.newInstance()2. conn= DriverManager.getConnection("jdbc:mysql://localhost/test","root","root");
stmt= conn.createStatement();连接数据库就有问题,连接url改为:jdbc:mysql://localhost:3306/test
3. 再看看你的mysql.jar文件是否放置到WEB-INF/lib目录了
楼主你的sql少了个右括号吧!
String insertquery= "insert into student values('"+susername+"','"+spassward+"','"+school+"','"+scho+"','"+sclass+"','"+stel+"','"+sgender+"')";
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");2、SQL语句少了右括号
String insertquery= "insert into student values('"+susername+"','"+spassward+"','"+school+"','"+scho+"','"+sclass+"','"+stel+"','"+sgender+"')";