7.9w+
社区成员
- 主页
...全文
请发表友善的回复…
发表回复
babap1234 2004-09-28
String s_db_connection_string = "jdbc:microsoft:sqlserver://"+DBServer+":1433;DatabaseName="+DBNAME;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
conn = DriverManager.getConnection(s_db_connection_string, username, password);
这个是我安装完SQL SERVER的JDBC驱动后用的，希望能帮到你
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
conn = DriverManager.getConnection(s_db_connection_string, username, password);
这个是我安装完SQL SERVER的JDBC驱动后用的，希望能帮到你
xiangbo520 2004-09-27
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//注意DBQ的写法
String url="jdbc:odbc:driver={Microsoft Access Drive(*.mdb)};DBQ=E:\\db1.mdb";
Connection con=DriverManager.getConnection(url,"sa","");
其他的类推。
//注意DBQ的写法
String url="jdbc:odbc:driver={Microsoft Access Drive(*.mdb)};DBQ=E:\\db1.mdb";
Connection con=DriverManager.getConnection(url,"sa","");
其他的类推。
drugon 2004-09-27
没听过，是JDO吧，ADO是微软专有的，怎么会在java上呢，他们以前还是竟争对手呀！
RealDreamMan 2004-09-27
我去一家公司面试，就要我写出在JAVA中用ADO连接数据库的代码，我可当时傻了
Jockey 2004-09-27
哈哈，JSP用ADO？用JDBC吧。。
RealDreamMan 2004-09-27
要我下载SQL SERVER的JDBC驱动？
我可还不明白怎么做，有请再详细点tell me,Thanks!
我可还不明白怎么做，有请再详细点tell me,Thanks!
MagicJohn 2004-09-27
http://www.microsoft.com/downloads/details.aspx?FamilyID=EE91AD1A-1EE4-49E1-95EA-E3F0E39114A9&displaylang=en
RealDreamMan 2004-09-27
各位老大，帮下吧！！！！！！！！！！！！！！！！！！
RealDreamMan 2004-09-27
我看国下面这个帖子，但不知到要导入什么其它的才能，要不“Connection c = new Connection();”都不成。
实现方法如下：
{
Connection c = new Connection();
c.setConnectionString ("dsn=aDSNName;pwd=aName;pwd=aPWD;database=aDatabase");
c.setCommandTimeout (10);
c.setConnectionTimeout (10);
c.setCursorLocation (AdoEnums.adUseClientBatch);
c.open();
c.setDefaultDatabase ("aSpecificDatabase");
System.out.println ("Connection string = " + c.getConnectionString());
// Verify that the propertiea on the connection
// were set correctly. If not, return a fail condition.
if (c.getCommandTimeout() != 10)
return false;
if (c.getConnectionTimeout() != 10)
return false;
if (c.getCursorLocation() != AdoEnums.adUseClientBatch)
return false;
if (c.getMode() != AdoEnums.adModeUnknown)
return false;
// Create a new Recordset to contain the results
// of the SQL DML operation (select * ...).
Recordset rs= c.execute ("select * from authors");
rs.moveFirst();
rs.moveLast();
// Delete all rows from the authors table.
c.executeUpdate ("delete from authors");
// Close the Connection and Recordset.
rs.close();
c.close();
return true;
}
实现方法如下：
{
Connection c = new Connection();
c.setConnectionString ("dsn=aDSNName;pwd=aName;pwd=aPWD;database=aDatabase");
c.setCommandTimeout (10);
c.setConnectionTimeout (10);
c.setCursorLocation (AdoEnums.adUseClientBatch);
c.open();
c.setDefaultDatabase ("aSpecificDatabase");
System.out.println ("Connection string = " + c.getConnectionString());
// Verify that the propertiea on the connection
// were set correctly. If not, return a fail condition.
if (c.getCommandTimeout() != 10)
return false;
if (c.getConnectionTimeout() != 10)
return false;
if (c.getCursorLocation() != AdoEnums.adUseClientBatch)
return false;
if (c.getMode() != AdoEnums.adModeUnknown)
return false;
// Create a new Recordset to contain the results
// of the SQL DML operation (select * ...).
Recordset rs= c.execute ("select * from authors");
rs.moveFirst();
rs.moveLast();
// Delete all rows from the authors table.
c.executeUpdate ("delete from authors");
// Close the Connection and Recordset.
rs.close();
c.close();
return true;
}
cwa 2004-09-27
ADO是ASP 专用的吧