主题:[讨论]JSP数据库问题
源码
<% @ page import="java.util.*" %>
<% @ page import="java.sql.*" %>
<%
Connection conn;
Statement stmt;
ResultSet rs;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
try{
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://SWT:1433;DatabaseName=dada","sa","swt");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from denglu");
}
catch(SQLException e1){
}
%>
错误提示
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 1 in the jsp file: /share/dlconn.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\denglu_jsp.java:49: illegal character: \64
@ page import="java.util.*"
^
An error occurred at line: 2 in the jsp file: /share/dlconn.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\denglu_jsp.java:52: illegal character: \64
@ page import="java.sql.*"
^
2 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
谢谢大家拉
<% @ page import="java.util.*" %>
<% @ page import="java.sql.*" %>
<%
Connection conn;
Statement stmt;
ResultSet rs;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
try{
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://SWT:1433;DatabaseName=dada","sa","swt");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from denglu");
}
catch(SQLException e1){
}
%>
错误提示
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 1 in the jsp file: /share/dlconn.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\denglu_jsp.java:49: illegal character: \64
@ page import="java.util.*"
^
An error occurred at line: 2 in the jsp file: /share/dlconn.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\denglu_jsp.java:52: illegal character: \64
@ page import="java.sql.*"
^
2 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
谢谢大家拉