MySQL-MySQL数据转换成json格式

• 包1：mysql-connection-java-5.1.7-bin.jar

• 包2：org.json

• 代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import org.json.JSONArray;
import org.json.JSONObject;

public class MysqlToJSON {
	public static void main(String[] args) throws Exception {
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/ontology";
		String user = "root";
		String pwd = "123456";

		try {
			Class.forName(driver);
			Connection con =DriverManager.getConnection(url,user,pwd);
			Statement stet = con.createStatement();

			String sql = "select * from class_tab";
			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.put(jsonObj);
			}
			System.out.println("转换JSON数据：");
			System.out.println(array.toString());
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}

• 部分效果图如下：