運行這個客戶端之前要先運行
學習Java6(六) 嵌入式數據庫Derby(4)網絡版服務端中的服務端
?1?import?java.sql.Connection;
?2?import?java.sql.DriverManager;
?3?import?java.sql.ResultSet;
?4?import?java.sql.Statement;
?5?
?6?public?class?TestDerbyClient?{
?7?????public?static?void?main(String[]?args)?{
?8?????????String?URL?=?"jdbc:derby://127.0.0.1:1527/TESTDB;create=true";
?9?????????try?{
10????
11?????????????Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();//加載驅動
12?????????????Connection?conn?=?DriverManager.getConnection(URL);//建立連接
13?????????????
14?????????????Statement?st?=?conn.createStatement();?
15?????????????ResultSet?rs?=?st.executeQuery("select?*?from?USER_INFO");//讀取數據
16?????????????while(rs.next()){
17?????????????????int?id?=?rs.getInt(1);
18?????????????????String?name?=?rs.getString(2);
19?????????????????System.out.println("ID="+id);
20?????????????????System.out.println("NAME="+name);
21?????????????}
22?????????????
23?????????}?catch?(Exception?ex)?{
24?????????????ex.printStackTrace();
25?????????}
26?????}
27?}
運行輸出：
ID=1
NAME=hermit
ID=2
NAME=test
posted on 2007-01-16 17:52
交口稱贊 閱讀(1622)
評論(0) 編輯 收藏 所屬分類:
Java6