db-derby-10.4.1.3-bin.zip可以去http://db.apache.org/derby/ 下载,具体下载页面:http://db.apache.org/derby/releases/release-10.4.1.3.cgi1、运行ij,connect 'jdbc:derby:test;create=true';
2、退出ij,运行:startnetworkserver.bat
3、可以自己删改下面的代码,创建表,插入数据,查询。/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package db;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;public class NewClass { public static void main(String[] args) {
try {
Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();//加载驱动
Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/test");//连接数据库
Statement st = conn.createStatement();
// PreparedStatement ps=conn.prepareStatement("insert into USER_INFO(ID,NAME) values ( ?,'hermit')");
// st.execute("drop table USER_INFO");
// st.execute("create table USER_INFO (ID INT NOT NULL,NAME VARCHAR(10) NOT NULL)");//建表
// for(int i=0;i<1000;i++){
// ps.setString(1, String.valueOf(i));
// ps.execute();
//// st.executeUpdate("insert into USER_INFO(ID,NAME) values ("+i+",'hermit')");
// }
System.out.println("finished");
// st.executeUpdate("insert into USER_INFO(ID,NAME) values (1,'hermit')");//插入数据
// st.executeUpdate("insert into USER_INFO(ID,NAME) values (2,'test')");//插入数据
ResultSet rs = st.executeQuery("select * from (select row_number() over() as rw,user_info.* from USER_INFO) as tmp where rw>=900 and rw<910");//读取刚插入的数据
while (rs.next()) {
int id = rs.getInt(1);
String name = rs.getString(2);
System.out.println("ID=" + id + " and " + "NAME=" + name); }
} catch (Exception e) {
e.printStackTrace();
}
}
}
2、退出ij,运行:startnetworkserver.bat
3、可以自己删改下面的代码,创建表,插入数据,查询。/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package db;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;public class NewClass { public static void main(String[] args) {
try {
Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();//加载驱动
Connection conn = DriverManager.getConnection("jdbc:derby://localhost:1527/test");//连接数据库
Statement st = conn.createStatement();
// PreparedStatement ps=conn.prepareStatement("insert into USER_INFO(ID,NAME) values ( ?,'hermit')");
// st.execute("drop table USER_INFO");
// st.execute("create table USER_INFO (ID INT NOT NULL,NAME VARCHAR(10) NOT NULL)");//建表
// for(int i=0;i<1000;i++){
// ps.setString(1, String.valueOf(i));
// ps.execute();
//// st.executeUpdate("insert into USER_INFO(ID,NAME) values ("+i+",'hermit')");
// }
System.out.println("finished");
// st.executeUpdate("insert into USER_INFO(ID,NAME) values (1,'hermit')");//插入数据
// st.executeUpdate("insert into USER_INFO(ID,NAME) values (2,'test')");//插入数据
ResultSet rs = st.executeQuery("select * from (select row_number() over() as rw,user_info.* from USER_INFO) as tmp where rw>=900 and rw<910");//读取刚插入的数据
while (rs.next()) {
int id = rs.getInt(1);
String name = rs.getString(2);
System.out.println("ID=" + id + " and " + "NAME=" + name); }
} catch (Exception e) {
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货