📄 tongji_syainservlet.java
字号:
package test;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.Vector;
import java.io.*;
import util.*;
import def.*;
import exce.*;
import entity.*;
/**
* 偙偺僒乕僽儗僢僩偼丄儘僌僀儞僠僃僢僋偺偨傔偺Servlet偱偡丅<br>
* @version 2.00
* @author TOA
*
* 峏怴棜楌
* <ul>
* <li>
* </ul>
*/
public class Tongji_SyainServlet extends HttpServlet
{
/**
*
*/
private static final long serialVersionUID = 1L;
public void service(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException
{
int errf = 0;
Connection con = null;
Status st = new Status();
res.setContentType("text/html;charset=Shift_JIS");
req.setCharacterEncoding("Shift_JIS");
HttpSession session = req.getSession(true);
ChangeField cf = new ChangeField();
//僄儔乕儊僢僙乕僕惗惉梡儊僜僢僪傪掕媊
ErrorMessage em = new ErrorMessage();
//僄儔乕僼僅儚乕僪梡儊僜僢僪傪掕媊
ErrorForward efw = new ErrorForward();
try
{
//DB僆乕僾儞
con = DatabaseConn.getConnection();
Syain_Kyutuketu sk = new Syain_Kyutuketu();
//param偺掕媊
String Kengen_Kubun =(String) session.getAttribute(SISnet.SESSION_ID_STR+".KENGEN_KUBUN");
String userid =(String) session.getAttribute(SISnet.SESSION_ID_STR+".LOGINID");
String bumenno = "";
String useidfrom = userid;
String useidto = userid;
if(!Kengen_Kubun.equals("9")){
bumenno = req.getParameter("bumenNo");
useidfrom = req.getParameter("useidfrom");
useidto = req.getParameter("useidto");
}
String datefromyear = req.getParameter("datefromyear");
String datefrommonth = req.getParameter("datefrommonth");
String datetomonth = req.getParameter("datetomonth");
String datetoyear = req.getParameter("datetoyear");
String datefrom="";
String dateto="";
int start_year = cf.strToInt(datefromyear);
int end_year = cf.strToInt(datetoyear);
int start_month = cf.strToInt(datefrommonth);
int end_month = cf.strToInt(datetomonth);
HejiEntity hj = new HejiEntity();
Vector v = new Vector();
if (start_month<10){
datefrom=start_year+"-"+"0"+start_month+"-"+"01";
}
else{
datefrom=start_year+"-"+start_month+"-"+"01";
}
if (end_month<9){
dateto=end_year+"-"+"0"+(end_month+1)+"-"+"01";
}
else if(end_month==12){
dateto=(end_year+1)+"-01-01";
}
else{
dateto=end_year+"-"+(end_month+1)+"-"+"01";
}
if(Kengen_Kubun.equals("9")){
useidfrom=userid;
useidto = userid;
}
if (cf.strToInt(datefrommonth)<10)
{
datefrommonth="0"+datefrommonth;
}
// Syain_Kyutuketu僆僽僕僃僋僩偺 search()儊僜僢僪傪幚峴偟傑偡丅
Syutuketu_Jouhou_003Entity[] ees = sk.tongjisearch(con,bumenno,useidfrom,useidto,datefrom,dateto);
if(ees.length==1){
hj = new HejiEntity();
hj._bumon_cd = ees[0]._bumon_cd;
hj._bumon_nm = ees[0]._bumon_nm;
hj._user_cd = ees[0]._user_cd;
hj._user_nm = ees[0]._user_nm;
hj._year_month = ees[0]._date_time.toString().substring(0,4)+"/"+ees[0]._date_time.toString().substring(5,7);
hj._tikoku = ees[0]._tikoku;
hj._soutai = ees[0]._soutai;
hj._zangyou = ees[0]._zangyou;
hj._xiujia = ees[0]._xiujia;
hj._syutyou = ees[0]._syutyou;
hj._ketukin = ees[0]._ketukin;
if(ees[0]._tikoku>0){
hj._tikokutimes=1;
}
if(ees[0]._soutai>0){
hj._soutaitimes=1;
}
if(ees[0]._zangyou>0){
hj._zangyoutimes=1;
}
if(ees[0]._xiujia>0){
hj._xiujiatimes=1;
}
if(ees[0]._syutyou>0){
hj._syutyoutimes=1;
}
if(ees[0]._ketukin>0){
hj._ketukintimes=1;
}
v.addElement(hj);
int size = v.size();
HejiEntity[] heji = new HejiEntity[size];
heji = (HejiEntity[])v.toArray(heji);
session.setAttribute(SISnet.SESSION_ID_STR+".HEJI_SYUTUKETU_JOUHOU",heji);
}
else if(ees.length>1){
hj = new HejiEntity();
for(int i=1;i<ees.length;i++){
if(!(ees[i]._user_cd.equals(ees[i-1]._user_cd) && ees[i]._bumon_cd.equals(ees[i-1]._bumon_cd)
&& cf.dateToStr(ees[i]._date_time).substring(0,7).equals(cf.dateToStr(ees[i-1]._date_time).substring(0,7)))){
hj._bumon_cd = ees[i-1]._bumon_cd;
hj._bumon_nm = ees[i-1]._bumon_nm;
hj._user_cd = ees[i-1]._user_cd;
hj._user_nm = ees[i-1]._user_nm;
hj._tikoku = hj._tikoku + ees[i-1]._tikoku;
hj._soutai = hj._soutai + ees[i-1]._soutai;
hj._zangyou = hj._zangyou + ees[i-1]._zangyou;
hj._xiujia = hj._xiujia + ees[i-1]._xiujia;
hj._syutyou = hj._syutyou + ees[i-1]._syutyou;
hj._ketukin = hj._ketukin + ees[i-1]._ketukin;
hj._year_month = ees[i-1]._date_time.toString().substring(0,4)+"/"+ees[i-1]._date_time.toString().substring(5,7);
if(ees[i-1]._tikoku>0){
hj._tikokutimes+=1;
}
if(ees[i-1]._soutai>0){
hj._soutaitimes+=1;
}
if(ees[i-1]._zangyou>0){
hj._zangyoutimes+=1;
}
if(ees[i-1]._xiujia>0){
hj._xiujiatimes+=1;
}
if(ees[i-1]._syutyou>0){
hj._syutyoutimes+=1;
}
if(ees[i-1]._ketukin>0){
hj._ketukintimes+=1;
}
v.addElement(hj);
hj = new HejiEntity();
}
else{
hj._bumon_cd = ees[i-1]._bumon_cd;
hj._bumon_nm = ees[i-1]._bumon_nm;
hj._user_cd = ees[i-1]._user_cd;
hj._user_nm = ees[i-1]._user_nm;
hj._tikoku = hj._tikoku + ees[i-1]._tikoku;
hj._soutai = hj._soutai + ees[i-1]._soutai;
hj._zangyou = hj._zangyou + ees[i-1]._zangyou;
hj._xiujia = hj._xiujia + ees[i-1]._xiujia;
hj._syutyou = hj._syutyou + ees[i-1]._syutyou;
hj._ketukin = hj._ketukin + ees[i-1]._ketukin;
hj._year_month = ees[i-1]._date_time.toString().substring(0,4)+"/"+ees[i-1]._date_time.toString().substring(5,7);
if(ees[i-1]._tikoku>0){
hj._tikokutimes+=1;
}
if(ees[i-1]._soutai>0){
hj._soutaitimes+=1;
}
if(ees[i-1]._zangyou>0){
hj._zangyoutimes+=1;
}
if(ees[i-1]._xiujia>0){
hj._xiujiatimes+=1;
}
if(ees[i-1]._syutyou>0){
hj._syutyoutimes+=1;
}
if(ees[i-1]._ketukin>0){
hj._ketukintimes+=1;
}
}
if(i==ees.length-1){
hj._bumon_cd = ees[i]._bumon_cd;
hj._bumon_nm = ees[i]._bumon_nm;
hj._user_cd = ees[i]._user_cd;
hj._user_nm = ees[i]._user_nm;
hj._tikoku = hj._tikoku + ees[i]._tikoku;
hj._soutai = hj._soutai + ees[i]._soutai;
hj._zangyou = hj._zangyou + ees[i]._zangyou;
hj._xiujia = hj._xiujia + ees[i]._xiujia;
hj._syutyou = hj._syutyou + ees[i]._syutyou;
hj._ketukin = hj._ketukin + ees[i]._ketukin;
hj._year_month = ees[i]._date_time.toString().substring(0,4)+"/"+ees[i]._date_time.toString().substring(5,7);
if(ees[i]._tikoku>0){
hj._tikokutimes+=1;
}
if(ees[i]._soutai>0){
hj._soutaitimes+=1;
}
if(ees[i]._zangyou>0){
hj._zangyoutimes+=1;
}
if(ees[i]._xiujia>0){
hj._xiujiatimes+=1;
}
if(ees[i]._syutyou>0){
hj._syutyoutimes+=1;
}
if(ees[i]._ketukin>0){
hj._ketukintimes+=1;
}
v.addElement(hj);
}
}
int size = v.size();
HejiEntity[] heji = new HejiEntity[size];
heji = (HejiEntity[])v.toArray(heji);
session.setAttribute(SISnet.SESSION_ID_STR+".HEJI_SYUTUKETU_JOUHOU",heji);
}
//僙僢僔儑儞奿擺
session.setAttribute(SISnet.SESSION_ID_STR+".DATA",ees);
session.setAttribute(SISnet.SESSION_ID_STR+".len_tongji",ees.length+"");
session.setAttribute(SISnet.SESSION_ID_STR+".bumenno",bumenno);
session.setAttribute(SISnet.SESSION_ID_STR+".useidfrom",useidfrom);
session.setAttribute(SISnet.SESSION_ID_STR+".useidto",useidto);
session.setAttribute(SISnet.SESSION_ID_STR+".datefromyear",datefromyear);
session.setAttribute(SISnet.SESSION_ID_STR+".datefrommonth",datefrommonth);
session.setAttribute(SISnet.SESSION_ID_STR+".datetoyear",datetoyear);
session.setAttribute(SISnet.SESSION_ID_STR+".datetomonth",datetomonth);
String parm="type=1";
WinParam win[] = new WinParam[2];
win[0]=new WinParam();
win[0].param=parm;
win[0].url="/kaoqin/kqglstm001.jsp";
win[0].tar="_self";
win[1]=new WinParam();
win[1].param=parm;
win[1].url="/kaoqin/kqglstm103.jsp";
win[1].tar="hhhh";
//師偵屇傇URL
//僐儈僢僩張棟傪峴偆
con.commit();
//捈愙JSP傪屇傃弌偡丅乮偨偩屇傇偩偗乯
req.setAttribute("JspParam",win);
RequestDispatcher requestDispatcher=req.getRequestDispatcher("hb/util/Success.jsp");
requestDispatcher.forward(req,res);
}
catch(OriginalException e) {
errf = 1;
st = e.getStatus();
st.status = -5; // Application僄儔乕偵偡傞
if ( st.errno != 71 ) {
st.errno = 110; // Login,Password偑晄惓偱偡
}
String msg = em.getErrorMsg(st,"<BR>");
efw.errForward(1,
msg,
req,
res,
this.getServletContext());
} catch(Exception ee) {
errf = 1;
st.status = -99;
st.errno = 999;
String msg = em.getErrorMsg(st,"<BR>");
efw.errForward(1,
msg,
req,
res,
this.getServletContext());
} finally {
try {
if ( errf == 1 ) {
con.rollback();
}
if ( con != null ) {
con.close();
}
} catch(Exception ee) {
st.status = -99;
st.errno = 999;
String msg = em.getErrorMsg(st,"<BR>");
efw.errForward(1,
msg,
req,
res,
this.getServletContext());
}
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -