ajax获取后台json无法执行
我的ajax不执行,不知道出了什么问题,有大神帮忙解决吗
内容是java连接数据库获取数据并以json保存,并作为servlet向前台发送数据
java文件:
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection ct = null;
java.sql.Statement sm = null;
java.sql.ResultSet rs = null;
try{
Class.forName("com.mysql.jdbc.Driver"); //连接mysql数据库
ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/river?serverTimezone=GMT&useUnicode=true&characterEncoding=utf-8","root", "123456");
sm = ct.createStatement();
rs = sm.executeQuery("select *from rivere");
JSONArray jsonData = JSONArray.fromObject(convertList(rs));
response.setHeader("Content-type", "text/html;charset=UTF-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.print(jsonData);//把json数据传递到前端,记着前端用ajax接收
out.println(jsonData);
rs.close();
ct.close();
}
catch(Exception ex)
{
System.out.print("get data error!");
ex.printStackTrace(); }
}
web.xml配置:
<servlet>
<servlet-name>riverdata</servlet-name>
<servlet-class>riverdata.riverdata</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>riverdata</servlet-name>
<url-pattern>/river</url-pattern>
</servlet-mapping>
ajax的function:
function getJson()
{
$.ajax({
url:"river",
type:"post",
data:{"NS":NS,"EW":EW,"num":num,"depth":depth},
dataType:json,
success: function(jsonData)
{
alert(3);
},
error:function()
{
alert("错误");
}
});
}
请问到底是哪里出错了呢?很头疼,怎么都不执行,url和datatype怎么改都不运行,alert也不弹出来,success和error都不弹。