简单的jdbc测试类

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();
	    } 
}
}