【Java开源代码栏目提醒】:本文主要为网学会员提供viewThingAction.java,希望对需要viewThingAction.java网友有所帮助,学习一下!
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 viewThingAction extends Action{
/**
* 在此方法中处理HTTP请求,并作响应
*/
public ActionForward execute(ActionMapping arg0, ActionForm arg1,
HttpServletRequest request, HttpServletResponse reponse) throws Exception {
ActionErrors errors=new ActionErrors();
//------接收请求参数------
String thingId=request.getParameter("thingId");
//------如果接收数据有误------
if(thingId==null||thingId.length()==0)
return arg0.findForward("viewThingListdo");
//------构造查询的SQL语句------
String sqlStr="select * from thing where thingId="+thingId;
//------查询出数据,将查询结果数据集写入到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);
ResultSet rs1=sql1.executeQuery(sqlStr);
Object[][] rsArray1=new Object[1][4];
int i=0;
if(rs1.next()){
rsArray1[i][0]=rs1.getString("thingId");
rsArray1[i][1]=rs1.getString("ThingTitle");
rsArray1[i][2]=rs1.getString("ThingContent");
rsArray1[i][3]=rs1.getString("ThingAddTime");
}
request.setAttribute("rsArray1",rsArray1);
sqlStr="select count(*) as recordCount from thingArra,oaUser where "+
"oaUser.oaUserId=thingArra.oaUserId and thingArra.thingId="+thingId;
java.sql.Statement sql2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs2=sql1.executeQuery(sqlStr);
if(rs2.next()){
int recordCount=rs2.getInt("recordCount");
Object[][] rsArray2=new Object[recordCount][2];
sqlStr="select thingArra.thingArraEnd as thingArraEnd,"
+"oaUser.oaUserName as oaUserName from thingArra,oaUser"+
" where oaUser.oaUserId=thingArra.oaUserId and thingArra.thingId="+thingId;
java.sql.Statement sql3=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs3=sql1.executeQuery(sqlStr);
i=0;
while(rs3.next()){
rsArray2[i][0]=rs3.getString("thingArraEnd");
rsArray2[i][1]=rs3.getString("oaUserName");
i++;
}
request.setAttribute("rsArray2",rsArray2);
}
//------关闭数据库连接------
if(conn!=null)
conn.close();
}catch(Exception e){
e.printStackTrace();
errors.add("DBOPError",new ActionMessage("DBOPError"));
saveErrors(request,errors);
return arg0.findForward("viewThingListdo");
}
return arg0.findForward("viewThingJSP");
}
}
上一篇:
viewTeacherInfo_jsp.java
下一篇:
关于大学英语教学