求段jsp脚本用ajax跳到action中 查询完以后 在从action返回ajax详细代码 就是要求页面不刷新
页面定义一个div，假设id为test。回调函数里面直接 document.getElementById('test').innerHTML=responsetext;
struts2的后面的：
package com.vmkid.iplug.busserver.action;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts2.interceptor.ServletRequestAware;
import org.apache.struts2.interceptor.ServletResponseAware;
import com.opensymphony.xwork2.ActionSupport;
import com.vmkid.iplug.busserver.common.OptionBean;
import com.vmkid.iplug.busserver.dao.OptionBeanDAO;
public class AjaxGetTypeAction extends ActionSupport implements
ServletRequestAware, ServletResponseAware {
private static final long serialVersionUID = -7935648568639117966L;
private HttpServletRequest request;
private HttpServletResponse response;
public void setServletRequest(HttpServletRequest request) {
this.request = request;
}
public void setServletResponse(HttpServletResponse response) {
this.response = response;
}
public String execute() {
String pTypeId = request.getParameter("pTypeId");
ArrayList<OptionBean> lst;
try {
lst = OptionBeanDAO.getTypeLst(pTypeId);
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
请问大哥们这个sql 语句应该用Java里的那个数据库操作方法？ ......
