完善了數據庫的使用

數據庫的方法類

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();}

雙黃雙紫！！運氣用錯地方了！

?

總結

以上是生活随笔為你收集整理的简单的抽卡模拟器1.2的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。