我用 javac 和 JCreator 编译都没有问题,可是在 Eclipse 中用相同的代码却总报错:connect db error:com.microsoft.jdbc.sqlserver.SQLServerDriver连接数据库的源代码如下:package util;import java.sql.*;public class DataBase
{
public Connection conn;
public Statement stmt;
public ResultSet rs=null;
public String sqlStr=""; public DataBase()
{
this.connect();
}
public boolean connect()
{
String classForname = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String servanddb = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookstore";
String strUserName = "sa";
String strPassword = "";
try
{
Class.forName(classForname).newInstance();
conn = DriverManager.getConnection(servanddb,strUserName,strPassword);
}
catch(Exception ee)
{
System.out.println("connect db error:"+ee.getMessage());
return false;
}
return true;
}
public static void main(String[] args)
{
try{
DataBase db = new DataBase();
db.connect();
}catch(Exception e){
e.printStackTrace();
}
}
}
{
public Connection conn;
public Statement stmt;
public ResultSet rs=null;
public String sqlStr=""; public DataBase()
{
this.connect();
}
public boolean connect()
{
String classForname = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String servanddb = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookstore";
String strUserName = "sa";
String strPassword = "";
try
{
Class.forName(classForname).newInstance();
conn = DriverManager.getConnection(servanddb,strUserName,strPassword);
}
catch(Exception ee)
{
System.out.println("connect db error:"+ee.getMessage());
return false;
}
return true;
}
public static void main(String[] args)
{
try{
DataBase db = new DataBase();
db.connect();
}catch(Exception e){
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货