6_8日

package com.Day6_7;

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

public class Users {
    public static void main(String[] args) throws SQLException {
        Scanner sc = new Scanner(System.in);
        String username = sc.nextLine();
        String password = sc.nextLine();
        boolean flag = login2(username,password);
        if (flag){
            System.out.println("登陆成功!");
        }
        else{
            System.out.println("登陆失败!");
        }
    }
    public static boolean login2(String username,String password) throws SQLException {
        if (username == null || password == null){
            return false;
        }
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet res  = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/users?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC", "root", "123456");
            String sql = "select * from perpon where usernames=? and  passwords=?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1,username);
            pstmt.setString(2,password);
            res = pstmt.executeQuery();
            return res.next();
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }finally {
            conn.close();
            pstmt.close();
            res.close();
        }
        return false;
    }
}

事务

package com.Day6_7;

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

public class Users {
    public static void main(String[] args) throws SQLException {
        Scanner sc = new Scanner(System.in);
        String username = sc.nextLine();
        String password = sc.nextLine();
        boolean flag = login2(username,password);
        if (flag){
            System.out.println("登陆成功!");
        }
        else{
            System.out.println("登陆失败!");
        }
    }
    public static boolean login2(String username,String password) throws SQLException {
        if (username == null || password == null){
            return false;
        }
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet res  = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/users?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC", "root", "123456");
            String sql = "select * from perpon where usernames=? and  passwords=?";
            conn.setAutoCommit(false); //开启事务
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1,username);
            pstmt.setString(2,password);
            res = pstmt.executeQuery();
            conn.commit();  //提交事务
            return res.next();
        } catch (SQLException | ClassNotFoundException e) {
            if (conn != null)
                conn.rollback();  //回滚事务
            e.printStackTrace();
        }finally {
            conn.close();
            pstmt.close();
            res.close();
        }
        return false;
    }
}