xx公司信息管理系統(tǒng)供應商基本資料管理java課程設計報告書

1、 . . . xx公司信息管理系統(tǒng)供應商基本資料管理上課班級：學號：_ ：_1、 子系統(tǒng)功能需求1.1 系統(tǒng)功能描述角色：供應商、公司業(yè)務經(jīng)理功能描述：l 身份驗證功能：1. 供應商只有成功注冊后，才能登錄系統(tǒng)，維護個人基本資料；2. 業(yè)務經(jīng)理必須正確登錄后，才能對供應商基本資料進行維護。其用例圖如1-1所示：圖1-1 身份驗證用例圖l 供應商：1. 可瀏覽個人基本資料；2. 可修改個人基本資料。l 公司業(yè)務經(jīng)理：1. 可維護供應商基本資料（瀏覽、修改、刪除）。其用例圖如1-2所示：圖1-3 供應商基本資料管理用例圖2、 數(shù)據(jù)庫設計2.1 數(shù)據(jù)庫關系表（無）2.2 各表結構1. 供應商表Sup

2、plier_tb3、 詳細設計3.1 類圖設計4、 系統(tǒng)實現(xiàn)4.1 公共模塊實現(xiàn)1、DBCon.java用于數(shù)據(jù)庫連接，并進行數(shù)據(jù)庫表的查詢與修改功能。/* * 創(chuàng)建者：lrw * 數(shù)據(jù)的連接類 */package common;import java.sql.*;publicclass DBCon private Connection con; private Statement stmt;private ResultSet rs;public DBCon()try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFou

3、ndException e1) e1.printStackTrace(); try con = DriverManager.getConnection(jdbc:odbc:db_ilike); catch (SQLException e) e.printStackTrace();try stmt = con.createStatement(); catch (SQLException e) e.printStackTrace();public ResultSet getRs(String sql)try rs = stmt.executeQuery(sql); catch (SQLExcept

4、ion e) e.printStackTrace();returnrs;publicint update(String sql)int n = 0;try n= stmt.executeUpdate(sql); catch (SQLException e) e.printStackTrace();close();return n;publicvoid close()if(rs!=null)try rs.close(); catch (SQLException e) e.printStackTrace();if(stmt!=null)try stmt.close(); catch (SQLExc

5、eption e) e.printStackTrace();if(con!=null)try con.close(); catch (SQLException e) e.printStackTrace();4.2 系統(tǒng)各功能模塊實現(xiàn)4.2.1 登錄功能（略）1. 功能描述：提供登陸的程序供管理員和供應商進行登陸2. 運行界面：3. 關鍵代碼：添加客戶信息%tryrequest.setCharacterEncoding(GBK);String adminID = request.getParameter(adminID);String pas=request.getParameter(admin

6、Pswd);String sql=select adminID from admin_tb where adminPswd=+pas+;ResultSet rs=admin.getRs(sql);if(rs.next()session.setAttribute(ad,adminID);response.sendRedirect(index.htm);elseout.print(alert(用戶名或密碼錯誤!);document.location=login.htm;);catch(Exception e)out.print(alert(用戶名錯誤!);document.location=log

7、in.htm;);%4.2.2 修改供應商基本資料（供應商角色）1. 功能描述：供應商左側(cè)頁面的“基本資料管理”菜單下的“修改基本資料”，則進入圖4-1所示界面。修改基本資料，單擊提交按鈕，顯示圖4-2，表示修改成功。2. 運行界面：供應商維護主界面：圖4-1供應商修改界面：圖4-2供應商修改成功提示：3. 組件圖：4. 關鍵代碼：/* * 創(chuàng)建者：日旺 * 修改數(shù)據(jù)的控制器 */package myilike.crm;import myilike.crm.Supplier;import myilike.crm.SupplierContrl;import java.io.IOException

8、;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet. . Servlet;import javax.servlet. . ServletRequest;import javax.servlet. . ServletResponse;publicclass SupplierEdServlet extends Servlet /* * */privatestaticfinallongserialVersionUID = 92L;publicvoid doGet( Servlet

9、Request request, ServletResponse response)throws ServletException, IOException request.setCharacterEncoding(GBK);response.setCharacterEncoding(GBK);PrintWriter out = response.getWriter();Supplier suppplier = new Supplier();SupplierContrl suppcon = new SupplierContrl();suppplier.setSupplierID(Long.pa

10、rseLong(request.getParameter(supplierID);suppplier.setSupplierName(request.getParameter(supplierName);suppplier.setSupplierAddress(request.getParameter(supplierAddress);suppplier.setSupplierChargeName(request.getParameter(supplierChargeName);suppplier.setSupplierEmail(request.getParameter(supplierEm

11、ail);suppplier.setSupplierPhone(request.getParameter(supplierPhone);suppplier.setSupplier (request.getParameter(supplier );suppplier.setSupplierRemark(request.getParameter(supplierRemark);boolean co = suppcon.updateSupplier(suppplier);if(co) out.println(alert(修改供應商成功);); out.println(javascript:locat

12、ion.href=/ilike/myilike/crm/supplier/supplier_m.jsp;); else out.println(alert(修改供應商失敗);); out.println(javascript:location.href=/ilike/myilike/crm/supplier/supplier_m.jsp;); publicvoid doPost( ServletRequest request, ServletResponse response)throws ServletException, IOException this.doGet(request, re

13、sponse);4.2.4添加供應商基本資料1. 功能描述：添加一個供應商2. 運行界面：3. 組件圖：4. 關鍵代碼：package myilike.crm;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet. . Servlet;import javax.servlet. . ServletRequest;import javax.servl

14、et. . ServletResponse;publicclass SupplierAddservlet extends Servlet privatestaticfinallongserialVersionUID = -34L;publicvoid doGet( ServletRequest request, ServletResponse response)throws ServletException, IOException request.setCharacterEncoding(gb2312);response.setCharacterEncoding(gb2312);PrintW

15、riter out = response.getWriter();Supplier supp = new Supplier();SupplierContrl sa = new SupplierContrl();/supplier.setSupplierID(Long.parseLong(request.getParameter(supplierID);supp.setSupplierName(request.getParameter(supplierName);supp.setSupplierAddress(request.getParameter(supplierAddress);supp.

16、setSupplierChargeName(request.getParameter(supplierChargeName);supp.setSupplierEmail(request.getParameter(supplierEmail);supp.setSupplierPhone(request.getParameter(supplierPhone);supp.setSupplier (request.getParameter(supplier );supp.setSupplierRemark(request.getParameter(supplierRemark);boolean cou

17、nt = sa.insertSupplier(supp);if(count) RequestDispatcher rd = this.getServletContext().getRequestDispatcher(/myilike/crm/supplier/supplier_m.jsp); request.setAttribute(isinsert, 添加成功); rd.forward(request, response); else out.print(alert(添加失敗!);document.location=supplier_m.jsp;); out.println();out.pr

18、intln( A Servlet);out.println( );out.print( This is );out.print(this.getClass();out.println(, using the GET method);out.println( );out.println();out.flush();out.close();publicvoid doPost( ServletRequest request, ServletResponse response)throws ServletException, IOException this.doGet(request, response);r