?? browsepaymentaction.java
字號:
package com.ICT.AFC.contractmoney.payment;
import org.apache.struts.action.*;
import java.util.*;
import javax.servlet.http.*;
import com.ICT.AFC.DB.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;
import javax.sql.*;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
public class browsePaymentAction
extends Action {
public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest httpServletRequest,
HttpServletResponse httpServletResponse) {
/**@todo: complete the business logic here, this is just a skeleton.*/
browsePaymentActionForm browsePaymentActionForm = (browsePaymentActionForm)
actionForm;
String PageForward = "browsePayment";
HttpSession session = httpServletRequest.getSession();
ServletContext context = servlet.getServletContext();
DataSource dataSource = (DataSource) context.getAttribute("contract");
DB db = new DB(dataSource);
String contractID=httpServletRequest.getParameter("contractID");
try {
Vector browseResult = browseOperate(db, contractID);
if (browseResult.size() != 0) {
session.setAttribute("browseResult", browseResult);
}
else {
session.setAttribute("browseResult", browseResult);
}
}
catch (Exception e) {
}
finally {
//throw new java.lang.UnsupportedOperationException("Method perform() not yet implemented.");
return (actionMapping.findForward(PageForward));
}
//throw new java.lang.UnsupportedOperationException("Method perform() not yet implemented.");
}
public Vector browseOperate(DB db, String strstr) throws
Exception {
String strSql = "SELECT * FROM M_MONEY WHERE CONTRACTID=" +
strstr + " and CONTRACTTYPE='付款'";
ResultSet rs = db.OpenSql(strSql);
Vector ls = new Vector();
for (; rs.next(); ) { //Vector ls=new Vector();
browsePaymentActionForm browsePaymentActionForm = new
browsePaymentActionForm();
browsePaymentActionForm.setPaymentContractID(strstr);
browsePaymentActionForm.setPaymentDate(rs.getString("PAYDATE"));
if (rs.getString("UPLOADPATH") == null)
browsePaymentActionForm.setPaymentFile("nullnull");
else
browsePaymentActionForm.setPaymentFile(rs.getString("UPLOADPATH"));
browsePaymentActionForm.setPaymentID(rs.getString("PAYID"));
browsePaymentActionForm.setPaymentMoney(rs.getString("MONEY"));
browsePaymentActionForm.setPaymentRECTime(rs.getString("RECORDTIME"));
if (rs.getString("REMARK") == null) {
browsePaymentActionForm.setPaymentRemark("無");
}
else {
browsePaymentActionForm.setPaymentRemark(rs.getString("REMARK"));
}
browsePaymentActionForm.setPaymentWriter(rs.getString("WRITER"));
ls.add(browsePaymentActionForm);
}
rs.close();
db.close();
return ls;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -