1 package keyword;
2
3 import java.io.UnsupportedEncodingException;
4 import java.sql.Connection;
5 import java.sql.DriverManager;
6 import java.sql.PreparedStatement;
7 import java.sql.ResultSet;
8 import java.sql.SQLException;
9
10 import cn.suning.automation.execute.Parameter;
11 import cn.suning.automation.param.Reference;
12
13 public class MySQLConnection {
14 private static final String DBDRIVER = "com.mysql.jdbc.Driver";
15 private static final String DBURL = "jdbc:mysql://localhost:3306/dbname"
16 + "user=root@password=pwd@useUnicode=true&characterEncoding=UTF8";
17 private static final String URL = "jdbc:mysql://localhost:3306/dbname?characterEncoding=UTF8"; //如果不指定字符集则在封装的关键字里查询不到结果
18 private static final String DBUSER = "root";
19 private static final String PASSWORD = "pwd";
20 private Connection conn = null;
21
22 public MySQLConnection() {
23 try {
24 Class.forName(DBDRIVER);
25 //System.out.println("成功加载MySQL驱动！");
26 this.conn = DriverManager.getConnection(URL, DBUSER, PASSWORD);
27 // this.conn=DriverManager.getConnection(DBURL);
28 } catch (Exception e) {
29 e.printStackTrace();
30 }
31 }
32
33 public Connection getConnection() {
34 return this.conn;
35 }
36
37 public void close() {
38 if (this.conn != null) {
39 try {
40 this.conn.close();
41 } catch (SQLException e) {
42 e.printStackTrace();
43 }
44 }
45 }
46
47 public static void encodedString(Parameter poParam) throws UnsupportedEncodingException {
48 String sResult=String.valueOf(getValue());
49
50 Reference<String> oResult=Reference.refer(poParam.getString("result"));
51 oResult.setValue(poParam, sResult);
52 }
53
54 public static int getValue() {
55 int value=0;
56 MySQLConnection mySQLConnection = new MySQLConnection();
57 Connection conn = mySQLConnection.getConnection();
58 //String sql = "INSERT INTO student(name) VALUES(?)";
59 String sql="SELECT colName FROM tableName where colName2='中文'";
60 try {
61 PreparedStatement statement = conn.prepareStatement(sql);
62 // ResultSet resultSet=statement.executeQuery();
63 //statement.setString(1, "赵六子");
64 // System.out.println(statement.executeUpdate());
65 ResultSet rs=statement.executeQuery(sql);
66
67 while (rs.next()){
68 System.out.print(rs.getInt(1) + "\t");
69 // System.out.print(rs.getInt(2) + "\t");
70 // System.out.print(rs.getString(3) + "\t");
71 System.out.println();
72 value=rs.getInt(1);
73 }
74
75 rs.close();
76
77 conn.close();
78 } catch (SQLException e) {
79 e.printStackTrace();
80 }
81 return value;
82 }
83
84 public static void main(String[]args) {
85 System.out.println(getValue());
86 }
87 }
