h2database源码浅析(一)

最近想好好了解一下数据库的原理，下载了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 = stmt.executeQuery("SELECT * FROM TEST where ID>120 and NAME like 'Hello%'");
		while (rs.next())
		{
			System.out.println(rs.getInt("ID") + "," + rs.getString("NAME"));
		}
		conn.close();
	}

?

?