Z
zjhui
Unregistered / Unconfirmed
GUEST, unregistred user!
这是我连接SQL 2000的代码,驱动没错,我DatabaseName明明指定的是QQServer为什么我用getCatalog(),返回的都是master下面是我的代码,哪里错了,我实在是找不错,请快点帮忙
下,
import java.sql.*;
import java.io.*;
public class JDBCTest {
private String dbURL;
private String user;
private String password;
private static Statement sta = null;
public static void main(String[] args) {
try{
JDBCTest bridge = new JDBCTest();
bridge.setURL("jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName = QQServer"
;
bridge.setUser("sa"
bridge.setPassword("sa"
Connection con = bridge.getConnection();
System.out.println("~~QQQQQQQQQQQQQQQQQQQQQQqq"
System.out.println(con.getCatalog()+"~~~~~~~~~~~~~~~"
try{
sta = con.createStatement();
}catch(Exception e){
System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"
}
/** String sqlStr = "SELECT * FROM ";
ResultSet rs;
rs = sta.executeQuery(sqlStr);*/
// System.out.println(rs.getString(1));
con.close();
}catch(Exception e){
e.printStackTrace();
System.out.println("创建错误"
}
}
public Connection getConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"
return DriverManager.getConnection(dbURL,user,password);
}catch(Exception e){
e.printStackTrace();
System.out.println("加载驱动错误~~~~~~~~~~~~~~~~"
}
return null;
}
public void setURL(String dbURL){
this.dbURL = dbURL;
}
public void setUser(String user){
this.user = user;
}
public void setPassword(String password){
this.password = password;
}
}
代码:
import java.sql.*;
import java.io.*;
public class JDBCTest {
private String dbURL;
private String user;
private String password;
private static Statement sta = null;
public static void main(String[] args) {
try{
JDBCTest bridge = new JDBCTest();
bridge.setURL("jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName = QQServer"
;bridge.setUser("sa"
;bridge.setPassword("sa"
;Connection con = bridge.getConnection();
System.out.println("~~QQQQQQQQQQQQQQQQQQQQQQqq"
;System.out.println(con.getCatalog()+"~~~~~~~~~~~~~~~"
;try{
sta = con.createStatement();
}catch(Exception e){
System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"
;}
/** String sqlStr = "SELECT * FROM ";
ResultSet rs;
rs = sta.executeQuery(sqlStr);*/
// System.out.println(rs.getString(1));
con.close();
}catch(Exception e){
e.printStackTrace();
System.out.println("创建错误"
;}
}
public Connection getConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"
;return DriverManager.getConnection(dbURL,user,password);
}catch(Exception e){
e.printStackTrace();
System.out.println("加载驱动错误~~~~~~~~~~~~~~~~"
;}
return null;
}
public void setURL(String dbURL){
this.dbURL = dbURL;
}
public void setUser(String user){
this.user = user;
}
public void setPassword(String password){
this.password = password;
}
}