JDBC(9)

使用PreparedStatement实现查询

package com.hqy;

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

public class JDBCDemo08 {
    /*
        使用PreparedStatement实现查询
     */
    public static void main(String[] args) throws Exception{
        Class.forName("com.mysql.jdbc.Driver");
        java.lang.String url = "jdbc:mysql://localhost:3306/myhqy2?characterEncoding=utf8&useSSL=false";
        Connection conn = DriverManager.getConnection(url, "root", "123456");

        //查询全部
        //PreparedStatement pstate = conn.prepareStatement("select * from user");

        //条件查询
        PreparedStatement pstate = conn.prepareStatement("select * from user where username=?and password=?");
        pstate.setString(1, "zhangsan");
        pstate.setString(2, "888");
        //执行查询语句
        ResultSet rs = pstate.executeQuery();
        //遍历查询完返回的结果集
        while(rs.next()){
            Object id = rs.getObject("id");  //当不确定数据类型时可以直接写object
            String username = rs.getString("username");
            String password= rs.getString("password");
            String email= rs.getString("email");
            String phone= rs.getString("phone");
            System.out.println(id+" "+username+" "+password+" "+email+" "+phone );
        }
        //关闭
        rs.close();
        pstate.close();
        conn.close();
    }
}