Java提取Sql数据库数据，上传到接口测试

一、pom.xml

4.0.0
HtyyDemo
HtyyDemo
0.0.1-SNAPSHOT

org.mybatis mybatis 3.4.6 com.microsoft.sqlserver sqljdbc4 2.0 org.json json 20180130 com.alibaba fastjson 2.0.15 org.apache.httpcomponents httpclient 4.5.13 org.slf4j slf4j-api 1.7.25 compile org.slf4j slf4j-api 1.7.5 org.slf4j slf4j-simple 1.7.21 org.asynchttpclient async-http-client 2.6.0 compile commons-io commons-io 2.6

二、连接SQL数据库，数据池java类
package until;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Localuntil {
public static final String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static final String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=test";
public static final String userName = "sa";
public static final String userPwd = "123456";
public static void main(String[] args){
//类第一次加载的时候执行一次

	    		try {
	    			
	    	//1.加载驱动
	    			Class.forName(driverName);
	    		} catch (ClassNotFoundException e) {
	    			// TODO Auto-generated catch block
	    			e.printStackTrace();System.out.println("连接数据库失败");
	    		}//有可能报错
	    	}
	    	

	    	
	    	//2.数据库链接
	    	public static Connection getConn() {
	    		
	    		
	    		Connection conn =null;
	    		
	    		 try {
	    			 
	    			conn= DriverManager.getConnection(dbURL, userName, userPwd);
	    		  System.out.println("连接数据库成功");
	    		 } catch (SQLException e) {
	    			// TODO Auto-generated catch block
	    			e.printStackTrace(); System.out.println("连接数据库失败");
	    		}return conn;
	    	}
	    	
	    	public static void close(Connection conn,PreparedStatement pst) {
	    		try {
	    	//5.关闭数据库	
	    			conn.close();
	    			pst.close();
	    			
	    		} catch (SQLException e) {
	    			// TODO Auto-generated catch block
	    			e.printStackTrace();
	    		}	
	    	}

}

三、自定义类的属性、方法
package demo.size;

public class Chinese_medicine {
public String entid;
public String medicalId;
public String uid;
public String userName;
public String institutionId;
public String issueDt;
public String medicineCnt;
public String dosage;
public int type;
public String prescribeMedicine;
public String prescribeMedicineId;
public String reviewer;
public String reviewerId;
public String prescriptionPharmacist;
public String prescriptionPharmacistId;
public String dispensingPharmacist;
public String dispensingPharmacistId;
public String itemsList;
public String getEntid() {
return entid;
}
public void setEntid(String entid) {
this.entid = entid;
}
public String getMedicalId() {
return medicalId;
}
public void setMedicalId(String medicalId) {
this.medicalId = medicalId;
}
public String getUid() {
return uid;
}
public void setUid(String uid) {
this.uid = uid;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getInstitutionId() {
return institutionId;
}
public void setInstitutionId(String institutionId) {
this.institutionId = institutionId;
}
public String getIssueDt() {
return issueDt;
}
public void setIssueDt(String issueDt) {
this.issueDt = issueDt;
}
public String getMedicineCnt() {
return medicineCnt;
}
public void setMedicineCnt(String medicineCnt) {
this.medicineCnt = medicineCnt;
}
public String getDosage() {
return dosage;
}
public void setDosage(String dosage) {
this.dosage = dosage;
}
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
public String getPrescribeMedicine() {
return prescribeMedicine;
}
public void setPrescribeMedicine(String prescribeMedicine) {
this.prescribeMedicine = prescribeMedicine;
}
public String getPrescribeMedicineId() {
return prescribeMedicineId;
}
public void setPrescribeMedicineId(String prescribeMedicineId) {
this.prescribeMedicineId = prescribeMedicineId;
}
public String getReviewer() {
return reviewer;
}
public void setReviewer(String reviewer) {
this.reviewer = reviewer;
}
public String getReviewerId() {
return reviewerId;
}
public void setReviewerId(String reviewerId) {
this.reviewerId = reviewerId;
}
public String getPrescriptionPharmacist() {
return prescriptionPharmacist;
}
public void setPrescriptionPharmacist(String prescriptionPharmacist) {
this.prescriptionPharmacist = prescriptionPharmacist;
}
public String getPrescriptionPharmacistId() {
return prescriptionPharmacistId;
}
public void setPrescriptionPharmacistId(String prescriptionPharmacistId) {
this.prescriptionPharmacistId = prescriptionPharmacistId;
}
public String getDispensingPharmacist() {
return dispensingPharmacist;
}
public void setDispensingPharmacist(String dispensingPharmacist) {
this.dispensingPharmacist = dispensingPharmacist;
}
public String getDispensingPharmacistId() {
return dispensingPharmacistId;
}
public void setDispensingPharmacistId(String dispensingPharmacistId) {
this.dispensingPharmacistId = dispensingPharmacistId;
}
public String getItemsList() {
return itemsList;
}
public void setItemsList(String itemsList) {
this.itemsList = itemsList;
}
@Override
public String toString() {
return "Chinese_medicine [entid=" + entid + ", medicalId=" + medicalId + ", uid=" + uid + ", userName="
+ userName + ", institutionId=" + institutionId + ", issueDt=" + issueDt + ", medicineCnt="
+ medicineCnt + ", dosage=" + dosage + ", type=" + type + ", prescribeMedicine=" + prescribeMedicine
+ ", prescribeMedicineId=" + prescribeMedicineId + ", reviewer=" + reviewer + ", reviewerId="
+ reviewerId + ", prescriptionPharmacist=" + prescriptionPharmacist + ", prescriptionPharmacistId="
+ prescriptionPharmacistId + ", dispensingPharmacist=" + dispensingPharmacist
+ ", dispensingPharmacistId=" + dispensingPharmacistId + ", itemsList=" + itemsList + "]";
}
}

四、将提取到的数据转化成json类型
package demo.select;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import org.apache.http.HttpStatus;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.message.BasicHeader;
import org.apache.http.protocol.HTTP;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import demo.size.*;
import until.Htyyuntil;
import until.Localuntil;

public class tojson {
public static void main(String[] args) throws Exception{

	ArrayList<Chinese_medicine> list= new ArrayList<Chinese_medicine>();
	Connection con = Htyyuntil.getConn();
	
    //3、创建 PreparedStatement对象
    String sql = "SELECT top 1 * FROM Prescription where itemsList <> '' ";
	PreparedStatement ps = con.prepareStatement(sql);

	//5、执行 sql语句
	ResultSet rs = ps.executeQuery();
	//6、处理结果
	while(rs.next()) {
		Chinese_medicine n =new Chinese_medicine();
		String entid = rs.getString("entid");
		String itemsList = rs.getString("itemsList");
		
		
		n.setEntid(entid);
		n.setItemsList(itemsList);
		list.add(n);

	}
	System.out.println("存入列表成功");
	//7、关闭连接
	con.close();
	ps.close();
	rs.close();
   
    JSONArray jsonArray = new JSONArray();
    
    String [] array={"斯","人","若","彩","虹","，","遇","上","方","知","有","。"};
        for (Chinese_medicine n:list) {
            //存放[{"index":index,"array":array}]
        	JSONObject jsonObject = new JSONObject();
        	 jsonObject.put("处方id",n.getEntid());
             jsonObject.put("处方详情", n.getItemsList());
            //1. 外层  JsonArray
            jsonArray.add(array);

        }
    System.out.println(jsonArray);
}

五、上传数据到接口（还没写）