package dcxt.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(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url ="jdbc:odbc:dcxt"; dcxt是建立的odbc数据源名
conn=DriverManager.getConnection(url,"sa","111111");
stmt = conn.createStatement ();
}catch(Exception ee){
System.out.println("connect db error:"+ee.getMessage());
return false;
}
return true;
}
为什么连不上sqlsrver? 请教了 谢谢
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(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url ="jdbc:odbc:dcxt"; dcxt是建立的odbc数据源名
conn=DriverManager.getConnection(url,"sa","111111");
stmt = conn.createStatement ();
}catch(Exception ee){
System.out.println("connect db error:"+ee.getMessage());
return false;
}
return true;
}
为什么连不上sqlsrver? 请教了 谢谢
1)加载驱动:Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//java
Class.forName("sun.jdbc.odbc.jdbcodbcDriver");//jdbc-odbc数据源
2)建立连接:Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://IP:1433;DatabaseName=数据库名","用户名","密码");//java
Connection conn=DriverManager.getConnection("jdbc;odbc;数据源名称","用户名","密码");检查你的这句,有问题:String url ="jdbc:odbc:dcxt";
(1):连接的字符串有问题
(2):驱动问题
(3):防火墙问题
(4):sqlserver版本问题