请教各位高手,帮我看看,错误在那,感激地谢谢大家
请教各位高手,帮我看看,错误在那,感激地谢谢大家
opendb.java文件
package opendb;
import java.sql.*;
public class opendb {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:microsoft qlserver://localhost:1433;DatabaseName=zhang";
Connection conn = null;
ResultSet rs = null;
Statement stmt=null;
public opendb()
{
try
{
Class.forName(sDBDriver);
}
catch (java.lang.ClassNotFoundException e)
{
System.err.println("opendb(): " + e.getMessage());
}
}
public void getConnection()
{
try{
conn=DriverManager.getConnection(sConnStr,"sa","");
}catch(Exception e){}
}
public ResultSet executeQuery(String sql)
{
try
{
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
try
{
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch (SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
public void close()
{
try{
rs.close();
stmt.close();
conn.close();
}catch(Exception e){}
}
}
register.jsp
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="RegisterBean" scope="page" class="opendb.opendb">
<%
RegisterBean.getConnection()
String username=request.getParameter("username");
String password=request.getParameter("password");
String password=request.getParameter("name");
String password=request.getParameter("sex");
String password=request.getParameter("education");
String password=request.getParameter("email");
String password=request.getParameter("resume");
String sql="insert into user(username, password, name, sex, education, email, resume) values (´"+username+"´, ´"+password+"´, ´"+name+"´, ´"+sex+"´, ´"+sex+"´, ´"+education+"´, ´"+email+"´, ´"+resume+"´)";
RegisterBean.executeUpdate(sql);
system.out.println("注册成功");
%>
错误信息
The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: /register.jsp(17,0) Unterminated <jsp:useBean> tag
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:428)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:170)
at org.apache.jasper.compiler.Parser.parseBody(Parser.java:835)
at org.apache.jasper.compiler.Parser.parseUseBean(Parser.java:585)
at org.apache.jasper.compiler.Parser.parseAction(Parser.java:667)
at org.apache.jasper.compiler.Parser.parseElements(Parser.java:803)
at org.apache.jasper.compiler.Parser.parse(Parser.java:122)
请求高手帮帮我!