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 }
运行输出:
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();很重要,不然,程序运行完毕,服务器也就停了。。。。。。。。