h2内存数据库做嵌入式数据库很方便,不像DB2,MYSQL等需要安装客户端,使用H2可以很方便的移植一些源程序,而不需要因为数据库的原因而烦恼。
下面是h2简单代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class H2Select {
public static void main(String[] args) throws ClassNotFoundException, SQLException{
Class.forName("org.h2.Driver");
Connection conn=DriverManager.getConnection("jdbc:h2:~/test","sa","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from h2.test");
while(rs.next()){
System.out.println(rs.getString("id")+","+rs.getString("name"));
}
rs.close();
stmt.close();
conn.close();
}
}
DEMO下载