軟件中間件技術(shù)UNIT92

1、物品維護(hù)FRAME SRC= NAME=f_1 SCROLLING=no MARGINWIDTH=1 NORESIZEFRAME NAME=f_4 SRC= MARGINWIDTH=1 SCROLLING=NO NORESIZEpackage EEE01;/必要的JAVA Libimport javax.servlet.*;import javax.servlet.http.*;import EEE01.EEE01Bean;/*File Name :EEE0101.javaClass Name :EEE01.EEE0101Date/Programmer :2016/05/14 (zhu)Rep

2、air Date : */public class EEE0101 extends HttpServlet private String JSP_PATH = /; /* 缺省的JSP名 */ private String DEFAULT_JSP = EEE0101f.jsp; /* 啟動(dòng)模式 */ /* 框架啟動(dòng)MODE */ public final static int MODE_FRAME = 0; /* 檢索MODE */ public final static int MODE_GETHEADLIST = 1; /* 多條記錄取得MODE */ public final stati

3、c int MODE_GETLIST = 2; /* 單一記錄取得MODE */ public final static int MODE_GETINFO = 3; /* 追加MODE */ public final static int MODE_INSERT = 4; /* 更新MODE */ public final static int MODE_UPDATE = 5; /* 刪除MODE */ public final static int MODE_DELETE = 6; /* * EEE0101 */ public EEE0101() super(); /* * doAction

4、 */ protected void doPost(HttpServletRequest aRequest, HttpServletResponse aResponse) long mode = 0;long p_mode = 0; String jspName = ; try if (aRequest.getParameter(p_mode) = null) jspName = JSP_PATH + DEFAULT_JSP; else p_mode = new Long(aRequest.getParameter(p_mode).longValue(); jspName = JSP_PATH

5、 + aRequest.getParameter(p_jspname); /- API BEAN EEE01Bean myBean = new EEE01Bean(); switch (int)p_mode) case MODE_FRAME: break; case MODE_GETHEADLIST: myBean.getHeadList(aRequest); aRequest.setAttribute(myBean,myBean); break; case MODE_GETLIST: myBean.getList(aRequest); aRequest.setAttribute(myBean

6、,myBean); break;case MODE_GETINFO: mode = new Long(aRequest.getParameter(mode).longValue(); if (mode !=0) myBean.getInfo(aRequest); else myBean.getHeadList(aRequest); aRequest.setAttribute(myBean,myBean); break; case MODE_INSERT: myBean.Insert(aRequest); aRequest.setAttribute(myBean,myBean); break;

7、case MODE_UPDATE: myBean.Update(aRequest); aRequest.setAttribute(myBean,myBean); break; case MODE_DELETE: myBean.Delete(aRequest); aRequest.setAttribute(myBean,myBean); break; / JSPgetServletConfig().getServletContext().getRequestDispatcher(jspName).forward(aRequest,aResponse); catch(Exception e) Sy

8、stem.out.println(e.getMessage();/ doGet method/public void doGet(HttpServletRequest aRequest, HttpServletResponse aResponse)throws ServletException,java.io.IOExceptiondoPost(aRequest,aResponse); /* * param config * throws ServletException */ public void init(ServletConfig config) throws javax.servle

9、t.ServletException super.init(config); /*功能名 : 物品維護(hù)Class Name :EEE01Bean.classDate/Programmer:2016/05/14 (zhu)Repair Date:*/package EEE01;import java.io.*;import java.sql.*;import java.util.*;import javax.servlet.http.*;public class EEE01Bean /* 單一記錄取得 */ private Hashtable fieldGetData = new Hashtab

10、le(); /* 多條記錄取得 */ private ArrayList fieldGetList = new ArrayList(); /* 多條記錄取得(Head用) */ private ArrayList fieldGetHeadList = new ArrayList();/* 更新?tīng)顟B(tài) */ private int fieldStatus = 0; String sDBDriver = org.gjt.mm.mysql.Driver; /設(shè)置JDBC驅(qū)動(dòng)類(lèi)型String sConnStr = jdbc:mysql:/localhost/test; /設(shè)置連接數(shù)據(jù)庫(kù)服務(wù)器字符串pro

11、tected int oprows = 0;protected Connection conn = null;protected Statement stmt = null;protected ResultSet rs = null;protected ArrayList ResultList = new ArrayList();protected ArrayList ResultList1 = new ArrayList();public EEE01Bean() try Class.forName(sDBDriver); catch(java.lang.ClassNotFoundExcept

12、ion ex) System.out.println(ex.getMessage(); /* * 更新?tīng)顟B(tài)取得 * return int */ public int getStatus() return fieldStatus; /* * 單一記錄取得 * return Hashtable */ public Hashtable getInfo() return fieldGetData; /* * 多條記錄取得 * return ArrayList */ public ArrayList getList() return fieldGetList; public void Delete(HttpServletRequest aRequest) throws SQLException String strSQL = null; int ret = -1; /*- * 物品信息表記錄的刪除 *- */ strSQL = DELETE FROM INFORMATION; strSQL = strSQL + WHERE PARTNO= + aRequest.getParameter(p_partno) + ; try ret = executeUpdate(strSQL); catch(SQLException ex) System.out.println(ex.ge