1、从官网上下载Firebird数据库安装
或者直接下载
Firebird-2.5.rar:http://download.csdn.net/detail/shuyeshangdemayi/8637225
flamerobin-0.9.2.rar:http://download.csdn.net/detail/shuyeshangdemayi/8637235
2、将Firebird数据库安装文件夹中的fbclient.dll、fbrmclib.dll、fbrmclib.dll、fbrmclib.dll、fbrmclib.dll、fbrmclib.dll
这几个DLL复制到C:\WINDOWS\system32文件夹中,这里我们要注意,在C:\WINDOWS\system32不能有以上
DLL中的不同版本,就是说要保证上面所有的DLL文件版本要一至,
3、从网上下载Jaybird,将其解压到指定文件夹后,在工程中引用里面的文件
4、代码
1 String Driver = "org.firebirdsql.jdbc.FBDriver"; 2 String URL ="jdbc:firebirdsql:localhost/3050:D:\\StwoDatabase\\DBSTWO.FDB"; //embedded 3 String Username = "SYSDBA"; 4 String Password = "masterkey"; 5 Connection con; 6 Statement sql; 7 ResultSet rs; 8 try 9 { 10 Class.forName(Driver); 11 } 12 catch (ClassNotFoundException e) 13 { 14 JOptionPane.showMessageDialog(null, e.toString(), "信息", JOptionPane.INFORMATION_MESSAGE); 15 } 16 try 17 { 18 con = DriverManager.getConnection(URL,Username,Password); 19 sql = con.createStatement(); 20 rs = sql.executeQuery("SELECT * FROM TableDepartment"); 24 rs.close(); 25 } 26 catch(SQLException e1) 27 { 28 JOptionPane.showMessageDialog(null, e1.toString(), "信息", JOptionPane.INFORMATION_MESSAGE); 29 }
jar驱动包:http://download.csdn.net/detail/shuyeshangdemayi/8637173
dll链接库文件:http://download.csdn.net/detail/shuyeshangdemayi/8637203