简单的抽卡模拟器1.2

完善了数据库的使用

数据库的方法类

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

public class JDBCUtils {
    private static String url;
    private static String Driver;
    private static String user;
    private static String pwd;

    static{
        try {
            Properties properties = new Properties();

            properties.load(new FileReader("G:\\JavaStudy2\\配置文件\\config.properties"));

            url = properties.getProperty("url");
            Driver = properties.getProperty("Driver");
            user = properties.getProperty("username");
            pwd = properties.getProperty("password");

            Class.forName(Driver);
        }catch (IOException e){
            e.printStackTrace();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }
    }

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url,user,pwd);
    }

    public static void close(Statement stat, Connection dbConn){
        if(stat != null) {
            try {
                stat.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(dbConn != null) {
            try {
                dbConn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
    public static void close(ResultSet rs, Statement stat, Connection dbConn){
        if(stat != null) {
            try {
                stat.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(dbConn != null) {
            try {
                dbConn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

    }

    public static void close(Statement stat){
        if(stat != null) {
            try {
                stat.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

 抽卡更改（是不是PrepareStatement 占位符不能是表？？）

public void setGoldCard(){
        String sql = "SELECT * FROM goldCard";
        Connection dbConn = null;
        ResultSet rs = null;
        PreparedStatement preparedStatement = null;
        try{
            dbConn = JDBCUtils.getConnection();
            preparedStatement = dbConn.prepareStatement(sql);
            rs = preparedStatement.executeQuery();

            while (rs.next()){
                goldCard.add(rs.getString("Card_Name"));
            }

        }catch (SQLException e){
            e.printStackTrace();
        }finally {
            JDBCUtils.close(rs,preparedStatement,dbConn);
        }
    }

属性文件设置

public void writeProperties(){
        Properties properties = new Properties();
        OutputStream output = null;
        try{
            output = new FileOutputStream("G:\\JavaStudy2\\配置文件\\config.properties");
            properties.setProperty("url","jdbc:sqlserver://localhost:1433;DatabaseName=CARD");
            properties.setProperty("username","kyvlms");
            properties.setProperty("password","19990616op");
            properties.setProperty("Driver","com.microsoft.sqlserver.jdbc.SQLServerDriver");

            properties.store(output,"欧阳卓远是个鸹貔");
        }catch (IOException e){
            e.printStackTrace();
        }finally {
            if(output != null){
                try {
                    output.close();
                }catch (IOException e){
                    e.printStackTrace();
                }
            }
        }
    }

    public static void main(String[] args) {
        new setProperties().writeProperties();
    }

双黄双紫！！运气用错地方了！