2012-06-07 00:18:16| 分类: H2 database | 标签: |举报 |字号大中小 订阅
public class Test {输出即为:
public static void main(String[] args) throws SQLException, ClassNotFoundException{
Class.forName("org.h2.Driver");
Connection conn = DriverManager.getConnection("jdbc:h2:file:D:/h2/h2test/test2","userA","pwdA");
Statement stm = conn.createStatement();
stm.executeUpdate("create table user(username varchar(20) primary key,password varchar(20));");
stm.executeUpdate("insert into user values('user2','password2')");
stm.executeUpdate("insert into user values('user3','password3')");
ResultSet rs = stm.executeQuery("select * from user");
while(rs.next()){
System.out.println(rs.getString("username")+","+rs.getString("password"));
}
System.out.println("end");
}
}
评论