public class UserDao { // you need to call your Singleton Connection class: Connection con = MyConnection.getInstanceOf(); // and then you write a method to update your object, here I'm updating a User Object: public void updateUser(User user) { try { String sql= "Update User set username='"+user.getUserName()+"',score='"+user.getScore()+"' where userid='"+user.getUserId()+"'"; Statement ste= con.createStatement(); ste.executeUpdate(sql); } catch (SQLException ex) { Logger.getLogger(UserDao.class.getName()).log(Level.SEVERE, null, ex); } }
public String getList() throws JSONException { User dataUser =memberO.getMember(1); JSONObject jsonObject = new JSONObject(); jsonObject.put("name", dataUser.getUserName()); jsonObject.put("account", dataUser.getAccount()); jsonObject.put("edit", dataUser.getUserId()); jsonObject.put("delete", dataUser.getUserId()); JSONArray jsonArray = new JSONArray(); jsonArray.add(jsonObject); JSONObject responseJson = new JSONObject(); responseJson.put("data", jsonArray);//Here you can see the data in json format return responseJson.toString(); }
public String getList() throws JSONException { List<User> data = member.getCurrentMembers() ; JSONArray array = new JSONArray(); for (User u : data) { JSONObject datas = new JSONObject(); datas.put("name", u.getUserName()); datas.put("account", u.getAccount()); datas.put("edit", u.getUserId()); datas.put("id", u.getUserId()); array.put(datas); } JSONObject result = new JSONObject(); result.put("Data", array); }
public String getList() throws JSONException { User dataUser =memberO.getMember(1); JSONObject jsonObject = new JSONObject(); jsonObject.put("name", dataUser.getUserName()); jsonObject.put("account", dataUser.getAccount()); jsonObject.put("edit", dataUser.getUserId()); jsonObject.put("delete", dataUser.getUserId()); JSONArray jsonArray = new JSONArray(); jsonArray.put(0, jsonObject); JSONObject topObject = new JSONObject(); topObject.put("data", jsonArray); System.out.println(topObject.toJSONString); System.out.println(jsonArray); String str = "{\"data\": [{\"name\": \""+dataUser.getUserName()+"\",\"account\": \""+dataUser.getAccount()+"\",\"edit\": \""+dataUser.getUserId()+"\",\"delete\": \""+dataUser.getUserId()+"\"}]}"; return str; }