我在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">密&nbsp;&nbsp;码:</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">性&nbsp;&nbsp;别:</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">生&nbsp;&nbsp;日:</td>
<td><input type="text" name="birthday" size="20"></td>
</tr>
<tr>
<td align="right">电&nbsp;&nbsp;话:</td>
<td><input type="text" name="tel" size="20"></td>
</tr>
<tr>
<td align="right">Q&nbsp;&nbsp;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">邮&nbsp;&nbsp;编:</td>
<td><input type="text" name="postcode" size="30"></td>
</tr>
<tr>
<td align="right">地&nbsp;&nbsp;址:</td>
<td><input type="text" name="address" size="50"></td>
</tr>
<tr>
<td>&nbsp;&nbsp;</td>
<td>&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" value="注册">
&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset"  name="reset" value="重置">
</td>
</tr>
</form>
</table>

解决方案 »

  1.   

    register_ok.jsp:<%@ page contentType="text/html;charset=GBK" language="java" import="java.util.*,java.sql.*" pageEncoding="GBK%>
    <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>");
    }
    }
    %>
      

  2.   

    package com.bookshop.bean;
    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();
    }
    }
    }}
      

  3.   

    看不明白,没用过jsp处理页面请求的,友情up!
      

  4.   

    pageEncoding="GBK
    这个地方有笔误,嘻嘻