最近想好好了解一下数据库的原理,下载了h2database的源码,准备好好看看。此过程的一些想法,暂且记下来,权当做读码笔记吧!
为了调试准备的测试用例:
@Test
public void testExternalDb() throws Exception
{
Class.forName("org.h2.Driver");
Connection conn = DriverManager.getConnection("jdbc:h2:./testdb", "sa", "");
// add application code here
Statement stmt = conn.createStatement();
stmt.executeUpdate("DROP TABLE TEST IF EXISTS");
stmt.executeUpdate("CREATE TABLE TEST(ID INT PRIMARY KEY,NAME VARCHAR(255));");
stmt.executeUpdate("INSERT INTO TEST VALUES(100, 'Damn,World');");
stmt.executeUpdate("INSERT INTO TEST VALUES(200, 'Hello,H2');");
stmt.executeUpdate("INSERT INTO TEST VALUES(150, 'Hello,World');");
ResultSet rs =