项目编号:BS-GX-039
一,项目简介
本校医务室系统是针对目前在校大学生实际需求,从实际工作出发,对过去的校医院存在的问题进行分析,结合计算机系统的结构、概念、模型、原理、方法,在计算机各种优势的情况下,采用目前最流行的B/S结构和eclipse或者idea编辑器、MySQL数据库设计并实现的 。本校园医务室系统主要包括登录模块、科室信息管理模块、医生信息管理模块、门诊收费管理模块等多个模块。它帮助校医务室实现了信息化、网络化,通过测试,实现了系统设计目标,相比传统的管理模式,本系统合理的利用了网络数据资源,有效的减少了大量的人力投入和工作效率以及学生的就诊记录,大大提高了在校学生看病的效率。
系统功能包含前端用户和后台管理功能,界面设计大方简洁,功能齐全,可以做毕业设计使用。
主要功能模块说明:
- 系统登录:系统登录是管理员访问系统的路口,设计了系统登录界面,包括管理员名、密码和验证码,然后对登录进来的管理员判断身份信息,判断是管理员管理员还是普通用户。
- 管理员管理:管理员可以管理系统的其他普通用户的账号,包括录入新管理员,删除现有的普通用户,修改现有的普通用户的信息,并可以通过管理员名和姓名等关键字搜索普通用户,打印管理员列表页面。修改密码:系统所有管理员(管理员和普通用户)应该都要能修改自己的登录密码,修改后需要重新登录。
- 个人资料管理:只能是普通用户登录成功后,可以修改个人原来的一部分信息,例如修改电话号码、邮箱等。
- 登录情况管理:系统每个管理员应该都能查看个人的历史登录情况,如登录IP、登录时间、登录地址等,防止管理员账号被盗,加强管理员账号安全。
- 操作日志管理:系统每个管理员应该都能查看个人的历史操作日志,如管理员添加了某条数据,历史操作日志需要展示操作人,操作描述,操作时间等信息。防止系统被黑客攻击,加强系统的安全性。
- 科室信息管理:管理员主要针对本校的一个开设科室的管理,可以对科室的添加、查询、修改删除等操作。
- 医生信息管理:校领导可以招聘一些有权威性的医生进行坐诊,然后再通过管理员进行手动添加该医生的信息、也可以对其他医生的查询、修改、删除等操作。
二,环境介绍
JDK | jdk1.8 |
数据库 | mysql5.7 |
应用服务器 | tomcat8.5.31 |
开发工具 | IDEA或eclipse |
后台开发技术 | SSM |
前台技术 | JSP |
三,系统展示
门户首页
医生列表
药品信息
系统简介
后台登录
管理员角色
科室管理
医生信息管理
预约管理
挂号管理
门诊收费管理
药品信息管理
诊断开方管理
门诊取药管理
病历管理
医生后台首页
预约记录
病历查询
就诊信息
诊断开方
四,核心代码
package com.controller;
import java.io.File;
import java.io.IOException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.io.PrintWriter;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
import com.entity.Allusers;
//import com.chengxusheji.po.News;
import com.server.AllusersServer;
import com.util.PageBean;
import net.sf.json.JSONObject;
@Controller
public class AllusersController {
@Resource
private AllusersServer allusersService;
//
@RequestMapping("showAllusers.do")
public String showAllusers(int id,ModelMap map,HttpSession session){
/* Map<String,Object> bmap=new HashMap<String,Object>();
bmap.put("uid", id);*/
// map.put("blist", allusersService.getAll(bmap));
map.put("allusers", allusersService.getById(id));
return "read";
}
@RequestMapping("addAllusers.do")
public String addAllusers(HttpServletRequest request,Allusers allusers,HttpSession session){
Timestamp time=new Timestamp(System.currentTimeMillis());
//Users u=(Users)session.getAttribute("user");
/*if(u==null||u.equals("")){
return "redirect:showIndex.do";
}else{*/
//bbs.setUid(u.getId());
/*bbs.setPubtime(time.toString());
bbs.setIsdel("1");*/
allusers.setAddtime(time.toString().substring(0, 19));
allusersService.add(allusers);
return "redirect:allusersList.do";
/*}*/
}
// 处理编辑
@RequestMapping("doUpdateAllusers.do")
public String doUpdateAllusers(int id,ModelMap map,Allusers allusers){
allusers=allusersService.getById(id);
map.put("allusers", allusers);
return "allusers_updt";
}
//
@RequestMapping("updateAllusers.do")
public String updateAllusers(int id,ModelMap map,Allusers allusers){
allusersService.update(allusers);
return "redirect:allusersList.do";
}
// 所有List
// @RequestMapping("allusersList.do")
// public String allusersList(ModelMap map,HttpSession session){
// map.put("list", allusersService.getAll(null));
// map.put("clist", allusersService.getAll(null));
// return "allusers";
// }
// 分页查询
@RequestMapping("allusersList.do")
public String goodList(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Allusers allusers, String username, String pwd, String cx){
/*if(session.getAttribute("user")==null){
return "login";
}*/
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
Map<String, Object> bmap=new HashMap<String, Object>();
Map<String,Object> cmap=new HashMap<String,Object>();
/*pmap.put("uid", ((Users)session.getAttribute("user")).getId());
bmap.put("uid", ((Users)session.getAttribute("user")).getId());*/
if(username==null||username.equals("")){pmap.put("username", null);cmap.put("username", null);}else{pmap.put("username", username);cmap.put("username", username);}
if(pwd==null||pwd.equals("")){pmap.put("pwd", null);cmap.put("pwd", null);}else{pmap.put("pwd", pwd);cmap.put("pwd", pwd);}
if(cx==null||cx.equals("")){pmap.put("cx", null);cmap.put("cx", null);}else{pmap.put("cx", cx);cmap.put("cx", cx);}
int total=allusersService.getCount(bmap);
pageBean.setTotal(total);
List<Allusers> list=allusersService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "allusers_list";
}
// 分页模糊查询
@RequestMapping("vagueAllusersList.do")
public String vagueAllusersList(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page),PageBean.PAGESIZE);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", pageBean.getPageSize());
Map<String, Object> bmap=new HashMap<String, Object>();
/*pmap.put("uid", ((Users)session.getAttribute("user")).getId());
bmap.put("uid", ((Users)session.getAttribute("user")).getId());*/
int total=allusersService.getCount(bmap);
pageBean.setTotal(total);
List<Allusers> list=allusersService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 2);
return "queryallusers";
}
@RequestMapping("deleteAllusers.do")
public String deleteAllusers(int id){
allusersService.delete(id);
return "redirect:allusersList.do";
}
@RequestMapping("quchongAllusers.do")
public void quchongAllusers(Allusers allusers,HttpServletResponse response){
Map<String,Object> map=new HashMap<String,Object>();
map.put("username", allusers.getUsername());
System.out.println("username==="+allusers.getUsername());
System.out.println("username222==="+allusersService.quchongAllusers(map));
JSONObject obj=new JSONObject();
if(allusersService.quchongAllusers(map)!=null){
obj.put("info", "ng");
}else{
obj.put("info", "username可以用!");
}
response.setContentType("text/html;charset=utf-8");
PrintWriter out=null;
try {
out=response.getWriter();
out.print(obj);
out.flush();
} catch (IOException e) {
e.printStackTrace();
}finally{
out.close();
}
}
@RequestMapping("Alluserslogin.do")
public String checkAllusersLogin(Allusers allusers, HttpSession session) {
Map<String,Object> u=new HashMap<String,Object>();
System.out.println("name===" + allusers.getUsername());
u.put("username",allusers.getUsername());
//u.put("utype", "用户");
//Md5.MD5HexEncode(user.getPassword())
u.put("pwd",allusers.getPwd());
allusers = allusersService.allusersLogin(u);
if (allusers != null) {
session.setAttribute("username", allusers);
System.out.println("username=" + allusers);
session.removeAttribute("suc");
return "redirect:index.do";
} else {
System.out.println("usernafwfwwme=");
session.setAttribute("suc", "登录失败!用户名或密码错误!");
return "login";
}
}
}
package com.controller;
import java.io.File;
import java.io.IOException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.io.PrintWriter;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
import com.entity.Bingli;
import com.server.BingliServer;
import com.util.PageBean;
import net.sf.json.JSONObject;
import com.util.db;
import java.sql.SQLException;
import java.sql.*;
@Controller
public class BingliController {
@Resource
private BingliServer bingliService;
@RequestMapping("addBingli.do")
public String addBingli(HttpServletRequest request,Bingli bingli,HttpSession session) throws SQLException{
Timestamp time=new Timestamp(System.currentTimeMillis());
bingli.setAddtime(time.toString().substring(0, 19));
bingliService.add(bingli);
session.setAttribute("backxx", "添加成功");
session.setAttribute("backurl", request.getHeader("Referer"));
//session.setAttribute("backurl", "bingliList.do");
return "redirect:postback.jsp";
//return "redirect:bingliList.do";
}
// 处理编辑
@RequestMapping("doUpdateBingli.do")
public String doUpdateBingli(int id,ModelMap map,Bingli bingli){
bingli=bingliService.getById(id);
map.put("bingli", bingli);
return "bingli_updt";
}
// 后台详细
@RequestMapping("bingliDetail.do")
public String bingliDetail(int id,ModelMap map,Bingli bingli){
bingli=bingliService.getById(id);
map.put("bingli", bingli);
return "bingli_detail";
}
// 前台详细
@RequestMapping("blDetail.do")
public String blDetail(int id,ModelMap map,Bingli bingli){
bingli=bingliService.getById(id);
map.put("bingli", bingli);
return "binglidetail";
}
//
@RequestMapping("updateBingli.do")
public String updateBingli(int id,ModelMap map,Bingli bingli,HttpServletRequest request,HttpSession session){
bingliService.update(bingli);
session.setAttribute("backxx", "修改成功");
session.setAttribute("backurl", request.getHeader("Referer"));
return "redirect:postback.jsp";
//String url = request.getHeader("Referer");
//return "redirect:"+url;
//return "redirect:bingliList.do";
}
// 分页查询
@RequestMapping("bingliList.do")
public String bingliList(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Bingli bingli, String binglihao, String yonghuming, String xingming, String xingbie, String chushengnianyue, String dianhua, String shenfenzheng, String keshi, String zhuzhiyisheng, String youwuyichuanbing, String bingqingmiaoshu){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(binglihao==null||binglihao.equals("")){pmap.put("binglihao", null);}else{pmap.put("binglihao", binglihao);}
if(yonghuming==null||yonghuming.equals("")){pmap.put("yonghuming", null);}else{pmap.put("yonghuming", yonghuming);}
if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);}
if(xingbie==null||xingbie.equals("")){pmap.put("xingbie", null);}else{pmap.put("xingbie", xingbie);}
if(chushengnianyue==null||chushengnianyue.equals("")){pmap.put("chushengnianyue", null);}else{pmap.put("chushengnianyue", chushengnianyue);}
if(dianhua==null||dianhua.equals("")){pmap.put("dianhua", null);}else{pmap.put("dianhua", dianhua);}
if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", null);}else{pmap.put("shenfenzheng", shenfenzheng);}
if(keshi==null||keshi.equals("")){pmap.put("keshi", null);}else{pmap.put("keshi", keshi);}
if(zhuzhiyisheng==null||zhuzhiyisheng.equals("")){pmap.put("zhuzhiyisheng", null);}else{pmap.put("zhuzhiyisheng", zhuzhiyisheng);}
if(youwuyichuanbing==null||youwuyichuanbing.equals("")){pmap.put("youwuyichuanbing", null);}else{pmap.put("youwuyichuanbing", youwuyichuanbing);}
if(bingqingmiaoshu==null||bingqingmiaoshu.equals("")){pmap.put("bingqingmiaoshu", null);}else{pmap.put("bingqingmiaoshu", bingqingmiaoshu);}
int total=bingliService.getCount(pmap);
pageBean.setTotal(total);
List<Bingli> list=bingliService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "bingli_list";
}
@RequestMapping("bingliList2.do")
public String bingliList2(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Bingli bingli, String binglihao, String yonghuming, String xingming, String xingbie, String chushengnianyue, String dianhua, String shenfenzheng, String keshi, String zhuzhiyisheng, String youwuyichuanbing, String bingqingmiaoshu,HttpServletRequest request){
/*if(session.getAttribute("user")==null){
return "login";
}*/
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
pmap.put("yonghuming", (String)request.getSession().getAttribute("username"));
if(binglihao==null||binglihao.equals("")){pmap.put("binglihao", null);}else{pmap.put("binglihao", binglihao);}
if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);}
if(xingbie==null||xingbie.equals("")){pmap.put("xingbie", null);}else{pmap.put("xingbie", xingbie);}
if(chushengnianyue==null||chushengnianyue.equals("")){pmap.put("chushengnianyue", null);}else{pmap.put("chushengnianyue", chushengnianyue);}
if(dianhua==null||dianhua.equals("")){pmap.put("dianhua", null);}else{pmap.put("dianhua", dianhua);}
if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", null);}else{pmap.put("shenfenzheng", shenfenzheng);}
if(keshi==null||keshi.equals("")){pmap.put("keshi", null);}else{pmap.put("keshi", keshi);}
if(youwuyichuanbing==null||youwuyichuanbing.equals("")){pmap.put("youwuyichuanbing", null);}else{pmap.put("youwuyichuanbing", youwuyichuanbing);}
if(bingqingmiaoshu==null||bingqingmiaoshu.equals("")){pmap.put("bingqingmiaoshu", null);}else{pmap.put("bingqingmiaoshu", bingqingmiaoshu);}
int total=bingliService.getCount(pmap);
pageBean.setTotal(total);
List<Bingli> list=bingliService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "bingli_list2";
}
@RequestMapping("bingliList3.do")
public String bingliList3(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Bingli bingli, String binglihao, String yonghuming, String xingming, String xingbie, String chushengnianyue, String dianhua, String shenfenzheng, String keshi, String zhuzhiyisheng, String youwuyichuanbing, String bingqingmiaoshu,HttpServletRequest request){
/*if(session.getAttribute("user")==null){
return "login";
}*/
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
pmap.put("zhuzhiyisheng", (String)request.getSession().getAttribute("username"));
if(binglihao==null||binglihao.equals("")){pmap.put("binglihao", null);}else{pmap.put("binglihao", binglihao);}
if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);}
if(xingbie==null||xingbie.equals("")){pmap.put("xingbie", null);}else{pmap.put("xingbie", xingbie);}
if(chushengnianyue==null||chushengnianyue.equals("")){pmap.put("chushengnianyue", null);}else{pmap.put("chushengnianyue", chushengnianyue);}
if(dianhua==null||dianhua.equals("")){pmap.put("dianhua", null);}else{pmap.put("dianhua", dianhua);}
if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", null);}else{pmap.put("shenfenzheng", shenfenzheng);}
if(keshi==null||keshi.equals("")){pmap.put("keshi", null);}else{pmap.put("keshi", keshi);}
if(youwuyichuanbing==null||youwuyichuanbing.equals("")){pmap.put("youwuyichuanbing", null);}else{pmap.put("youwuyichuanbing", youwuyichuanbing);}
if(bingqingmiaoshu==null||bingqingmiaoshu.equals("")){pmap.put("bingqingmiaoshu", null);}else{pmap.put("bingqingmiaoshu", bingqingmiaoshu);}
int total=bingliService.getCount(pmap);
pageBean.setTotal(total);
List<Bingli> list=bingliService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "bingli_list3";
}
@RequestMapping("blList.do")
public String blList(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Bingli bingli, String binglihao, String yonghuming, String xingming, String xingbie, String chushengnianyue, String dianhua, String shenfenzheng, String keshi, String zhuzhiyisheng, String youwuyichuanbing, String bingqingmiaoshu){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(binglihao==null||binglihao.equals("")){pmap.put("binglihao", null);}else{pmap.put("binglihao", binglihao);}
if(yonghuming==null||yonghuming.equals("")){pmap.put("yonghuming", null);}else{pmap.put("yonghuming", yonghuming);}
if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);}
if(xingbie==null||xingbie.equals("")){pmap.put("xingbie", null);}else{pmap.put("xingbie", xingbie);}
if(chushengnianyue==null||chushengnianyue.equals("")){pmap.put("chushengnianyue", null);}else{pmap.put("chushengnianyue", chushengnianyue);}
if(dianhua==null||dianhua.equals("")){pmap.put("dianhua", null);}else{pmap.put("dianhua", dianhua);}
if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", null);}else{pmap.put("shenfenzheng", shenfenzheng);}
if(keshi==null||keshi.equals("")){pmap.put("keshi", null);}else{pmap.put("keshi", keshi);}
if(zhuzhiyisheng==null||zhuzhiyisheng.equals("")){pmap.put("zhuzhiyisheng", null);}else{pmap.put("zhuzhiyisheng", zhuzhiyisheng);}
if(youwuyichuanbing==null||youwuyichuanbing.equals("")){pmap.put("youwuyichuanbing", null);}else{pmap.put("youwuyichuanbing", youwuyichuanbing);}
if(bingqingmiaoshu==null||bingqingmiaoshu.equals("")){pmap.put("bingqingmiaoshu", null);}else{pmap.put("bingqingmiaoshu", bingqingmiaoshu);}
int total=bingliService.getCount(pmap);
pageBean.setTotal(total);
List<Bingli> list=bingliService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "binglilist";
}
@RequestMapping("deleteBingli.do")
public String deleteBingli(int id,HttpServletRequest request){
bingliService.delete(id);
String url = request.getHeader("Referer");
return "redirect:"+url;
//return "redirect:bingliList.do";
}
}
五,项目总结
功能较多,就不在一一列举,如有兴趣可私聊获取。另配套毕业论文,不查重可直接使用
在通常情况下,开发人员在设计E-R图时,使用矩形表示实体,在矩形内框中写明实体名(实体名是每个实体的唯一标识)使用椭圆表示属性,并且使用无向边将其与实体连接起来。
管理员名称、密码和权限三个属性。
管理员体ER图如下图所示。
图4-4管理员ER图
科室信息ER图如下图所示。
图4-5科室信息ER图
医生信息ER图如下图所示。
图4-6医生信息ER图
挂号信息ER图如下图所示。
图4-7挂号信息ER图
根据系统各个实体的关系,得出系统的总体ER图。
系统总体ER图如下图所示。
图4-8系统总体ER图
数据库表是数据库重要的组成部分,其实数据库只是一个框架,数据库表才是数据库的本质,本系统数据库表如下:
allusers表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | username | 150 | 255 | |||
3 | pwd | 150 | 255 | |||
4 | cx | 150 | 255 | |||
5 | addtime | DateTime | 8 | 19 |
bingli表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | binglihao | 150 | 255 | |||
3 | yonghuming | 150 | 255 | |||
4 | xingming | 150 | 255 | |||
5 | xingbie | 150 | 255 | |||
6 | chushengnianyue | 150 | 255 | |||
7 | dianhua | 150 | 255 | |||
8 | shenfenzheng | 150 | 255 | |||
9 | keshi | 150 | 255 | |||
10 | zhuzhiyisheng | 150 | 255 | |||
11 | youwuyichuanbing | 150 | 255 | |||
12 | bingqingmiaoshu | 1073741823 | 255 | |||
13 | addtime | DateTime | 8 | 19 |
dx表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | ID | Int | 4 | 10 | ||
2 | leibie | 150 | 255 | |||
3 | content | 1073741823 | 255 |
guahaoxinxi表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | danhao | 150 | 255 | |||
3 | yonghuming | 150 | 255 | |||
4 | xingming | 150 | 255 | |||
5 | xingbie | 150 | 255 | |||
6 | chushengnianyue | 150 | 255 | |||
7 | dianhua | 150 | 255 | |||
8 | shenfenzheng | 150 | 255 | |||
9 | keshi | 150 | 255 | |||
10 | guahaofei | 150 | 255 | |||
11 | beizhu | 1073741823 | 255 | |||
12 | issh | 30 | 255 | |||
13 | addtime | DateTime | 8 | 19 |
keshixinxi表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | keshi | 150 | 255 | |||
3 | addtime | DateTime | 8 | 19 |
liuyanban表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | cheng | 150 | 255 | |||
3 | xingbie | 150 | 255 | |||
4 | | 150 | 255 | |||
5 | youxiang | 150 | 255 | |||
6 | shouji | 150 | 255 | |||
7 | neirong | 1073741823 | 255 | |||
8 | huifuneirong | 1073741823 | 255 | |||
9 | addtime | DateTime | 8 | 19 |
menzhenquyao表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | yaopinbianhao | 150 | 255 | |||
3 | yaopinmingcheng | 150 | 255 | |||
4 | yaopinleibie | 150 | 255 | |||
5 | zhuzhigongxiao | 150 | 255 | |||
6 | shengchanriqi | 150 | 255 | |||
7 | youxiaoqi | 150 | 255 | |||
8 | jiage | 150 | 255 | |||
9 | quyaoshuliang | 150 | 255 | |||
10 | jine | 150 | 255 | |||
11 | quyaoren | 150 | 255 | |||
12 | issh | 30 | 255 | |||
13 | addtime | DateTime | 8 | 19 |
menzhenxinxi表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | danhao | 150 | 255 | |||
3 | yonghuming | 150 | 255 | |||
4 | xingming | 150 | 255 | |||
5 | xingbie | 150 | 255 | |||
6 | chushengnianyue | 150 | 255 | |||
7 | dianhua | 150 | 255 | |||
8 | shenfenzheng | 150 | 255 | |||
9 | keshi | 150 | 255 | |||
10 | zhuzhiyisheng | 150 | 255 | |||
11 | zuozhenshijian | DateTime | 8 | 19 | ||
12 | menzhenfei | 150 | 255 | |||
13 | beizhu | 1073741823 | 255 | |||
14 | issh | 30 | 255 | |||
15 | addtime | DateTime | 8 | 19 |
xinwentongzhi表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | biaoti | 150 | 255 | |||
3 | leibie | 150 | 255 | |||
4 | neirong | 1073741823 | 255 | |||
5 | shouyetupian | 150 | 255 | |||
6 | dianjilv | 150 | 255 | |||
7 | tianjiaren | 150 | 255 | |||
8 | addtime | DateTime | 8 | 19 | ||
9 | ddd | DateTime | 8 | 19 |
yaopinxinxi表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | yaopinbianhao | 150 | 255 | |||
3 | yaopinmingcheng | 150 | 255 | |||
4 | yaopinleibie | 150 | 255 | |||
5 | zhuzhigongxiao | 150 | 255 | |||
6 | shengchanriqi | DateTime | 8 | 19 | ||
7 | youxiaoqi | DateTime | 8 | 19 | ||
8 | jiage | 150 | 255 | |||
9 | zhaopian | 150 | 255 | |||
10 | yaopinshuoming | 1073741823 | 255 | |||
11 | addtime | DateTime | 8 | 19 |
yishengxinxi表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | yishenggonghao | 150 | 255 | |||
3 | mima | 150 | 255 | |||
4 | yishengxingming | 150 | 255 | |||
5 | xingbie | 150 | 255 | |||
6 | nianling | 150 | 255 | |||
7 | zhicheng | 150 | 255 | |||
8 | keshi | 150 | 255 | |||
9 | lianxifangshi | 150 | 255 | |||
10 | youxiang | 150 | 255 | |||
11 | zhaopian | 150 | 255 | |||
12 | yishengjianjie | 1073741823 | 255 | |||
13 | paibanbiao | 1073741823 | 255 | |||
14 | addtime | DateTime | 8 | 19 |
yonghuzhuce表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | yonghuming | 150 | 255 | |||
3 | mima | 150 | 255 | |||
4 | xingming | 150 | 255 | |||
5 | xingbie | 150 | 255 | |||
6 | chushengnianyue | DateTime | 8 | 19 | ||
7 | | 150 | 255 | |||
8 | youxiang | 150 | 255 | |||
9 | shouji | 150 | 255 | |||
10 | shenfenzheng | 150 | 255 | |||
11 | touxiang | 150 | 255 | |||
12 | dizhi | 150 | 255 | |||
13 | beizhu | 1073741823 | 255 | |||
14 | issh | 30 | 255 | |||
15 | addtime | DateTime | 8 | 19 |
youqinglianjie表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | ID | Int | 4 | 10 | ||
2 | wangzhanmingcheng | 150 | 255 | |||
3 | wangzhi | 150 | 255 | |||
4 | addtime | DateTime | 8 | 19 | ||
5 | LOGO | 1073741823 | 255 |
yuyuejilu表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | yuyuedanhao | 150 | 255 | |||
3 | yishenggonghao | 150 | 255 | |||
4 | yishengxingming | 150 | 255 | |||
5 | xingbie | 150 | 255 | |||
6 | nianling | 150 | 255 | |||
7 | zhicheng | 150 | 255 | |||
8 | keshi | 150 | 255 | |||
9 | lianxifangshi | 150 | 255 | |||
10 | yuyueshijian | DateTime | 8 | 19 | ||
11 | yuyueren | 150 | 255 | |||
12 | issh | 30 | 255 | |||
13 | addtime | DateTime | 8 | 19 |
zhenduankaifang表
序号 | 字段名称 | 字段类型 | 大小 | 允许为空 | 最大长度 | 备注 |
1 | id | Int | 4 | 10 | ||
2 | yonghuming | 150 | 255 | |||
3 | xingming | 150 | 255 | |||
4 | xingbie | 150 | 255 | |||
5 | chushengnianyue | 150 | 255 | |||
6 | dianhua | 150 | 255 | |||
7 | shenfenzheng | 150 | 255 | |||
8 | keshi | 150 | 255 | |||
9 | zuozhenshijian | 150 | 255 | |||
10 | zhenduanjieguo | 1073741823 | 255 | |||
11 | kaifang | 1073741823 | 255 | |||
12 | zhuzhiyisheng | 150 | 255 | |||
13 | addtime | DateTime | 8 | 19 |