陳鍾誠的程式作品集 -- SQL 資料庫 (Java)
程式作品C 語言JavaC#JavaScript常用函數文字處理遊戲程式衛星定位系統程式資料結構網路程式自然語言人工智慧機率統計資訊安全等待完成訊息相關網站參考文獻最新修改簡體版English |
package ccc; import java.sql.*; public class SQL { Connection con = null; Statement stmt = null; String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; String dbHead = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; String dbTail = ";DriverID=22;READONLY=false}"; public static void main(String[] args) throws Exception { SQL sql = new SQL(); sql.openDB("SQL\\person"); String text = sql.sql2text("SELECT * FROM person"); System.out.println(text); sql.closeDB(); } void openDB(String dbName) throws Exception { Class.forName(driver); con = DriverManager.getConnection(dbHead+dbName+dbTail); stmt = con.createStatement(); } String sql2text(String sql) throws Exception { StringBuffer rzText = new StringBuffer(); ResultSet rs = stmt.executeQuery(sql); ResultSetMetaData md = rs.getMetaData(); int maxFields = md.getColumnCount(); String[] fieldNames = new String[maxFields]; for (int fi=1; fi<=maxFields; fi++) { String fName = md.getColumnLabel(fi); fieldNames[fi-1] = fName; rzText.append(fName); if (fi<maxFields) rzText.append(","); } rzText.append("\r\n"); while (rs.next()) { for (int fi=1; fi<=maxFields; fi++) { rzText.append(rs.getString(fi)); if (fi<maxFields) rzText.append(","); } rzText.append("\r\n"); } return rzText.toString(); } void closeDB() throws Exception { con.close(); } } |
page revision: 1, last edited: 04 Nov 2010 05:19
Post preview:
Close preview