?1?import?java.io.BufferedReader;
?2?import?java.io.InputStreamReader;
?3?import?java.io.PrintWriter;
?4?import?java.sql.Connection;
?5?import?java.sql.DriverManager;
?6?import?java.sql.Statement;
?7?import?org.apache.derby.drda.NetworkServerControl;
?8?
?9?public?class?TestDerbyServer?{
10?????public?static?void?main(String[]?args)?{
11?????????try?{
12?????????????NetworkServerControl?dbserver?=?new?NetworkServerControl();//啟動服務器
13?????????????
14?????????????PrintWriter?pw?=?new?PrintWriter(System.out);//獲取服務器輸出
15?????????????dbserver.start(pw);
16?????????????
17?????????????Connection?conn?=?DriverManager.getConnection("jdbc:derby:TESTDB;create=true");//本地連接數據庫
18?????????????
19?????????????Statement?st?=?conn.createStatement();
20?????????????st.execute("create?table?USER_INFO?(ID?INT?NOT?NULL,NAME?VARCHAR(10)?NOT?NULL)");//建表
21?????????????st.executeUpdate("insert?into?USER_INFO(ID,NAME)?values?(1,'hermit')");//插入數據
22?????????????st.executeUpdate("insert?into?USER_INFO(ID,NAME)?values?(2,'test')");//插入數據
23?????????????
24?????????????/*
25??????????????*等待用戶輸入，讓程序繼續運行，不然程序會運行結束，客戶端就連不上了?
26??????????????*/
27?????????????BufferedReader?in?=?new?BufferedReader(new?InputStreamReader(System.in));
28?????????????System.out.println("Press?[Enter]?to?stop?Server");
29?????????????in.readLine();
30?
31?????????}?catch?(Exception?ex)?{
32?????????????ex.printStackTrace();
33?????????}
34?????}
35?}
運行輸出：
服務器準備在端口 1527 上接受連接。
Press [Enter] to stop Server
再強調一下，in.readLine();很重要，不然，程序運行完畢，服務器也就停了。。。。。。。。
posted on 2007-01-16 17:49
交口稱贊 閱讀(1177)
評論(0) 編輯 收藏 所屬分類:
Java6