初学JDBC第一弹连接与查找

import com.mysql.jdbc.Driver;

import java.sql.*;

public class Demo01 {
    public static void main(String[] args) throws SQLException {
        DriverManager.registerDriver(new Driver());
        String url = "jdbc:mysql://localhost:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8";
        String username = "root";
        String pass = "root";
        Connection connection = DriverManager.getConnection(url,username,pass);
        System.out.println(connection);

        String sql  = "select * from tmp where username = ?";//查找数据
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1,"zhangsan");//前边的数字表示第几个问号
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()){
            System.out.print(resultSet.getString("username")+"->");
            System.out.println(resultSet.getInt("age"));
        }

        resultSet.close();
        preparedStatement.close();
        connection.close();
    }
}