查询姓名为张百万的一条记录
public class TestJDBC02 { public static void main(String[] args) throws SQLException { //1.获取连接对象 Connection connection = JDBCUtils.getConnection(); //2.获取Statement对象 Statement statement = connection.createStatement(); String sql = "SELECT * FROM jdbc_user WHERE username = '张百万';"; ResultSet resultSet = statement.executeQuery(sql); //3.处理结果集 while(resultSet.next()){ //通过列名 获取字段信息 int id = resultSet.getInt("id"); String username = resultSet.getString("username"); String password = resultSet.getString("password"); String birthday = resultSet.getString("birthday"); System.out.println(id+" "+username+" " + password +" " + birthday); } //4.释放资源 JDBCUtils.close(connection,statement,resultSet); } }