你可以用以下方法试试,直接用JBDC驱动程序(我可以email可你,它支持2000,7.0,6.5)URL: jdbc:inetdae7:IP:Port
ClassString: com.inet.tds.TdsDriverClass.forName("com.inet.tds.TdsDriver"); 或 DriverManger.registerDriver(new com.inet.tds.TdsDriver())
Connection conn = DriverManager.getConnection(URL,UID,PWD)
注意:写法与JDBC驱动有关系,你可以找开那个压缩文件看下去也能猜出来,不知你的驱动从哪里弄的,希望我的回答能帮助你
ClassString: com.inet.tds.TdsDriverClass.forName("com.inet.tds.TdsDriver"); 或 DriverManger.registerDriver(new com.inet.tds.TdsDriver())
Connection conn = DriverManager.getConnection(URL,UID,PWD)
注意:写法与JDBC驱动有关系,你可以找开那个压缩文件看下去也能猜出来,不知你的驱动从哪里弄的,希望我的回答能帮助你
classpath=%classpath%;E:\SQLServerJDBC\lib\msbase.jar;E:\SQLServerJDBC\lib\mssqlserver.jar;E:\SQLServerJDBC\lib\msutil.jar。
2.程序连接:
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.io.IOException;public class JdbcSQL
{
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String ConnStr = "jdbc:microsoft:sqlserver://10.47.10.206:1433;DataBaseName=ddd";
Connection conn = null;
ResultSet rs = null; public JdbcSQL()
{
try
{
//注册并连接
java.sql.DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
//Class.forName(DBDriver);
//加载数据库驱动程序
System.out.println("Successful!!");
}
catch(Exception e) {
System.out.println("DBrmiconn (): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(ConnStr,"sa","mymm");
//与DBMS建立连接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
System.out.println("Connection is correct!");
}
catch(SQLException ex) {
System.out.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public boolean executeUpdate(String sql)
{
boolean b=false;
try
{
conn=DriverManager.getConnection(ConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
b=true;
}
catch(SQLException ex){
System.out.println("aq.executeUpdate:" + ex.getMessage());
}
return b;
}
}
下面的实例的注释部分包括Oracle使用两种不同驱动的语法表述,以及JDBC连接
MS Accsess 的表述,希望对你理解JDBCDriver的表述方法有所帮助!
bigbearcn(付光) 说的有道理,表述方式与JDBC驱动有关系,解压驱动文件,仔细阅读readme、help之类的文本文件,或反编译driver.class,研读代码,相信会有帮助……import java.sql.*;
public class TestSql2k
{
public static void main(String args[]){
try{
String user = "sa";
String password = "123";
String url = "jdbc:inetdae:127.0.0.1:1433?database=test01&charset=GB2312";
/**FOR ORACLE 817 use classes12.jar
new oracle.jdbc.driver.OracleDriver();//为什么这么写,解压classes12.jar,就会
//发现OracleDriver.class文件的保存路径正是..\oracle\jdbc\driver
String url="jdbc:oracle:thin:@"+serverName+":1521:ora8";
System.out.println(url);
Connection conn=DriverManager.getConnection(url,"scott","tiger");
getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl#user=scott,password=tiger");
*/
/**FOR ORACLE 817 use Gate.jar
new com.inet.ora.OraDriver();
String url="jdbc:inetora:127.0.0.1:1521:ora8";
System.out.println(url);
String user = "scott";
String passw = "tiger";
Connection conn=DriverManager.getConnection(url,user,passw);
//getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl#user=scott,password=tiger");
*/
/**FOR MCROSOFT ACCSESS
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:smdb";
Connection conn=DriverManager.getConnection(url);
*/
/**FOR SYBASE
*/
/**FOR DB2
*/
Class.forName("com.inet.tds.TdsDriver");
//new com.inet.tds.TdsDriver();//OK
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from sm_emp");
while(rs.next())
{
System.out.println("customer: "+rs.getString(2));
System.out.println("ssn: "+rs.getString(1));
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){e.printStackTrace();}
}
}