JDBC 属性文件的使用

jdbc.properties属性文件

user=root
passWard=root
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test01?characterEncoding=utf-8

User.java

package JDBCTest;

public class User {
    public String usrName;
    public String passWord;

    public User(String usrName, String passWord) {
        this.usrName = usrName;
        this.passWord = passWord;
    }
    public User() {

    }

    public String getUsrName() {
        return usrName;
    }

    public void setUsrName(String usrName) {
        this.usrName = usrName;
    }

    public String getPassWord() {
        return passWord;
    }

    public void setPassWord(String passWord) {
        this.passWord = passWord;
    }
}

JDBCDemo .java

package JDBCTest;

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


public class JDBCDemo {

    public static void main(String[] args) {
        ForStu();
        Scanner sc = new Scanner(System.in);
        System.out.println("请输入用户名");
        String userName = sc.next();
        System.out.println("请输入密码");
        String passward = sc.next();
        ArrayList<User> userArrayList = getJDBC();
        boolean flag = false;
        for (User user : userArrayList) {
            if (user.getUsrName().equals(userName) && user.getPassWord().equals(passward)) {
                flag = true;
            }

        }
        if(flag==true) {
            System.out.println("登录成功");
        }
    }

            public static ArrayList<User> getJDBC(){

        //创建一个数组
                ArrayList<User> users = new ArrayList<>();
                Connection connection=null;
                Statement statement=null;
                ResourceBundle jdbc = ResourceBundle.getBundle("jdbc");
                String url=jdbc.getString("url");
                String user=jdbc.getString("user");
                String passWard=jdbc.getString("passWard");
                String driver=jdbc.getString("driver");
                try {
                    Class.forName(driver);

                    connection = DriverManager.getConnection(url, user, passWard);
                    statement=connection.createStatement();
                    ResultSet resultSet = statement.executeQuery("select *from t_user");
                    if(resultSet!=null){
                        while(resultSet.next()){
                            String name = resultSet.getString("u_name");
                            String passward = resultSet.getString("u_passward");
                            User user1 = new User();
                            user1.setUsrName(name);
                            user1.setPassWord(passward);
                            users.add(user1);
                        }


                    }

                } catch (Exception e) {
                    e.printStackTrace();
                } finally{
                    try {
                        if (statement != null) {
                            statement.close();
                        }
                        if (connection != null) {
                            connection.close();
                        }
                    }
                    catch (Exception e){

                    }

            }
                return users;
        }
        public static void ForStu () {
            ArrayList<User> users = new ArrayList<>();
            Connection connection=null;
            Statement statement=null;
            ResourceBundle jdbc = ResourceBundle.getBundle("jdbc");
            String url=jdbc.getString("url");
            String user=jdbc.getString("user");
            String passWard=jdbc.getString("passWard");
            String driver=jdbc.getString("driver");
            try {
                Class.forName(driver);

                connection = DriverManager.getConnection(url, user, passWard);
                statement=connection.createStatement();
                ResultSet resultSet = statement.executeQuery("select *from t_user");
                if(resultSet!=null){
                    while(resultSet.next()){
                        String name = resultSet.getString("u_name");
                        String passward = resultSet.getString("u_passward");
                        System.out.println(name+" "+passward);
                    }


                }

            } catch (Exception e) {
                e.printStackTrace();
            } finally{//6.释放资源
                try {
                    if (statement != null) {
                        statement.close();
                    }
                    if (connection != null) {
                        connection.close();
                    }
                }
                catch (Exception e){

                }

            }

    }

    }