MySQL的JDBC操作 登录

package cn.itcast.jdbc;

import java.sql.*;
import java.util.Scanner;

public class JdbcDemo05 {
public static void main(String[] args) throws SQLException {
//用户输入用户名和密码，判断是否能够登录
Scanner scanner = new Scanner(System.in);
System.out.println(“请输入用户名：”);
String username = scanner.nextLine();
System.out.println(“请输入密码：”);
String password = scanner.nextLine();

    //1.注册驱动
    //2.获取连接
    Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb1_jdbc", "root", "123456");
    //3.执行SQL

// Statement statement = connection.createStatement();

    String sql = "select*from user where username = ? and password = ?";
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setObject(1,username);
    preparedStatement.setObject(2,password);

    ResultSet resultSet = preparedStatement.executeQuery();


    if (resultSet.next()) {
        System.out.println("登陆成功");
    } else {
        System.out.println("登陆失败");
    }


    //获取表的列数
    ResultSetMetaData metaData = resultSet.getMetaData();
    int columnCount = metaData.getColumnCount(); //列的数量
    //4.处理结果集
    while (resultSet.next()) {  //获取每一行数据 每循环一次就是一行
        //获取每一列数据
        for (int i = 1; i <= columnCount; i++) {
            System.out.print(resultSet.getObject(i) + "\t");
        }
        System.out.println();

    }
    //5.关闭连接
    resultSet.close();
    preparedStatement.close();
    connection.close();
}

}