81,122
社区成员




package com.lerx.services;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import net.sf.json.JSONArray;
public class GetInfoByJdbc {
/* public static void main(String[] args) {
getInfo("sd", "sd");
}*/
public String getInfo() {
List<OrderBean> list = new ArrayList<OrderBean>();
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connectMySQL = DriverManager.getConnection(
"jdbc:mysql://10.66.0.237:3306/lerx","root", "");
Statement statament = connectMySQL.createStatement();
ResultSet resultSet = statament.executeQuery("select * from sale_order");
// ResultSet resultSet = statament.executeQuery("order" );
while (resultSet.next()) { // 判断是否还有下一个数据
// 根据字段名获取相应的值
OrderBean bean = new OrderBean();
bean.setId(resultSet.getString("id"));
bean.setOrder_id(resultSet.getString("order_id"));
bean.setAmount(resultSet.getString("amout"));
list.add(bean);
}
try {
if (connectMySQL != null)
connectMySQL.close();
} catch (Exception ex) {
ex.printStackTrace();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JSONArray json = JSONArray.fromObject(list);
String str = json.toString();
return "qwqwq";
}
}