1 import java.sql.Connection;
2 import java.sql.DriverManager;
3 import java.sql.PreparedStatement;
4 import java.sql.ResultSet;
5 import java.sql.SQLException;
6
7 /**********
8 *
9 * @author aq
10 *
11 */
12 public class DBOper {
13 Connection conn = null;
14 PreparedStatement pstmt = null;
15 ResultSet rs = null;
16
17 public Connection getConn(String server, String dbname, String user, String pwd)
18 throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {
19 String DRIVER = "com.mysql.jdbc.Driver";
20 String URL = "jdbc:mysql://" + server + ":3306/" + dbname + "?user=" + user + "&password=" + pwd
21 + "&useUnicode=true&characterEncoding=utf8";
22 Class.forName(DRIVER).newInstance();
23 conn = DriverManager.getConnection(URL);
24 return conn;
25 }
26
27 public void closeAll() {
28 if (rs != null) {
29 try {
30 rs.close();
31 } catch (SQLException e) {
32 e.printStackTrace();
33 }
34 }
35 if (pstmt != null) {
36 try {
37 pstmt.close();
38 } catch (SQLException e) {
39 e.printStackTrace();
40 }
41 }
42 if (conn != null) {
43 try {
44 conn.close();
45 } catch (SQLException e) {
46 e.printStackTrace();
47 }
48 }
49 }
50
51 public ResultSet executeQuery(String preparedSql, String[] param) {
52 try {
53 pstmt = conn.prepareStatement(preparedSql);
54 if (param != null) {
55 for (int i = 0; i < param.length; i++) {
56 pstmt.setString(i + 1, param[i]);
57 }
58 }
59 rs = pstmt.executeQuery();
60 } catch (SQLException e) {
61 e.printStackTrace();
62 }
63 return rs;
64 }
65
66 public int executeUpdate(String preparedSql, String[] param) {
67 int num = 0;
68 try {
69 pstmt = conn.prepareStatement(preparedSql);
70 if (param != null) {
71 for (int i = 0; i < param.length; i++) {
72 pstmt.setString(i + 1, param[i]);
73 }
74 }
75 num = pstmt.executeUpdate();
76 } catch (SQLException e) {
77 e.printStackTrace();
78 }
79 return num;
80 }
81
82 }
