jsp怎么向mysql插入不了数据

来源：互联网发布：人工智能的研究方向编辑：程序博客网时间：2024/05/10 19:28

登陆页面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>

<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></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;记录为零