testjson1.jsp 부분
<%@page import="javax.management.StringValueExp"%>
<%@page import="org.apache.catalina.util.StringParser"%>
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<%@ page import="org.json.simple.*"%>
<%@ page import="java.sql.*"%>
<%
String connect="jdbc:oracle:thin:@lsw.c2lzj8znf3wg.ap-northeast-1.rds.amazonaws.com:1521:ORCL";
String user="lsw";
String passwd="";
Connection conn;
Statement stat;
JSONArray arr = new JSONArray();
try{
System.out.println("ddd");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("zzzzzz");
conn= DriverManager.getConnection(connect ,user ,passwd);
if(conn!= null){
System.out.println("connect");
}
else{
System.out.println("not connect.");
}
stat= conn.createStatement();
/*String query="select * from TMP_TB";
System.out.println(query);*/
ResultSet rs = stat.executeQuery("select * from productBoard");
while(rs.next()){
//rs.next();
String goodsname=rs.getString(1);
String id=rs.getString(13);
//String earning =String.valueOf(rs.getInt(3));
int price=rs.getInt(4);
JSONObject obj = new JSONObject();
obj.put("goodsname", goodsname);
obj.put("id", id);
obj.put("price", price);
//arr.add(0, obj);
if(obj != null){
arr.add(obj);
//out.println(arr.toJSONString());
}
//System.out.println(goodsname +"--"+ id + "--"+ price);
}
System.out.println(arr.toJSONString());
out.println(arr.toJSONString());
rs.close();
stat.close();
conn.close();
}catch(Exception er){
}
/* String name= request.getParameter("name");
JSONArray jarray = new JSONArray();
JSONObject jobject=new JSONObject();
jobject.put("name", name);
jobject.put("age", "14");
jobject.put("nickname", "qwerty");
jarray.add(0, jobject);
*/
%>
ajaxtest1.html 부분
<!DOCTYPE html>
<html>
<head>
<script src="http://code.jquery.com/jquery-latest.min.js"></script>
<script>
$(document).ready(function(){
jQuery.ajax({
type:"post",
url: "./testjson1.jsp",//"./test.html",
data:"name=junho",
dataType:"JSON",
success: function(data){
//alert(data);
$.each(data, function(){
//alert(this["name"]);
// 한줄은 되는데 배열은 오류가 난다
alert(this.goodsname);
alert(this.id);
alert(this.price);
});
},
complete: function(data){
},
error:function(xhr, status , error){
alert("에러발생");
}
})
})
</script>
<meta charset="EUC-KR">
<title>Insert title here</title>
</head>
<body>
</body>
</html>
