小弟是初学者.
首先说下我的情况,JSP开发环境已经建好,可以开发JSP页面,用的是MS SQL 2000,数据库也是没问题的.然后我用JSP连接SQL,却一直不成功.我下了JDBC和ODBC的桥接,并安装了,然后下了JDBC的JAR包,放在D:\Tomcat 5.5\common\lib这个文件夹里面.CLASSPATH的变量设置是.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tool.jar;%JAVA_HOME%\lib\tools.jar;%TOMCAT_HOME%\common\lib\servlet-api.jar;%TOMCAT_HOME%\common\lib\jsp-api.jar;%TOMCAT_HOME%\common\lib\msbase.jar;%TOMCAT_HOME%\common\lib\mssqlserver.jar;%TOMCAT_HOME%\common\lib\msutil.jar
我SQL服务器的名称是RAIN,登陆帐号是SA,密码是111.我想连接到服务器里面的neusoft数据库.从网络上参考了一位前辈的语句,但一直提示错误.其代码为:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=neusoft";
String user="sa";
String password="111";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";&nbs
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
