与之前的步骤一样,先设置数据源,连接数据库,编写sql语句,预编译sql,执行sql语句
public class JDBCDemo3 {
public static void main(String[] args) throws SQLException {
DataSource dataSource = new MysqlDataSource();
((MysqlDataSource)dataSource).setURL("jdbc:mysql://127.0.0.1:3306/depth?characterEncodingutf8&useSSL=false");
((MysqlDataSource)dataSource).setUser("root");
((MysqlDataSource)dataSource).setPassword("5157997");
//建立连接
Connection connection = dataSource.getConnection();
//构造sql语句
String sql = "select * from Student";
//预编译
PreparedStatement statement = connection.prepareStatement(sql);
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery(sql);
这里的查询操作联系到resultSet这个类,调用的方法是executeQuery(查询操作)我们可以将其想象成一个表格,其光标指在第一行,每执行一此.next操作,光标就往下移一行
while(resultSet.next()){
//将resultSet想象成一个表格,其光标指在最上面,每执行一次next,光标往下移
String id = resultSet.getNString("s_id");
String name = resultSet.getNString("s_name");
String birth = resultSet.getNString("s_birth");
String gender = resultSet.getNString("s_sex");
System.out.println("id =" + id +", name="+name+", birth = "+birth+",gender ="+gender);
}