登陆页面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;记录为零
这句sql的括号怎么只有一边啊?
前面的代码复制错了
<%@ 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();}
%>
先看你的程式运行到哪里了,
你直接在页面上加上
out.print(insertquery);
看看程式到运行到哪里,没有往下运行了!
if(rs.next()){
response.sendRedirect("register.jsp");}
else{
out.print(insertquery);
//stmt.executeUpdate(insertquery);
}
conn= DriverManager.getConnection("jdbc:mysql://localhost/test","root","root");
你先system这个conn看看是否为空把
import java.sql.DriverManager;
import java.sql.SQLException;/**
* DB工具类
* 提供获得和关闭数据库连接的方法
*
*/
public class DBUtil {
/**
* 如果不能获得连接对象(因为系统错误,比如网络问题、数据库没有启动等等),
* 返回null。
*/
public static Connection getConnection(){
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
//DriverManager管理一组 JDBC 驱动程序的基本服务
conn = DriverManager.getConnection"jdbc:mysql://localhost:3306/数据库名字?useUnicode=true&characterEncoding=utf8",,"用户名","密码");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
//关闭连接
public static void close(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/*
* 测试 DB工具类
*/
public static void main(String[] args) {
System.out.println(getConnection());
}}这是连接mysql数据库的一个工具类,
<%@ 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);
response.sendRedirect("login.jsp");}
}catch(SQLException ex)
{
ex.printStackTrace();
}finally{
stmt.close();
conn.close();}
%>