2017년 1월 22일 일요일

ajax cross domain

@RequestMapping(value="/crossAjax")
@ResponseBody
public String crossAjax(HttpServletRequest request){
String callback=request.getParameter("callback");
System.out.println("-----" + callback);
System.out.println("-----" + request.getParameter("query"));
JSONObject obj=new JSONObject();
try {
obj.put("message", "test1");
obj.put("time", "test1");
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

System.out.println(obj.toString());
return callback + "(" + obj.toString() + ")"


}


        $.ajax({
               url : "http://127.0.0.1:8080/home/crossAjax",
       data : {query:"select * from ssssss"},
       dataType : "jsonp",
       jsonp : "callback",
       success: function(data) {
   console.log('성공 - ', data);
       },
               error: function(xhr) {
  alert('실패 - ' +  xhr.statusText);
       }
        });

2017년 1월 14일 토요일

postgresql update or insert

CREATE TABLE test2 (id integer primary key, b varchar(10), c varchar(10), dt timestamp with time zone);

UPDATE test2 SET dt=CURRENT_TIMESTAMP WHERE id=1;
INSERT INTO test2 (id, b, c, dt)
       SELECT 1,'xxx', 'xZ', CURRENT_TIMESTAMP
       WHERE NOT EXISTS (SELECT 1 FROM test2 WHERE id=1);