这个也是错误的 import java.sql.*;
public class DbTest {
Connection con;
Statement sta;
ResultSet rs;
String driver;
String url;
String user;
String pwd;
public DbTest()
{
driver = "com.microsoft.JDBC.SQLServer.SQLServerDriver";
url = "JDBC:microsoft:SQLServer://localhost:1433;DatabaseName =OA";
user = "sa";
pwd = "123";
init();
}
public void init()
{
try{
Class.forName(driver);
System.out.println("driver 已经创建");
con = DriverManager.getConnection(url,user,pwd);
System.out.println("conection 已经创建");
sta = con.createStatement();
rs = sta.executeQuery
("select * from room");
while(rs.next())
System.out.println(rs.getInt("roomNum"));
}catch(Exception e)
{
e.printStackTrace();
}
}
public static void main
(String args [])
{
new DbTest();
}
}为什么啊
public class DbTest {
Connection con;
Statement sta;
ResultSet rs;
String driver;
String url;
String user;
String pwd;
public DbTest()
{
driver = "com.microsoft.JDBC.SQLServer.SQLServerDriver";
url = "JDBC:microsoft:SQLServer://localhost:1433;DatabaseName =OA";
user = "sa";
pwd = "123";
init();
}
public void init()
{
try{
Class.forName(driver);
System.out.println("driver 已经创建");
con = DriverManager.getConnection(url,user,pwd);
System.out.println("conection 已经创建");
sta = con.createStatement();
rs = sta.executeQuery
("select * from room");
while(rs.next())
System.out.println(rs.getInt("roomNum"));
}catch(Exception e)
{
e.printStackTrace();
}
}
public static void main
(String args [])
{
new DbTest();
}
}为什么啊
但是public class DbTest 报告了这个错误,是在执行这个Class.forName(driver);语句时产生错误的。
这两个文件,我是在同一个目录下编译执行的,如果我没有记jar包,应该class Test也报告相应的错误才对啊,还没有执行到DriverManager.getConnection(url,user,pwd);所以和user , password是没有关系的。
.;c:,;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\j2sdk1.4.2\bin;C:\j2sdk1.4.2\lib_data;C:\j2sdk1.4.2\lib_data\msbase.jar;C:\j2sdk1.4.2\lib_data\msutil.jar;C:\j2sdk1.4.2\lib_data\mssqlserver.jar;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\lib\tools.jar;还有什么地方没有设置正确吗?
.;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\j2sdk1.4.2\bin;C:\j2sdk1.4.2\lib_data;C:\j2sdk1.4.2\lib_data\msbase.jar;C:\j2sdk1.4.2\lib_data\msutil.jar;C:\j2sdk1.4.2\lib_data\mssqlserver.jar;c:\j2sdk1.4.2\lib\dt.jar;c:\j2sdk1.4.2\lib\tools.jar;实在不行看一下路径对不对