建立一个链接数据库的类:
package com.fang.kujiale;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class QueryDb {
private static final String driverName = “com.mysql.jdbc.Driver”;
private String username = “cms_test_admin”;
private String password = “4oVvEocw”;
public Connection conn = null;
public Statement st = null;
public Statement st1 = null;
public Statement st2 = null;
public ResultSet rs = null;
public ResultSet rs1 = null;
public ResultSet rs2 = null;
public void InitDb() {
try {
Class.forName(driverName);
conn = DriverManager
.getConnection(
“jdbc:mysql://124.251.50.124:3305/cms_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true”,
username, password);
st = conn.createStatement();
st1 = conn.createStatement();
st2 = conn.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
public void getConnection() {
try {
while (true) {
Thread.sleep(5000);
Class.forName(driverName);
conn = DriverManager
.getConnection(
“jdbc:mysql://124.251.50.124:3305/cms_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true”,
username, password);
if (conn != null) {
st = conn.createStatement();
break;
}
}
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
测试调用的方法:
package com.fang.kujiale;
import java.io.IOException;
import java.net.URLEncoder;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import net.sf.json.JSONObject;
public class KujiaLeUtil extends QueryDb {
public void queryTable() throws InterruptedException {
String sql = “select id,houseName from kujiale_houseinfo where id>150”;
// 封装查询到的数据结果:
List