-
Notifications
You must be signed in to change notification settings - Fork 4
/
TransactionTestInit.java
55 lines (46 loc) · 1.41 KB
/
TransactionTestInit.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
package com.micro.profession.jdbc.practice.Transaction;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import org.apache.commons.dbcp2.BasicDataSource;
public class TransactionTestInit {
public static BasicDataSource ds = null;
static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
static String DB_URL = "jdbc:mysql://localhost/cloud_study?useSSL=true";
static final String USER_NAME = "root";
static final String PASSWORD = "root";
public static void transactionInit() {
ds = new BasicDataSource();
ds.setUrl(DB_URL);
ds.setDriverClassName(DRIVER_NAME);
ds.setUsername(USER_NAME);
ds.setPassword(PASSWORD);
}
public static void transferAccount() throws ClassNotFoundException {
Connection conn = null;
PreparedStatement ptmt = null;
try {
conn = ds.getConnection();
ptmt = conn.prepareStatement("update user set account = ? where userName = ?");
ptmt.setInt(1, 0);
ptmt.setString(2, "ZhangSan");
ptmt.execute();
ptmt.setInt(1, 100);
ptmt.setString(2, "LiSi");
ptmt.execute();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(conn != null) conn.close();
if(ptmt != null) ptmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) throws ClassNotFoundException {
transactionInit();
new TransactionTestInit().transferAccount();
}
}