xx公司信息管理系统供应商基本资料管理java课程设计报告书

xx 公司信息管理系统供应商基本资料管理上课班级：学号： _姓名： _1、子系统功能需求1.1系统功能描述角色：供应商、公司业务经理功能描述：身份验证功能：1. 供应商只有成功注册后，才能登录系统，维护个人基本资料；2. 业务经理必须正确登录后，才能对供应商基本资料进行维护。其用例图如 1-1 所示：图 1-1身份验证用例图供应商：1. 可浏览个人基本资料；2. 可修改个人基本资料。公司业务经理：1.可维护供应商基本资料（浏览、修改、删除）。其用例图如1-2 所示：图 1-3供应商基本资料管理用例图2、数据库设计2.1数据库关系表（无） 2.2各表结构1.供应商表Supplier_tb3、详细设计3.1类图设计4、系统实现4.1公共模块实现1 、 DBCon.java用于数据库连接，并进行数据库表的查询与修改功能。/* 创建者： lrw* 数据的连接类*/packagecommon;importjava.sql.*;publicclassDBCon privateConnectionprivateStatementprivateResultSetcon ;stmt ;rs ;publicDBCon()try Class. forName (sun.jdbc.odbc.JdbcOdbcDriver catch(ClassNotFoundException 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();publicResultSet getRs(String sql)try rs = stmt .executeQuery(sql); catch(SQLException e) e.printStackTrace();returnrs ;publicint update(String sql)int n = 0;try n= stmt .executeUpdate(sql); catch(SQLException e) e.printStackTrace();close();returnn;publicvoid close()if (rs !=null)try rs .close(); catch(SQLException e) e.printStackTrace();if (stmt != null )try stmt .close(); catch(SQLException e) e.printStackTrace();if (con != null )try con .close(); catch(SQLException e) e.printStackTrace();4.2系统各功能模块实现4.2.1登录功能（略）1. 功能描述：提供登陆的程序供管理员和供应商进行登陆2. 运行界面：3. 关键代码： 添加客户信息%tryrequest.setCharacterEncoding(GBK);String adminID = request.getParameter(adminID);String pas=request.getParameter(adminPswd);Stringsql=selectadminIDfromadminPswd=+pas+;ResultSet rs=admin.getRs(sql);if(rs.next()session.setAttribute(ad,adminID);response.sendRedirect(index.htm);elseout.print(alert(用户admin_tb名或密码where错误!);document.location=login.htm;);catch(Exception e)out.print(alert(用户名错误!);document.location=login.htm;);%4.2.2修改供应商基本资料（供应商角色）1.功能描述：供应商左侧页面的“基本资料管理”菜单下的“修改基本资料 ”，则进入图4-1所示界面。修改基本资料，单击提交按钮，显示图4-2，表示修改成功。2.运行界面：供应商维护主界面：图 4-1供应商修改界面：图 4-2供应商修改成功提示：3. 组件图：4. 关键代码：/* 创建者：李日旺* 修改数据的控制器*/packagemyilike.crm;importmyilike.crm.Supplier;importmyilike.crm.SupplierContrl;importjava.io.IOException;importjava.io.PrintWriter;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;publicclassSupplierEdServletextendsHttpServlet /*/private static final long serialVersionUID= 6257679173235353692L;publicvoid doGet(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException request.setCharacterEncoding(GBK );response.setCharacterEncoding(GBK );PrintWriter out = response.getWriter();Supplier suppplier =new Supplier();SupplierContrl suppcon =new SupplierContrl();suppplier.setSupplierID(Long.parseLong (request.getParameter(supplierID);suppplier.setSupplierName(request.getParameter(supplierName);suppplier.setSupplierAddress(request.getParameter(supplierAddress);suppplier.setSupplierChargeName(request.getParameter(supplierChargeName);suppplier.setSupplierEmail(request.getParameter(supplierEmail);suppplier.setSupplierPhone(request.getParameter(supplierPhone);suppplier.setSupplierQQ(request.getParameter(supplierQQ);suppplier.setSupplierRemark(request.getParameter(supplierRemark);booleanco = suppcon.updateSupplier(suppplier);if (co) out.println(alert(修改供应商成功););out.println(javascript:location.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(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException this .doGet(request, response);4.2.4添加供应商基本资料1. 功能描述：添加一个供应商2. 运行界面：3. 组件图：4. 关键代码：packagemyilike.crm;importjava.io.IOException;importjava.io.PrintWriter;importjavax.servlet.RequestDispatcher;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;publicclassSupplierAddservletextendsHttpServlet privatestatic final longserialVersionUID= -7008518788845447834L;publicvoid doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(gb2312);response.setCharacterEncoding(gb2312);PrintWriter out = response.getWriter();Supplier supp =newSupplier();SupplierContrl sa =newSupplierContrl();/supplier.setSupplierID(Long.parseLong(request.getParameter(supplierID);supp.setSupplierName(request.getParameter(supplierName);supp.setSupplierAddress(request.getParameter(supplierAddress);supp.setSupplierChargeName(request.getParameter(supplierChargeName);supp.setSupplierEmail(request.getParameter(supplierEmail);supp.setSupplierPhone(request.getParameter(supplierPhone);supp.setSupplierQQ(request.getParameter(supplierQQ );supp.setSupplierRemark(request.getParameter(supplierRemark);boolean count = sa.insertSupplier(supp);if (count) RequestDispatcher rd =this .getServletContext().getRequestDispatcher(/myilike/crm/supplier/supplier_m.jsp );request.setAttribute(isinsert ,添加成功 );rd.forward(request, response);elseout.print(alert(添加失败!);document.location=supplier_m.jsp;);out.println();out.println(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(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException this .doGet(request, response);response.setContentType(text/html);PrintWriter out = response.getWriter();out.println();out.println( );out.println(A Servlet);out.println();out.print(This is );out.print(this.getClass();out.println(, using the POST method);out.println();out.println();out.flush();out.close();