目录
0、效果展示
1、概述
2、搭建环境
本文以实现一个食品安全管理系统为目标，从环境搭建到编码实现全过程讲述
我们使用javaweb、J2EE来构建食品安全管理系统，环境使用最新版jdk和tomcat，配合mysql数据库
开发工具使用idea（也可以使用eclipse），数据库管理工具使用Navicat Premium
开发框架使用JavaBean Servlet MVC结构；
没有使用SSH（Struts+Spring+Hibernate）或SSM（Spring+SpringMVC+MyBatis），这两个框架我们在别的项目中再介绍开发过程
3、数据表结构
表2gongyingshang 供应商表
| 名称 | 类型 | 说明 |
| id | int | 编号 |
| mingcheng | varchar(50) | 名称 |
| dizhi | varchar(50) | 地址 |
| lianxiren | varchar(50) | 联系人 |
| dianhua | varchar(50) | 电话 |
| youbian | varchar(50) | 邮编 |
| chuanzhen | varchar(50) | 传真 |
| youxiang | varchar(50) | 邮箱 |
| kahuhang | varchar(50) | 开户行 |
| zhanghao | varchar(50) | 账户 |
| type | varchar(50) | 类型 |
表3goods 食品信息表
| 名称 | 类型 | 说明 |
| id | int | 编号 |
| catelog_id | int | 分类编号 |
| name | varchar(50) | 名称 |
| chandi | varchar(50) | 词典 |
| danwei | varchar(50) | 单位 |
| guige | varchar(50) | 规格 |
| beizhu | varchar(50) | 备注 |
| photo | varchar(150) | 图片 |
4、后端代码示例
package com.action;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.DB;
import com.orm.Shengchan;
public class shengchan_servlet extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException
{
String type=req.getParameter("type");
if(type.endsWith("shengchanAdd"))
{
shengchanAdd(req, res);
}
if(type.endsWith("shengchanEdit"))
{
shengchanEdit(req, res);
}
if(type.endsWith("shengchanMana"))
{
shengchanMana(req, res);
}
if(type.endsWith("shengchanDel"))
{
shengchanDel(req, res);
}
if(type.endsWith("shengchanQuanxian"))
{
shengchanQuanxian(req, res);
}
}
public void shengchanAdd(HttpServletRequest req,HttpServletResponse res)
{
String name=req.getParameter("name");
String sex=req.getParameter("sex");
String phone=req.getParameter("phone");
String tel=req.getParameter("tel");
String address=req.getParameter("address");
String gsmc=req.getParameter("gsmc");
String sql="insert into t_shengchan (`name`, `sex`, `phone`, `tel`, `address`, `gsmc`, `quanxian`, `loginName`, `loginPw`, `del`) values(?,?,?,?,?,?,?,?,?,?)";
Object[] params={name,sex,phone,tel,address,gsmc,0,"","","no"};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "shengchan?type=shengchanMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void shengchanEdit(HttpServletRequest req,HttpServletResponse res)
{
String name=req.getParameter("name");
String sex=req.getParameter("sex");
String phone=req.getParameter("phone");
String tel=req.getParameter("tel");
String address=req.getParameter("address");
String gsmc=req.getParameter("gsmc");
String sql="update t_shengchan set name='"+name+"',sex='"+sex+"',phone='"+phone+"',tel='"+tel+"',address='"+address+"',gsmc='"+gsmc+"' where id="+Integer.parseInt(req.getParameter("id"));
Object[] params={};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "shengchan?type=shengchanMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void shengchanDel(HttpServletRequest req,HttpServletResponse res)
{
int id=Integer.parseInt(req.getParameter("id"));
String sql="update t_shengchan set del=? where id=?";
Object[] params={"yes",id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "shengchan?type=shengchanMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void shengchanMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
String page1=req.getParameter("page");
if(page1==null){
page1="1";
}
//分页设置
int EVERYPAGENUM=10;//每页条数
int page=Integer.parseInt(page1); //传递过来的当前页
int cou = 1;//得到信息总数
int pagecount=1; //总页数
String sql1="select count(*) as cou from t_shengchan where del='no'";
if(req.getParameter("mingcheng")!=null) sql1+=" and (gsmc like '%"+req.getParameter("mingcheng").trim()+"%' or id like '%"+req.getParameter("mingcheng").trim()+"%')";
Object[] params1={};
DB mydb1=new DB();
try
{
mydb1.doPstm(sql1, params1);
ResultSet rs=mydb1.getRs();
while(rs.next())
{
cou= rs.getInt("cou");
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb1.closed();
if (cou % EVERYPAGENUM == 0) {
pagecount= cou / EVERYPAGENUM;
} else {
pagecount=cou / EVERYPAGENUM + 1;
}
req.setAttribute("EVERYPAGENUM", EVERYPAGENUM);
req.setAttribute("page", page);
req.setAttribute("cou", cou);
req.setAttribute("pagecount", pagecount);
List shengchanList=new ArrayList();
String sql="select * from t_shengchan where del='no'";
if(req.getParameter("mingcheng")!=null) sql+=" and (gsmc like '%"+req.getParameter("mingcheng").trim()+"%' or id like '%"+req.getParameter("mingcheng").trim()+"%')";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) {
rs.next();
}
for (int t = 0; t < EVERYPAGENUM; t++) {
if (rs.next()) {
Shengchan shengchan=new Shengchan();
shengchan.setId(rs.getInt("id"));
shengchan.setName(rs.getString("name"));
shengchan.setSex(rs.getString("sex"));
shengchan.setPhone(rs.getString("phone"));
shengchan.setTel(rs.getString("tel"));
shengchan.setAddress(rs.getString("address"));
shengchan.setGsmc(rs.getString("gsmc"));
shengchan.setQuanxian(rs.getInt("quanxian"));
shengchan.setLoginName(rs.getString("loginName"));
shengchan.setLoginPw(rs.getString("loginPw"));
shengchanList.add(shengchan);
} else {
break; //减少空循环的时间
}
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
req.setAttribute("shengchanList", shengchanList);
req.getRequestDispatcher("admin/shengchan/shengchanMana.jsp").forward(req, res);
}
public void shengchanQuanxian(HttpServletRequest req,HttpServletResponse res)
{
int id=Integer.parseInt(req.getParameter("id"));
int quanxian=Integer.parseInt(req.getParameter("quanxian"));
String loginName=req.getParameter("loginName");
String loginPw=req.getParameter("loginPw");
String sql="update t_shengchan set quanxian=?,loginName=?,loginPw=? where id="+id;
Object[] params={quanxian,loginName,loginPw};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
req.setAttribute("message", "操作成功");
req.setAttribute("path", "shengchan?type=shengchanMana");
String targetURL = "/common/success.jsp";
dispatch(targetURL, req, res);
}
public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response)
{
RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
try
{
dispatch.forward(request, response);
return;
}
catch (ServletException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void destroy()
{
}
}
5、前端代码示例
<%@ page language="java" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ page isELIgnored="false" %>
<%
String path = request.getContextPath();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="stylesheet" type="text/css" href="<%=path %>/css/base.css" />
<script language="javascript">
function shengchanDel(id)
{
if(confirm('您确定删除吗？'))
{
window.location.href="<%=path %>/shengchan?type=shengchanDel&id="+id;
}
}
function shengchanQuanxian(id)
{
window.location.href="<%=path %>/admin/shengchan/shengchanQuanxian.jsp?id="+id;
}
function shengchanAdd()
{
var url="<%=path %>/admin/shengchan/shengchanAdd.jsp";
//var n="";
//var w="480px";
//var h="500px";
//var s="resizable:no;help:no;status:no;scroll:yes";
//window.location.href=url;
window.location.href=url;
}
</script>
</head>
<body leftmargin="2" topmargin="2" background='<%=path %>/images/allbg.gif'>
<table width='98%' border='0'style="margin-top:8px;margin-left: 5px;">
<tr>
<td>
<input type="button" value="添加" style="width: 80px;" onclick="shengchanAdd()" />
</td>
<td><form action="<%=path %>/shengchan?type=shengchanMana" name="formAdd" method="post">
生产厂商名称或编码：
<input type="text" name="mingcheng"/>
<input type="submit" value="查询"/>
</form></td>
</tr>
</table>
<table width="98%" border="0" cellpadding="1" cellspacing="1" bgcolor="#D1DDAA" align="center" style="margin-top:8px">
<tr bgcolor="#E7E7E7">
<td height="14" colspan="8" class='title'> 生产厂商管理 </td>
</tr>
<tr align="center" bgcolor="#FAFAF1" height="22">
<td >编码</td>
<td >公司名称</td>
<td >联系人姓名</td>
<td >联系人性别</td>
<td >传真</td>
<td >电话</td>
<td >地址</td>
<td >选项</td>
</tr>
<c:forEach items="${requestScope.shengchanList}" var="shengchan">
<tr align='center' bgcolor="#FFFFFF" onMouseMove="javascript:this.bgColor='red';" onMouseOut="javascript:this.bgColor='#FFFFFF';" height="22">
<td bgcolor="#FFFFFF" align="center">
${shengchan.id}
</td>
<td bgcolor="#FFFFFF" align="center">
${shengchan.gsmc}
</td>
<td bgcolor="#FFFFFF" align="center">
${shengchan.name}
</td>
<td bgcolor="#FFFFFF" align="center">
${shengchan.sex}
</td>
<td bgcolor="#FFFFFF" align="center">
${shengchan.phone}
</td>
<td bgcolor="#FFFFFF" align="center">
${shengchan.tel}
</td>
<td bgcolor="#FFFFFF" align="center">
${shengchan.address}
</td>
<td bgcolor="#FFFFFF" align="center">
<form action="<%=path %>/admin/shengchan/shengchanEdit.jsp" name="" method="post">
<input type="button" value="删除" onclick="shengchanDel(${shengchan.id})"/>
<input type="hidden" name="id" value="${shengchan.id}"/>
<input type="hidden" name="name" value="${shengchan.name}"/>
<input type="hidden" name="sex" value="${shengchan.sex}"/>
<input type="hidden" name="phone" value="${shengchan.phone}"/>
<input type="hidden" name="tel" value="${shengchan.tel}"/>
<input type="hidden" name="address" value="${shengchan.address}"/>
<input type="hidden" name="gsmc" value="${shengchan.gsmc}"/>
<input type="submit" value="修改"/>
</form>
</td>
</tr>
</c:forEach>
</table>
<table width='98%' border='0'style="margin-top:8px;margin-left: 5px;">
<TR align="right">
<TD ><form action="" method="post" name="formpage">
<input type="hidden" name="pageCount" value="${requestScope.pagecount}" />
<!--//用于给上面javascript传值-->
<input type="hidden" name="page" value="${requestScope.page}" />
<!--//用于给上面javascript传值-->
<input type="hidden" name="jumpurl" value="<%=path%>/shengchan?type=shengchanMana&" />
<!--//用于给上面javascript传值-->
<a href="#" onClick="PageTop()"><strong>首页</strong></a>
<a href="#" onClick='PagePre()'><strong>上一页</strong></a>
共${requestScope.cou}条记录,
共计${requestScope.pagecount}页,
当前第${requestScope.page}页
<a href="#" onClick="PageNext()"><strong>下一页</strong></a>
<a href="#" onClick="PageLast()"><strong>尾页</strong></a> 第
<input name="busjump" type="text" size="3" value="${requestScope.page}" style=" width:15px"/>
页<a href="#" onClick="bjump()"><strong>跳转</strong></a>
</form>
<script type="text/javascript" src="<%=path%>/js/page.js"></script></TD>
</TR>
</table>
</body>
</html>
509
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
