1 import java.sql.*; 2 import java.util.*; 3 import org.json.*;//引入相关包,包含在json.jar里 4 5 public class SqlJsonConvertor { 6 public static void main(String[] args) { 7 String driver = "com.mysql.jdbc.Driver"; 8 String url = "jdbc:mysql://localhost:3306/phpwind"; 9 String user = "root"; 10 String passwd = "123456"; 11 String sql = "select * from pw_acloud_apis"; 12 13 try { 14 Class.forName(driver); 15 Connection con = DriverManager.getConnection(url, user, passwd); 16 Statement st = con.createStatement(); 17 ResultSet rs = st.executeQuery(sql); 18 ResultSetMetaData rsmd = rs.getMetaData(); 19 int colnum = rsmd.getColumnCount(); 20 String val = ""; 21 String colName = ""; 22 JSONObject jobj = new JSONObject(); 23 JSONArray jArr = new JSONArray(); 24 25 while(rs.next()) { 26 for(int i = 1; i<= colnum; i++) { 27 colName = rsmd.getColumnLabel(i); 28 if(1==i) { 29 val = new Integer(rs.getInt(colName)).toString(); 30 }else { 31 val = rs.getString(colName); 32 } 33 34 try { 35 jobj.put(colName, val); 36 37 } catch (JSONException e) { 38 // TODO Auto-generated catch block 39 e.printStackTrace(); 40 } 41 } 42 jArr.put(jobj); 43 } 44 System.out.println("Here is the json String:"); 45 System.out.println(jArr.toString()); 46 47 }catch(ClassNotFoundException e) { 48 System.out.println("Driver not found"); 49 e.printStackTrace(); 50 }catch(SQLException e) { 51 e.printStackTrace(); 52 } 53 } 54 }