SQLite3之补充

package pratice;


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


public class Link {


public static void main(String[] args) {
// TODO Auto-generated method stub
lian();
}
public static void lian(){
String str="select * from man where cid>9999";

try {
Class.forName("org.sqlite.JDBC");
Connection conn=DriverManager.getConnection("jdbc:sqlite:D:\\android\\db\\people.db");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(str);
while(rs.next()){
System.out.println("名字:"+rs.getString(3)+",年龄："+rs.getString(2)+",性别："+rs.getString(4));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
}