我的环境 winXP sp2
java 1.5 ;tomcat 5.5; sql server 2000+sp4用java 是可以正确运行.java字节码的
用tomcat 也可以正确运行.jsp网页已经装过Microsoft SQL Server 2000 Driver for JDBC Service Pack 3
且配置过classpath变量
也把那三个.jar文件放在Tomcat\common\lib目录下了设置算是参考天极网这个网页http://www.yesky.com/288/1843788.shtml或有那位高手能不能把你安装软件时要注意的问题和设置过程共享一下呢?
昨天弄了一天了,还是不行。
但就仅仅运行下面几句代码就出错了
下面的代码应该是没有错误的吧!——会不会跟设置有关呢?
<%@page import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testdata","sa","xxy2006");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM book");
%>错误提示是:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
sql cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
con cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
sql cannot be resolved
java 1.5 ;tomcat 5.5; sql server 2000+sp4用java 是可以正确运行.java字节码的
用tomcat 也可以正确运行.jsp网页已经装过Microsoft SQL Server 2000 Driver for JDBC Service Pack 3
且配置过classpath变量
也把那三个.jar文件放在Tomcat\common\lib目录下了设置算是参考天极网这个网页http://www.yesky.com/288/1843788.shtml或有那位高手能不能把你安装软件时要注意的问题和设置过程共享一下呢?
昨天弄了一天了,还是不行。
但就仅仅运行下面几句代码就出错了
下面的代码应该是没有错误的吧!——会不会跟设置有关呢?
<%@page import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testdata","sa","xxy2006");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM book");
%>错误提示是:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
sql cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
con cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
rs cannot be resolvedAn error occurred at line: 2 in the jsp file: /mssql.jsp
Generated servlet error:
sql cannot be resolved
解决方案 »
- jqGrid操作
- 视频文件不能播放的问题==============在线等
- 在JSP页面里如何高亮显示从数据库提取出来的数据?
- 除了jspsmartupload之外,还有什么好的下载组件?最近很多人问这个问题。
- 如何同时解决GET和POST方法提交数据出现的中文问题?
- 在ie上点击后退按钮的自动刷新问题
- JSTL的标签到底能不能访问jsp脚本<%%>中定义的变量啊??
- 在Action里怎样改变用户的Locale?
- struts中怎样处理ActionErrors
- javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配
- jspsmart下载问题。(在网上没搜到类似的问题)
- 赠分40!!
<%
Connection conn;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=testdata","sa","xxy2006");
sql=conn.createStatement();
rs=sql.executeQuery("SELECT * FROM book");
%>
<%
Connection conn;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=testdata","sa","xxy2006");
sql=conn.createStatement();
rs=sql.executeQuery("SELECT * FROM book");
%>
没有错啊
Statement sql = null;
ResultSet rs = null;这些都要初始化的