Bank Transaction
好久没有更博了,最近没时间写算法题了,其实我还是很热爱那些东西的 ,瞎扯这么多,我来贴一波MySQL数据库对银行转账事件的代码 这里我连接数据库用了一个类来进行
package bankTransaction;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//银行转账:1. 建立更新两个账户 2. 建立事务机制
class GetDBConnection {
public static Connection connectDB(String DBName, String id, String p) {
Connection con = null;
String uri = "jdbc:mysql://localhost:3306/" + DBName + "?serverTimezone=UTC";
try {
Class.forName("com.sql.cj.jdbc.Driver");
} catch (Exception e) {
}
try {
con = DriverManager.getConnection(uri, id, p);
} catch (SQLException e) {
}
return con;
}
}
public class BankTransaction {
public static void main(String[] args) throws SQLException {
Connection con;
Statement stmt = null