package ch06;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Student {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//加载驱动程序
Class.forName("org.sqlite.JDBC");
//创建链接
String url="jdbc:sqlite:E:/htz/htz.db";
Connection conn=DriverManager.getConnection(url);
//创建命令对象
Statement stmt=conn.createStatement();
String sql="select * from student";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.print(rs.getString("id")+" ");
System.out.print(rs.getString("name")+" ");
System.out.println(rs.getInt("age"));
}
}
}
