java中如何使用H2db呢?

下文笔者讲述java代码使用H2db的方法及示例分享
学习完本篇之后，你将掌握Java代码操作H2db的方法及示例

学习H2db的实现思路
 
1.maven导入：
 <dependency>
	<groupId>com.h2database</groupId>
	<artifactId>h2</artifactId>
	<version>1.4.199</version>
 </dependency>

2.使用jdbc连接H2数据库

例:java代码操作H2db数据库

  
package testH2db;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestH2db {
 
	public static void main(String[] args) {
		try {
			Connection conn = DriverManager.getConnection("jdbc:h2:./mydb");//当前项目下
//			Connection conn = DriverManager.getConnection("jdbc:h2:~/mydb");//“系统盘:\Users\用户名”文件夹下
			Statement state = conn.createStatement();
			state.executeUpdate("create table games (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(100))");
			state.executeUpdate("insert into games (name) values ('Devil May Cry5'),('Crysis3'),('Far cry4')");
			state.close();
			
			PreparedStatement pstate = conn.prepareStatement("select * from games where name like ?");
			pstate.setString(1, "%Cry%");
			ResultSet resultSet = pstate.executeQuery();
			while(resultSet.next()) {
				System.out.println("id:"+resultSet.getInt("id")+" name:"+resultSet.getString(2));
			}
			pstate.close();
			
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
 
}

 

package testH2db;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
  
public class TestH2dbMem {
  
	public static void main(String[] args) {
		try {
//			Connection conn = DriverManager.getConnection("jdbc:h2:mem:");//内存模式
			Connection conn = DriverManager.getConnection("jdbc:h2:mem:db1");//指定内存数据库
			Statement state = conn.createStatement();
			state.executeUpdate("create table animals (id INT,name VARCHAR(100))");
			state.executeUpdate("insert into animals (id,name) values (1,'dog'),(2,'cat'),(3,'rabbit'),(4,'fish'),(5,'duck'),(6,'tiger')");
			state.close();
			
			PreparedStatement pstate = conn.prepareStatement("select name from animals where id between ? and ?");
			pstate.setInt(1, 2);
			pstate.setInt(2, 4);
			ResultSet rset = pstate.executeQuery();
			while(rset.next()) {
				System.out.println(rset.getString("name"));
			}
			pstate.close();
			
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}