package com.example.demo.json;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
public class Mysql {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
//这里我的数据库名字是Person,改成你自己的数据库名
String url = "jdbc:mysql://192.168.0.170:3306/wcxx";
String user = "root";
String pwd = "zhjx123";
try {
Class.forName(driver);
Connection con =DriverManager.getConnection(url,user,pwd);
Statement stet = con.createStatement();
//我的数据库Person中的表student,改成你自己的表
String sql = "SELECT * from p_census limit 0,150";
ResultSet rs = stet.executeQuery(sql);
ResultSetMetaData metaData =rs.getMetaData();
int columnCount= metaData.getColumnCount();
JSONArray array = new JSONArray();
while(rs.next()){
JSONObject jsonObj = new JSONObject();
for(int i = 1; i <= columnCount;i++){
String columnName = metaData.getColumnLabel(i);
String value =rs.getString(columnName);
jsonObj.put(columnName, value);
}
array.add(jsonObj);
}
System.out.println(array.toString());
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}