通过JDBC操作JAVADB 数据库

1、创建Java工程javaDB：首先要把Derby驱动包加进来,该文件可以在C:\Program Files\Sun\JavaDB\lib找到，就是derby.jar

2、创建包com.test在包下面创建JavaDBTes测试类，并添加主函数

3、创建数据库：第一步加载驱动：Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();第二部滤鲇魍童设置账号密码：Properties props = new Properties();props.put("user", "admin");props.put("password", "123");第三部 连接创建数据库：Connectionconn = DriverManager.getConnection("jdbc:derby:liu;create=true",props);不提交事务conn.setAutoCommit(false);

4、创建表：Statement s = conn.createStatement();//获取实例s.execute("create table user_info (user_id int,user_name varchar(50))");conn.commit();//提交事务

5、往表添加数据：Statement s = conn.createStatement();boolean mark = s.execute("insert into user_info values(1, '张三')");conn.commit();

6、查询数据：ResultSet rs = s.executeQuery("SELECT user_i颊俄岿髭d,user_name FROM user_info");//遍历结果集while (rs.next()) { System.out.println(rs.getInt(1));System.out.println(rs.getString(2));}

7、修改数据：Statement 衡痕贤伎s = conn.createStatement();boolean mark = s.execute(&鳎溻趄酃quot;update user_infosetuser_name= '张三' where user_id=1");conn.commit();

8、删除数据：Statement s = conn.createStatement();boolean mark = s.execute("delete from user_info where user_id=1");conn.commit();