Action代码如下:
package com.kolezen.action.projectmgr;
import java.util.List;import com.door.db.IDoorDbContext;
import com.door.pr.action.DoorContext;
import com.door.pr.form.DoorForm;
import com.kolezen.action.OAAction;
import com.kolezen.bl.projectmgr.ProjectTaskCrtBl;
import com.kolezen.form.projectmgr.ProjectTaskCrtForm;
import com.kolezen.record.projectmgr.ProjectTaskCrtRecord;public class ProjectTaskCrtAction extends OAAction{
public String init(DoorForm form, DoorContext context) {
log.info("ProjectTaskCrtAction init 方法执行开始。");
ProjectTaskCrtForm projectTaskCrtForm = (ProjectTaskCrtForm)form;
IDoorDbContext idc = context.getDbContext();
ProjectTaskCrtBl projectTaskCrtBl = new ProjectTaskCrtBl(idc);
ProjectTaskCrtRecord projectTaskCrtRecord =new ProjectTaskCrtRecord();
//在Action获取传递过来的值,并在传递过来的值存入record缓存中
projectTaskCrtRecord.setProject_ID((String) context.getRequestData("prjid"));
List list = projectTaskCrtBl.doSelectHead(projectTaskCrtRecord);
List list1 = projectTaskCrtBl.doSelectBody(projectTaskCrtRecord);
projectTaskCrtForm.setUserDataList(list);
projectTaskCrtForm.setUserDataList1(list1);
log.info("ProjectTaskCrtAction init 方法执行结束。"); return "init";
}}
package com.kolezen.action.projectmgr;
import java.util.List;import com.door.db.IDoorDbContext;
import com.door.pr.action.DoorContext;
import com.door.pr.form.DoorForm;
import com.kolezen.action.OAAction;
import com.kolezen.bl.projectmgr.ProjectTaskCrtBl;
import com.kolezen.form.projectmgr.ProjectTaskCrtForm;
import com.kolezen.record.projectmgr.ProjectTaskCrtRecord;public class ProjectTaskCrtAction extends OAAction{
public String init(DoorForm form, DoorContext context) {
log.info("ProjectTaskCrtAction init 方法执行开始。");
ProjectTaskCrtForm projectTaskCrtForm = (ProjectTaskCrtForm)form;
IDoorDbContext idc = context.getDbContext();
ProjectTaskCrtBl projectTaskCrtBl = new ProjectTaskCrtBl(idc);
ProjectTaskCrtRecord projectTaskCrtRecord =new ProjectTaskCrtRecord();
//在Action获取传递过来的值,并在传递过来的值存入record缓存中
projectTaskCrtRecord.setProject_ID((String) context.getRequestData("prjid"));
List list = projectTaskCrtBl.doSelectHead(projectTaskCrtRecord);
List list1 = projectTaskCrtBl.doSelectBody(projectTaskCrtRecord);
projectTaskCrtForm.setUserDataList(list);
projectTaskCrtForm.setUserDataList1(list1);
log.info("ProjectTaskCrtAction init 方法执行结束。"); return "init";
}}
解决方案 »
- 如何实现密码自动登录
- ssh通过form传值为空值
- 请问各位高手,JavaWEB开发时有没有类似office界面的ajax框架,就像在asp.net中那种控件,加入后就能做界面类似office的文本操作
- 求个验证包含大小写的javascript函数
- 在java中使用安全证书的问题 (100分求助)
- onClick="javascript:document.all.a.submit();"是什么意思?如果在页面把表格的内容生成一个execl,该怎么做?
- 俺是学JSP的新手请有经验的大虾们给点意见!!!在线
- 我遇到一个不能解决的问题,JAVA操作SQL2000数据库
- 关于RESULTSET insertRow方法????(急)!up有分,各位大大帮忙UP一下!谢谢!
- javabean 或 jsp 调用C\C++问题
- 关于Struts输出字符串的问题
- 请问url跳转的转换问题
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;import com.door.ap.BusinessLogicBean;
import com.door.db.DBCreateException;
import com.door.db.DataAccess;
import com.door.db.IDoorDbContext;import com.kolezen.record.projectmgr.ProjectTaskCrtRecord;public class ProjectTaskCrtBl extends BusinessLogicBean{ /**
* @param arg0
*/
public ProjectTaskCrtBl(IDoorDbContext dbCtx) {
super(dbCtx);
} /**
* @param projectTaskCrtRecord
* @return
*/
public List doSelectHead(ProjectTaskCrtRecord wrc) {
List list = null;
log.info("doSelectHead 方法开始");
DataAccess da = null;
Connection conn = null;
//检索task_info表中有无符合条件的记录
List wInfoTodayList = null;
try {
da = new DataAccess();
conn = connectDB();
list = PrjectCommonBl.selectDataOfTask_info1(da, conn, wrc);
return list;
} catch (SQLException e) {
e.printStackTrace();
log.info("doSelectHead 方法结束");
} catch (DBCreateException e) {
e.printStackTrace(); } finally {
closeDB();
}
log.info("doSelectHead 方法结束");
return list;
} /**
* @param projectTaskCrtRecord
* @return
*/
public List doSelectBody(ProjectTaskCrtRecord wrc) {
List list = null;
log.info("doSelectBody 方法开始");
DataAccess da = null;
Connection conn = null;
//检索task_info表中有无符合条件的记录
List wInfoTodayList = null;
try {
da = new DataAccess();
conn = connectDB();
list = PrjectCommonBl.selectDataOfTask_info2(da, conn, wrc);
return list;
} catch (SQLException e) {
e.printStackTrace();
} catch (DBCreateException e) {
e.printStackTrace(); } finally {
closeDB();
}
log.info("doSelectBody 方法结束");
return list;
}
}
* @param da
* @param conn
* @param wrc
* @return
*/
public static List selectDataOfTask_info1(DataAccess da, Connection conn, ProjectTaskCrtRecord projectTaskCrtRecord)
throws DBCreateException, SQLException {
StringBuffer sqlClause = new StringBuffer();
List list = null;
sqlClause
.append("SELECT distinct PROJECT_ID,P_NAME, EMPLOYEE_ID FROM PROJECT_INFO WHERE PROJECT_ID=")
.append("'")
.append(projectTaskCrtRecord.getProject_ID())
.append("'");
try{
list = da.read(conn, sqlClause.toString(), ProjectTaskCrtRecord.class);
return list;
}
catch(Exception e){e.printStackTrace();}
return list;
}
/**
* @param da
* @param conn
* @param wrc
* @return
*/
public static List selectDataOfTask_info2(DataAccess da, Connection conn, ProjectTaskCrtRecord projectTaskCrtRecord)
throws DBCreateException, SQLException{
System.out.println("~~~~~~~~~~~~"+"selectDataOfTask_info2开始执行");
StringBuffer sqlClause = new StringBuffer();
List list = null;
sqlClause
.append("SELECT PROJECT_ID, TASK_ID,TASK_NAME,STAGE_ID FROM TASK_INFO WHERE PROJECT_ID=")
.append("'")
.append(projectTaskCrtRecord.getProject_ID())
.append("'");
try{
list = da.read(conn, sqlClause.toString(), ProjectTaskCrtRecord.class);
return list;
}
catch(Exception e){e.printStackTrace();}
System.out.println("~~~~~~~~~~~~"+"selectDataOfTask_info2执行结束");
return list;
}
2、先把上述代码简化到最小再试试,直到没有问题,再边试边COPY回上述代码。
3、运行地址用ProjectTaskOptAction.do,不用ProjectTaskOptAction或ProjectTaskOptAction.class