?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();//啟動服務(wù)器
13?????????????
14?????????????PrintWriter?pw?=?new?PrintWriter(System.out);//獲取服務(wù)器輸出
15?????????????dbserver.start(pw);
16?????????????
17?????????????Connection?conn?=?DriverManager.getConnection("jdbc:derby:TESTDB;create=true");//本地連接數(shù)據(jù)庫
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')");//插入數(shù)據(jù)
22?????????????st.executeUpdate("insert?into?USER_INFO(ID,NAME)?values?(2,'test')");//插入數(shù)據(jù)
23?????????????
24?????????????/*
25??????????????*等待用戶輸入，讓程序繼續(xù)運(yùn)行，不然程序會運(yùn)行結(jié)束，客戶端就連不上了?
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?}
運(yùn)行輸出：
服務(wù)器準(zhǔn)備在端口 1527 上接受連接。
Press [Enter] to stop Server
再強(qiáng)調(diào)一下，in.readLine();很重要，不然，程序運(yùn)行完畢，服務(wù)器也就停了。。。。。。。。
posted on 2007-01-16 17:49
交口稱贊 閱讀(1177)
評論(0) 編輯 收藏 所屬分類:
Java6