50,528
社区成员
发帖
与我相关
我的任务
分享
String[] serverArgs=new String[]{};
Server server = Server.createTcpServer(serverArgs).start();
System.out.println(server.getService().getName());
//
Class.forName("org.h2.Driver");
Connection conn = DriverManager.
getConnection("jdbc:h2:mem://sample;INIT=RUNSCRIPT FROM '/ofce-h2-schema.sql';", "sa", "");
PreparedStatement pstmt = conn.prepareStatement("select * from orders");
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
System.out.println(rs.getString("orderid"));
}
conn.close();
Class.forName("org.h2.Driver");
Connection conn = DriverManager.
getConnection("jdbc:h2:tcp://localhost/mem:test;", "sa", "");
// add application code here
PreparedStatement pstmt= conn.prepareStatement("select * from orders");
ResultSet rs = pstmt.executeQuery();
rs.next();
System.out.println(rs.getString("orderid"));
conn.close();