import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Test {
	public static void main(String[] args) {
		try {
			//  Load driver , connect sqlite of jdbc
			Class.forName("org.sqlite.JDBC");
			//  Connect to the database how2j.db, You don't have to create it manually ...
			Connection connection = DriverManager.getConnection("jdbc:sqlite:how2j.db");
			//  Create connection object , yes Java An important interface for operating database 
			Statement statement = connection.createStatement();
			//  Determine whether there is a table tables Existence of . If yes, delete 
			statement.executeUpdate("drop table if exists hero");
			//  Create table 
			statement.executeUpdate("create table hero(id int,name varchar(20),hp int)");
			// Insert data 
			statement.executeUpdate("insert into hero values(1,'Gareen','452')");
			//  Search the database , Put the search into the dataset ResultSet In 
			ResultSet rSet = statement.executeQuery("select * from hero");
			while (rSet.next()) { //  Traverse this data set 
				System.out.println("id：" + rSet.getInt(1));
				System.out.println(" full name ：" + rSet.getString(2));
				System.out.println(" Blood volume ：" + rSet.getString(3));
			}
			rSet.close();//  Close dataset 
			connection.close();//  Close database connection 
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}