我下载了freetds——jdbc的驱动,可是怎么用
我将驱动加入了环境变量
d:\jdk1.4\lib\tools.jar;d:\jdk1.4\lib\db.jar;d:\mysql.jdbc\mysql_comp.jar;d:\jdk1.4\lib\sql\freetds_jdbc.jar;
执行该JSP页面,老是空白一片,程序如下:
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
adfasdf<br>
<%
try{
Class.forName("com.internetcds.jdbc.tds.Driver");
}
catch(Exception e)
{
out.println("no add tds:"+e.getMessage());
}
try
{
Connection conn=DriverManager.getConnection("jdbc:freedts:192.168.0.86:1433/test","sa","12345");
java.sql.Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from bbb");
while (rs.next())
out.println(rs.getString("ccc")+"<br>");
}
catch(Exception e)
{
System.out.println("error:"+e.getMessage());
}
%>