publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsIOException,ServletException{//TODOAuto-generatedmethodstubXzdatasqlTool=newXzdata();//初始化并...

public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{

// TODO Auto-generated method stub

Xzdata sqlTool = new Xzdata(); // 初始化并且鏈接數(shù)據(jù)庫(kù)

System.out.println("連接數(shù)據(jù)庫(kù)成功!");

String sql = "select * from MyTable";

ResultSet rs = sqlTool.edb.getTableResult(sql);

ResultVO resVo = new ResultVO();

List listvo = new ArrayList();

try {//捕捉異常

while (rs.next()) {

resVo.setWages(rs.getString("DATAS"));

resVo.setYear(rs.getString("YEAR"));

resVo.setMonth(rs.getString("MONTH"));

resVo.setDay(rs.getString("DAY"));

listvo.add(resVo);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

JSONArray jsonarr = JSONArray.fromObject(listvo); // java字符串轉(zhuǎn)為為json對(duì)象

PrintWriter out = response.getWriter();

out.write(jsonarr.toString());

out.close();

}

public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{

doGet(request,response);

}

把查出的數(shù)據(jù)賦值給resVo時(shí)，后取出的數(shù)據(jù)會(huì)覆蓋之前的resVo，這個(gè)可以理解，但是為什么已經(jīng)放進(jìn)listvo里的resVo也會(huì)被后取到的數(shù)據(jù)替換？如何解決？

展開(kāi)

總結(jié)

以上是生活随笔為你收集整理的java 从数据库取值_java 连接数据库取值问题的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。