java - 来自java的数据库连接

Question

我在 phpmyadmin 的数据库服务器（mysql）中有一个名为“user_db”的表。在表格内，我有字段用户名、密码、电话和电子邮件。我想提取某个电子邮件的密码。例如，我有电子邮件“[e-mail]”，我想打印为该用户注册的密码。我已经设法连接到数据库，但我没有设法获得电子邮件的密码......

public static void getTableEntry(String email) {
    try {
        WriteToMySql.connection();
        Connection conn = DriverManager.getConnection(WriteToMySql.host, WriteToMySql.username, WriteToMySql.passwordServer);

        PreparedStatement preparedStatement = (PreparedStatement) conn.prepareStatement("SELECT * FROM `user_db` WHERE `password`=? AND `email`=?");


//        preparedStatement.setString(1, password);

        preparedStatement.setString(2, email);
        ResultSet rs = preparedStatement.executeQuery();
        System.out.println(preparedStatement.toString());
        while (rs.next()) {
            String pass = rs.getString("password");
            System.out.println("Pass is: " + pass);

        }

标签： javasqldatabasepasswords