java如何将SQL查询转换为JSON数组
我需要转换如下查询的结果:
SELECT * FROM table WHERE column1=X
到java中的JSONArray。 在我的表格中,我有以下几列
- id:int主键自动递增
- 串
- 串
- 串
- 串
- 串
- 智力
- 时间戳当前时间戳
我需要维护相同的结构,除了不需要的id字段
public static ArrayList<Ticket> lookForATicket(String fermataDiscesa) throws Exception {
Connection dbConn = null;
ArrayList<Ticket> list = null;
try {
try {
dbConn = DBConnection.createConnection();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Statement stmt = dbConn.createStatement();
String query = "SELECT * FROM offer WHERE fermataDiscesa = '" + fermataDiscesa
+ "'";
//test
System.out.println(query);
ResultSet rs = stmt.executeQuery(query);
list = new ArrayList<Ticket>();
Ticket tickets = null;
while (rs.next()) {
//per test
System.out.println(rs.getString(1) + rs.getString(2) + rs.getString(3) + rs.getString(4) + rs.getString(5) + rs.getString(6) + rs.getInt(7));
tickets = new Ticket();
//setto i campi
tickets.setIdGooglePlus(rs.getString("IDGOOGLEPLUS"));
tickets.setIdFacebook(rs.getString("IDFACEBOOK"));
tickets.setFermataSalita(rs.getString("FERMATASALITA"));
tickets.setFermataDiscesa(rs.getString("FERMATADISCESA"));
tickets.setBus(rs.getString("BUS"));
tickets.setTempoRimasto(rs.getInt("TEMPORIMASTO"));
tickets.setTimeStamp(rs.getTimestamp("TIMESTAMP"));
//aggiungo alla lista
list.add(tickets);
}
} catch (SQLException sqle) {
throw sqle;
} catch (Exception e) {
// TODO Auto-generated catch block
if (dbConn != null) {
dbConn.close();
}
throw e;
} finally {
if (dbConn != null) {
dbConn.close();
}
}
return list;
}
机票是我的定制课程。 这是“打印”我的JSON对象的代码:
//Path: http://localhost:8080/RESTscambio/search
@Path("/search")
public class Search {
// HTTP Get Method
@GET
// Path: http://localhost:8080/RESTscambio/search/dosearch
@Path("/dosearch")
// Produces JSON as response
@Produces(MediaType.APPLICATION_JSON)
public String doSearch(@QueryParam("fermataDiscesa") String fermataDiscesa) throws Exception{
System.out.println("Cerco biglietti..");
ArrayList<Ticket> list = null;
String response = null;
list = DBConnection.lookForATicket(fermataDiscesa);
JSONArray jArray = new JSONArray(list);
if(list != null){
//System.out.println(jObj.put("list_of_ticket", list).toString());
//jObj.put("list_of_ticket", list);
response = Utility.constructJSON("Biglietti disponibili", true);
}else{
response = Utility.constructJSON("Nessun biglietto disponibile", false);
}
return response;
}
我需要回应。我可以定义一个新的函数来打印。有人能帮我吗? 谢谢!
# 1 楼答案
假设您已经能够检索查询结果,您将不得不编写一些代码,但不要编写太多。我发现Json-lib很容易使用——创建和填充JSON对象或与Java对象(自定义或集合和映射)进行转换非常简单
链接网站上有很多例子可以指导你
鉴于你最新的问题(你最初没有说你有豆子),我建议使用JacksonThis example演示如何使用Jackson将bean输出到文件和字符串
我已经回答了您最初关于将查询输出转换为JSON的问题。对于其他主题的问题(比如回答),你需要问一个新问题