6.28

import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.*;
import java.util.Properties;

public class JDBCUtils {
    private static String url;
    private static String user;
    private static String password;
    private static String driver;
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url,user,password);
    }
    public static void close(ResultSet rs, Statement stmt, Connection conn) throws SQLException {
        if(rs!=null){
            rs.close();
        }
        if(stmt!=null){
            stmt.close();
        }
        if(conn!=null){
            conn.close();
        }
    }
    static{
        try{
            Properties pro=new Properties();
            ClassLoader classLoader=JDBCUtils.class.getClassLoader();
            URL res=classLoader.getResource("jdbc.properties");
            String path=res.getPath();
            path = java.net.URLDecoder.decode(path,"utf-8");
            System.out.println(path);

            pro.load(new FileReader(path));

            url = pro.getProperty("url");
            user= pro.getProperty("user");
            password= pro.getProperty("password");
            driver= pro.getProperty("driver");

            Class.forName(driver);

            }catch (IOException e){
                e.printStackTrace();
            }catch (ClassNotFoundException e1){
                e1.printStackTrace();
            }
        }


    }

import sun.security.util.Password;

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

public class jdbc_test {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
//        Class.forName("com.mysql.jdbc.Driver");
//        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/test1","root","123456");
//        String sql="update user set name = 'qwe' where id=2";
//        Statement statement= connection.createStatement();
//        int count= statement.executeUpdate(sql);
//        System.out.println(count);
//        statement.close();
//        connection.close();
        Scanner sc=new Scanner(System.in);
        System.out.println("请输入用户名：");
        String username=sc.nextLine();
        System.out.println("请输入密码：");
        String password=sc.nextLine();

        boolean flag=new jdbc_test().login(username,password);
        if(flag){
            System.out.println("登陆成功！");
        }
        else {
            System.out.println("登陆失败！");
        }

    }
    public boolean login(String username,String password) throws SQLException {
        if(username==null||password==null){
            return false;
        }
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
        try{
            conn=JDBCUtils.getConnection();
            String sql="select * from user where name='"+username+"' and password='"+password+"' ";
            stmt=conn.createStatement();
            rs=stmt.executeQuery(sql);
            return rs.next();
        }catch (SQLException e){
            e.printStackTrace();
        }finally {
            JDBCUtils.close(rs,stmt,conn);
        }
        return false;
    }
}

url=jdbc:mysql://localhost:3306/test1
user=root
password=123456
driver=com.mysql.jdbc.Driver