我在src里边些了一个连接和操作数据库的bean connDB.java,在webroot下面的register_ok.jsp调用它出现了这个错误:org.apache.jasper.JasperException: /bookshop/WebRoot/register_ok.jsp(2,20) equal symbol expected
现给出两个jsp和javabean的代码:
register.jsp:<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<link rel="stylesheet" type="text/css" href="../css/table.css"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>用户注册</title>
<table border="0" cellpadding="2" cellspacing="1" align="center" width="800">
<form action="register_ok.jsp" name="registerform" method="post" onSubmit="return checkform(this)">
<tr>
<td align="right">用户名:</td>
<td><input type="text" name="userName" size="40"></td>
</tr><br>
<tr>
<td align="right">真实姓名:</td>
<td><input type="text" name="trueName" size="40"></td>
</tr>
<tr>
<td align="right">密 码:</td>
<td><input type="password" name="password" size="20"></td>
</tr>
<tr>
<td align="right">确认密码:</td>
<td><input type="password" name="password_2" size="20"></td>
</tr>
<tr>
<td align="right">性 别:</td>
<td><input name="sex" type="radio" checked>男<img src="../image/boy.gif">
<input type="radio" name="sex">女<img src="../image/girl.gif"></td>
</tr>
<tr>
<td align="right">生 日:</td>
<td><input type="text" name="birthday" size="20"></td>
</tr>
<tr>
<td align="right">电 话:</td>
<td><input type="text" name="tel" size="20"></td>
</tr>
<tr>
<td align="right">Q Q:</td>
<td><input type="text" name="QQ" size="20"></td>
</tr>
<tr>
<td align="right">Email:</td>
<td><input type="text" name="email" size="50"></td>
</tr>
<tr>
<td align="right">邮 编:</td>
<td><input type="text" name="postcode" size="30"></td>
</tr>
<tr>
<td align="right">地 址:</td>
<td><input type="text" name="address" size="50"></td>
</tr>
<tr>
<td> </td>
<td> <input type="submit" name="submit" value="注册">
<input type="reset" name="reset" value="重置">
</td>
</tr>
</form>
</table>
现给出两个jsp和javabean的代码:
register.jsp:<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<link rel="stylesheet" type="text/css" href="../css/table.css"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>用户注册</title>
<table border="0" cellpadding="2" cellspacing="1" align="center" width="800">
<form action="register_ok.jsp" name="registerform" method="post" onSubmit="return checkform(this)">
<tr>
<td align="right">用户名:</td>
<td><input type="text" name="userName" size="40"></td>
</tr><br>
<tr>
<td align="right">真实姓名:</td>
<td><input type="text" name="trueName" size="40"></td>
</tr>
<tr>
<td align="right">密 码:</td>
<td><input type="password" name="password" size="20"></td>
</tr>
<tr>
<td align="right">确认密码:</td>
<td><input type="password" name="password_2" size="20"></td>
</tr>
<tr>
<td align="right">性 别:</td>
<td><input name="sex" type="radio" checked>男<img src="../image/boy.gif">
<input type="radio" name="sex">女<img src="../image/girl.gif"></td>
</tr>
<tr>
<td align="right">生 日:</td>
<td><input type="text" name="birthday" size="20"></td>
</tr>
<tr>
<td align="right">电 话:</td>
<td><input type="text" name="tel" size="20"></td>
</tr>
<tr>
<td align="right">Q Q:</td>
<td><input type="text" name="QQ" size="20"></td>
</tr>
<tr>
<td align="right">Email:</td>
<td><input type="text" name="email" size="50"></td>
</tr>
<tr>
<td align="right">邮 编:</td>
<td><input type="text" name="postcode" size="30"></td>
</tr>
<tr>
<td align="right">地 址:</td>
<td><input type="text" name="address" size="50"></td>
</tr>
<tr>
<td> </td>
<td> <input type="submit" name="submit" value="注册">
<input type="reset" name="reset" value="重置">
</td>
</tr>
</form>
</table>
<jsp:useBean id="con" scope="page" class="com.bookshop.bean.connDB">
<%
request.setCharacterEncoding("GBK");
String userName = request.getParameter("userName");
String trueName = request.getParameter("trueName");
String password = request.getParameter("password");
String sex = request.getParameter("sex");
String birthday = request.getParameter("birthday");
int tel = Integer.parseInt(request.getParameter("tel"));
int QQ = Integer.parseInt(request.getParameter("QQ"));
String email = request.getParameter("email");
int postcode = Integer.parseInt(request.getParameter("postcode"));
String address = request.getParameter("address");
String sql = "select * from user where uesrName='"+userName+"'";
String sql_insert = "insert into user(userName,trueName,password,sex,birthday,tel,QQ,email,postcode,address) values('"+userName+"','"+trueName+"','"+password+"','"+sex+"','"+birthday+"',"+tel+","+QQ+",'"+email+"',"+postcode+",'"+address+"')";
System.out.println(sql);
System.out.println(sql_insert);
ResultSet rs = con.executeQuery(sql);
if(rs.next()){
out.println("<script language='javascript'>alert('对不起,该用户已经存在请重新注册!');window.location.href='register.jsp';</script>");
}else{
int result = con.executeUpdate(sql_insert);
if(result!=0){
out.println("<script language='javascript'>alert('恭喜您注册成功!');window.location.href='index.jsp';</script>");
}else{
out.println("<script language='javascript'>alert('对不起,注册失败!');window.location.href='register.jsp';</script>");
}
}
%>
import java.sql.*;public class connDB { Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public connDB() {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/bookshop?"+"user=root&password=root");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
} public int executeUpdate(String sql) {
int result = 0;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/bookshop?"+"user=root&password=root");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return result;
}
public void close() {
if(rs!=null) {
try {
rs.close();
rs = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stmt!=null) {
try {
stmt.close();
stmt = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null) {
try {
conn.close();
conn = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}}
这个地方有笔误,嘻嘻