一、pom.xml
二、连接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);
}
五、上传数据到接口(还没写)
标签:Java,String,数据库,org,return,void,Sql,import,public From: https://www.cnblogs.com/blwynjn/p/17576748.html