-
大小: 1.12MB文件類型: .zip金幣: 2下載: 0 次發(fā)布日期: 2023-10-30
- 語(yǔ)言: Java
- 標(biāo)簽: firebird??jaybird??jaybird-full??jaybird-pool??
資源簡(jiǎn)介
java讀取firebird數(shù)據(jù)庫(kù)例子
jaybird-2.1.6.jar
jaybird-full-2.1.6.jar
jaybird-pool-2.1.6.jar

代碼片段和文件信息
package?com.lxkj.bass.query.getDmsData.utils;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?javax.swing.JOptionPane;
public?class?testFdb?{
public?static?void?main(String[]?arg)?{
String?Driver?=?“org.firebirdsql.jdbc.FBDriver“;
String?URL?=?“jdbc:firebirdsql:localhost/3050:E:\\20110509_09\\20110509_09.FDB“;
String?Username?=?“SYSDBA“;
String?Password?=?“masterkey“;
Connection?con;
Statement?sql;
ResultSet?rs;
try?{
Class.forName(Driver);
}?catch?(ClassNotFoundException?e)?{
JOptionPane.showMessageDialog(null?e.toString()?“信息“
JOptionPane.INFORMATION_MESSAGE);
}
try?{
con?=?DriverManager.getConnection(URL?Username?Password);
sql?=?con.createStatement();
rs?=?sql.executeQuery(“SELECT?count(*)?totalCount?FROM?dt_sj?“);
while(rs.next())?
{
System.out.println(“=================“+rs.getInt(“totalCount“));
}
rs.close();
}?catch?(SQLException?e1)?{
JOptionPane.showMessageDialog(null?e1.toString()?“信息“
JOptionPane.INFORMATION_MESSAGE);
}
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件??????553937??2008-07-19?18:53??fdb\jaybird-2.1.6.jar
?????文件??????654928??2008-07-19?18:53??fdb\jaybird-full-2.1.6.jar
?????文件???????79355??2008-07-19?18:53??fdb\jaybird-pool-2.1.6.jar
?????文件????????1183??2012-11-10?15:08??fdb\testFdb.java
?????目錄???????????0??2013-02-17?09:56??fdb\
評(píng)論
共有 條評(píng)論