xx公司信息管理系统-供应商基本资料管理-java课程设计.doc

xx公司信息管理系统供应商基本资料管理上课班级： 学号：_ 姓名：_1、 子系统功能需求1.1 系统功能描述角色：供应商、公司业务经理功能描述：l 身份验证功能：1. 供应商只有成功注册后，才能登录系统，维护个人基本资料；2. 业务经理必须正确登录后，才能对供应商基本资料进行维护。其用例图如1-1所示：图1-1 身份验证用例图l 供应商：1. 可浏览个人基本资料；2. 可修改个人基本资料。l 公司业务经理：1. 可维护供应商基本资料（浏览、修改、删除）。其用例图如1-2所示：图1-3 供应商基本资料管理用例图2、 数据库设计2.1 数据库关系表（无）2.2 各表结构1. 供应商表Supplier_tb3、 详细设计3.1 类图设计4、 系统实现4.1 公共模块实现1、DBCon.java用于数据库连接，并进行数据库表的查询与修改功能。/* * 创建者：lrw * 数据的连接类 */package common;import java.sql.*;public class DBCon private Connection con; private Statement stmt;private ResultSet rs;public DBCon()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();public ResultSet getRs(String sql)try rs = stmt.executeQuery(sql); catch (SQLException e) e.printStackTrace();return rs;public int update(String sql)int n = 0;try n= stmt.executeUpdate(sql); catch (SQLException e) e.printStackTrace();close();return n;public void 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);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=login.htm;);%4.2.2 修改供应商基本资料（供应商角色）1. 功能描述：供应商左侧页面的“基本资料管理”菜单下的“修改基本资料”，则进入图4-1所示界面。修改基本资料，单击提交按钮，显示图4-2，表示修改成功。2. 运行界面：供应商维护主界面：图4-1供应商修改界面：图4-2供应商修改成功提示：3. 组件图：4. 关键代码：/* * 创建者：李日旺 * 修改数据的控制器 */package myilike.crm;import myilike.crm.Supplier;import myilike.crm.SupplierContrl;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class SupplierEdServlet extends HttpServlet /* * */private static final long serialVersionUID = 6257679173235353692L;public void doGet(HttpServletRequest request, HttpServletResponse 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.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);boolean co = 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;); public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doGet(request, response);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.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class SupplierAddservlet extends HttpServlet private static final long serialVersionUID = -7008518788845447834L;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(gb2312);response.setCharacterEncoding(gb2312);PrintWriter 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.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); else out.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();public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException this.doGet(request