viewinfoaction2.java

此资源是jsp应用开发 邓子云等编写的一书里的源代码

package action;
import java.sql.Connection;
import java.sql.ResultSet;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;

/**
 * @author dengziyun
 * 查看具体信息的Action类
 */
public class viewInfoAction2 extends Action{
	
	/**
	 * 在此方法中处理HTTP请求，并作响应
	 */
	public ActionForward execute(ActionMapping arg0, ActionForm arg1,
			HttpServletRequest request, HttpServletResponse reponse) throws Exception {
		ActionErrors errors=new ActionErrors();
		//------接收请求参数------
		String infoId=request.getParameter("infoId");
		//------如果接收数据有误------
	  	if(infoId==null||infoId.length()==0)
	  		return arg0.findForward("viewInfodo");
	  	//------构造查询的SQL语句------
	  	String sqlStr="select * from info where infoId="+infoId;
	  	//------查询出数据，将查询结果数据集写入到response中------
	  	try{
			//------得到数据库连接------
			Context initCtx = new InitialContext(); 
			Context ctx = (Context) initCtx.lookup("java:comp/env");
			Object obj = (Object) ctx.lookup("jdbc/sqlserver");
			DataSource ds = (javax.sql.DataSource)obj;
			Connection conn = ds.getConnection();
			//------查询数据------
		  	java.sql.Statement sql1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
		  	java.sql.ResultSet rs1=null;
		  	ResultSet rs=sql1.executeQuery(sqlStr);
		  	Object[][] rsArray=new Object[1][4];
		  	int i=0;
		  	if(rs.next()){
		  		rsArray[i][0]=rs.getString("infoId");
		  		rsArray[i][1]=rs.getString("infoTitle");
		  		rsArray[i][2]=rs.getString("infoContent");
		  		rsArray[i][3]=rs.getString("infoAddTime");
		  	}
		  	request.setAttribute("rsArray",rsArray);
		  	//------关闭数据库连接------
		  	if(conn!=null)
		  		conn.close();
		}catch(Exception e){
			e.printStackTrace();
			errors.add("DBOPError",new ActionMessage("DBOPError"));
			saveErrors(request,errors);
			return arg0.findForward("viewInfodo");
		}
		return arg0.findForward("viewInfo2JSP");
	}
}