import java.sql.*;class test
{
public static void main(String args[])
{
try
{
String data = "jdbc:microsoft:sqlserver://192.168.0.99:1433;DatabaseName=northwind";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //"sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(data,"sa","");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from employees");
while(rs.next())
{
System.out.println (rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
}
catch (Exception ex)
{
System.out.println (ex.toString());
}
}
}
{
public static void main(String args[])
{
try
{
String data = "jdbc:microsoft:sqlserver://192.168.0.99:1433;DatabaseName=northwind";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //"sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(data,"sa","");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from employees");
while(rs.next())
{
System.out.println (rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
}
catch (Exception ex)
{
System.out.println (ex.toString());
}
}
}
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
{
public static void main(String args[])
{
try
{
String data = "jdbc:microsoft:sqlserver://192.168.0.99:1433;DatabaseName=northwind";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //"sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(data,"sa","");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery("select * from employees");
while(rs.next())
{
System.out.println (rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
}
catch (Exception ex)
{
System.out.println (ex.toString());
}
}
}
程序报错误啊:classnotfoundexecption:com.microsoft.jdbc.sqlserver.SQLServerDriver
有谁能告诉我是怎么回事啊?
怎么配置SQL SERVER2000的驱动啊, 就是把那三个文件(msbase.jar,msutil,jar,....)放到JDK HOME下的LIB下吗?
三颗星还问这个问题,搞没搞错啊
classpath=.;c:\jdk1.4.2\lib\msbase.jar;.....
这么写对吗?
还有那个错误是怎么回事啊?
楼上的楼上:要学会不懂就问啊