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(); // 加载驱动
10 Connection conn = DriverManager.getConnection( " dbc:derby:TESTDB;create=true " ); // 连接数据库
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') " ); // 插入数据
14 st.executeUpdate( " insert into USER_INFO(ID,NAME) values (2,'test') " ); // 插入数据
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 } catch (Exception e){
23 e.printStackTrace();
24 }
25 }
26 }
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(); // 加载驱动
10 Connection conn = DriverManager.getConnection( " dbc:derby:TESTDB;create=true " ); // 连接数据库
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') " ); // 插入数据
14 st.executeUpdate( " insert into USER_INFO(ID,NAME) values (2,'test') " ); // 插入数据
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 } catch (Exception e){
23 e.printStackTrace();
24 }
25 }
26 }
运行以后输出
ID=1
NAME=hermit
ID=2
NAME=test
在项目下会生成一个文件夹TESTDB
只要大家有一点点的JDBC的底子,以上例子还是很容易看懂的