?1?import?java.sql.Connection;
?2?import?java.sql.DriverManager;
?3?import?java.sql.ResultSet;
?4?import?java.sql.Statement;
?5?
?6?public?class?TestDerbyBaisc?{
?7?????public?static?void?main(String[]?args)?{
?8?????????try?{???????????
?9?????????????Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();//加載驅(qū)動(dòng)
10?????????????Connection?conn?=?DriverManager.getConnection("dbc:derby:TESTDB;create=true");//連接數(shù)據(jù)庫(kù)
11?????????????Statement?st?=?conn.createStatement();
12?????????????st.execute("create?table?USER_INFO?(ID?INT?NOT?NULL,NAME?VARCHAR(10)?NOT?NULL)");//建表
13?????????????st.executeUpdate("insert?into?USER_INFO(ID,NAME)?values?(1,'hermit')");//插入數(shù)據(jù)
14?????????????st.executeUpdate("insert?into?USER_INFO(ID,NAME)?values?(2,'test')");//插入數(shù)據(jù)
15?????????????ResultSet?rs?=?st.executeQuery("select?*?from?USER_INFO");//讀取剛插入的數(shù)據(jù)
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?????????}?catch(Exception?e){
23?????????????e.printStackTrace();
24?????????}
25?????}
26?}
運(yùn)行以后輸出
ID=1
NAME=hermit
ID=2
NAME=test
在項(xiàng)目下會(huì)生成一個(gè)文件夾TESTDB
只要大家有一點(diǎn)點(diǎn)的JDBC的底子，以上例子還是很容易看懂的
posted on 2007-01-16 17:20
交口稱贊 閱讀(1588)
評(píng)論(0) 編輯 收藏 所屬分類:
Java6