java 内嵌mysql_JAVA内嵌数据库H2的使用入门

packagecom.my.enter;importjava.sql.Connection;importjava.sql.DatabaseMetaData;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;public classCommonDao {public static void crateTable() throwsSQLException {

Connection conn= null;

Statement stmt= null;try{

conn=ConnectionPool.getInstance().getConnection();

DatabaseMetaData meta=conn.getMetaData();

ResultSet rsTables= meta.getTables(null, null, "WEATHERINFO",new String[] { "TABLE"});if (!rsTables.next()) {

stmt=conn.createStatement();

stmt.execute("CREATE TABLE WEATHERINFO(WEATHERSTR VARCHAR(1024),LASTMODIFYTIME VARCHAR(1024),STATUS VARCHAR(1024),PRIMARY KEY(WEATHERSTR,LASTMODIFYTIME))");

}

rsTables.close();

}finally{

releaseConnection(conn, stmt,null);

}

}public static void addInfo(String str, longlastModifyTime,

String status)throwsSQLException {

Connection conn= null;

PreparedStatement stmt= null;try{

conn=ConnectionPool.getInstance().getConnection();

stmt=conn

.prepareStatement("INSERT INTO WEATHERINFO VALUES(?,?,?)");

stmt.setString(1, str);

stmt.setString(2, String.valueOf(lastModifyTime));

stmt.setString(3, status);

stmt.execute();

}finally{

releaseConnection(conn, stmt,null);

}

}public static boolean isInfoExits(String filePath, longlastModifyTime)throwsSQLException {

Connection conn= null;

PreparedStatement stmt= null;

ResultSet rs= null;try{

conn=ConnectionPool.getInstance().getConnection();

stmt=conn

.prepareStatement("SELECT WEATHERSTR FROM WEATHERINFO WHERE STATUS=? AND LASTMODIFYTIME=?");

stmt.setString(1, filePath);

stmt.setString(2, String.valueOf(lastModifyTime));

rs=stmt.executeQuery();returnrs.next();

}finally{

releaseConnection(conn, stmt, rs);

}

}private static voidreleaseConnection(Connection conn, Statement stmt,

ResultSet rs)throwsSQLException {if (rs != null) {

rs.close();

}if (stmt != null) {

stmt.close();

}if (conn != null) {

conn.close();

}

}

}