以下代码总是出现java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
的错误,因为用JDBC-ODBC桥接的方法可以连接数据库,但是用这种方法就老出错,网上说要是要配置SQL2000
补丁下的JAR文件,一直没配成功,请牛人指点!!!!!package DB;
import java.io.*;
import java.sql.*;
import java.sql.DriverManager;
class DBCon
{
String url;
String name;
String pwd;
//String driver;
Connection con;
private DBCon()
{
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDB";
name="sa";
pwd="777";
con=null;
}
public void display()
{
try
{
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driver);
con=DriverManager.getConnection(url,name,pwd);
System.out.println("数据库链接成功.");
Statement stmt=con.createStatement();
int id,age;
String text;
ResultSet rs;
String strSQL="SELECT * FROM Person";
rs=stmt.executeQuery(strSQL);
if(rs.next())
{
do
{
id=rs.getInt(1);
System.out.print("Id:"+id);
text=rs.getString(2);
System.out.print("Name:"+text);
text=rs.getString(3);
System.out.print("Sex:"+text);
age=rs.getInt(4);
System.out.print("Age:"+age);
text=rs.getString(5);
System.out.print("Address:"+text);
text=rs.getString(6);
System.out.print("Phone:"+text);
}while(rs.next());
}
}
catch(ClassNotFoundException ex)
{
System.out.println(ex);
}
catch(SQLException e)
{
System.out.println(e);
}
finally
{
if(con!=null)
{
try
{
con.close();
}
catch(SQLException ex)
{
ex.printStackTrace();
}
}
}
}
public static void main(String args[])
{
DBCon c=new DBCon();
c.display();
}
}
的错误,因为用JDBC-ODBC桥接的方法可以连接数据库,但是用这种方法就老出错,网上说要是要配置SQL2000
补丁下的JAR文件,一直没配成功,请牛人指点!!!!!package DB;
import java.io.*;
import java.sql.*;
import java.sql.DriverManager;
class DBCon
{
String url;
String name;
String pwd;
//String driver;
Connection con;
private DBCon()
{
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDB";
name="sa";
pwd="777";
con=null;
}
public void display()
{
try
{
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driver);
con=DriverManager.getConnection(url,name,pwd);
System.out.println("数据库链接成功.");
Statement stmt=con.createStatement();
int id,age;
String text;
ResultSet rs;
String strSQL="SELECT * FROM Person";
rs=stmt.executeQuery(strSQL);
if(rs.next())
{
do
{
id=rs.getInt(1);
System.out.print("Id:"+id);
text=rs.getString(2);
System.out.print("Name:"+text);
text=rs.getString(3);
System.out.print("Sex:"+text);
age=rs.getInt(4);
System.out.print("Age:"+age);
text=rs.getString(5);
System.out.print("Address:"+text);
text=rs.getString(6);
System.out.print("Phone:"+text);
}while(rs.next());
}
}
catch(ClassNotFoundException ex)
{
System.out.println(ex);
}
catch(SQLException e)
{
System.out.println(e);
}
finally
{
if(con!=null)
{
try
{
con.close();
}
catch(SQLException ex)
{
ex.printStackTrace();
}
}
}
}
public static void main(String args[])
{
DBCon c=new DBCon();
c.display();
}
}
但是请哪位大虾能够说明CLASSPATH怎么配??
我看网上说补丁默认会打在C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
这个地方可是我的补丁不再这里?难道是我的补丁打错了?用CLASSPATH下一直没有成功。