基于javaweb+mysql的jsp+servlet养老院管理系统(java+jsp+bootstrap+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet养老院管理系统(java+jsp+bootstrap+servlet+mysql)
项目介绍
本系统分为两个角色,一个管理员,一个是护工; 管理员角色主要功能如下: 密码信息管理、系统用户管理(系统用户管理、增加系统用户、系统用户查询)、老人信息管理(老人信息管理、增加老人信息、老人信息查询)、事故记录管理(事故记录管理、增加事故记录、事故记录查询)、请假信息管理(请假信息管理、增加请假信息、请假信息查询)、床位分配管理(床位分配管理、)、入住费用管理、护工薪资管理、护工请假管理
护工角色主要功能如下: 密码信息管理、老人信息查看、请假信息查看、护工薪资查看等;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
技术栈
- 后端:servlet 2. 前端:JSP+css+javascript+bootstrap+jQuery
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中util/DBO.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/yanglaoyuan 登录 管理员账号密码:admin/111 护工账号密码:111/111
package com.util;
public class DBO {
private Connection conn;
private Statement stmt;
private DataSource ds;
public DBO() {
}
/**
* 打开数据库
*/
public void open() {
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/project?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai&autoReconnect=true&failOverReadOnly=false&allowPublicKeyRetrieval=true&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull",
"root", "123456");
stmt = conn.createStatement();
System.out.println("打开数据库连接");
} catch (Exception ex) {
System.err.println("打开数据库时出错: " + ex.getMessage());
}
}
/**
* 关闭数据库,将连接返还给连接池
*/
public void close() {
try {
// connMgr.freeConnection("java", conn);
conn.close();
System.out.println("释放连接");
} catch (SQLException ex) {
System.err.println("返还连接池出错: " + ex.getMessage());
}
}
/**
* 执行查询
*/
public ResultSet executeQuery(String sql) throws SQLException {
ResultSet rs = null;
rs = stmt.executeQuery(sql);
System.out.println("执行查询");
return rs;
}
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
}
else if(method.equals("delsg")){//删除事故记录
String id = request.getParameter("id");
int flag = cBean.comUp("delete from sg where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
}
else if(method.equals("addqj")){ //请假信息
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into qj(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("upqj")){ //修改请假信息
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update qj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("delqj")){//删除请假信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from qj where id='"+id+"'");
if(flag == Constant.SUCCESS){
String xx = request.getParameter("xx");
int flag = cBean.comUp("update qj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("delqj")){//删除请假信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from qj where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("upcw")){
String id=request.getParameter("id");
String cw = request.getParameter("cw");
int flag = cBean.comUp("update lr set cw='"+cw+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
}
}
else if(method.equals("addfy")){ //入住费用
String lr = request.getParameter("lr");
String fy = request.getParameter("fy");
String kc = request.getParameter("kc");
String zt = request.getParameter("zt");
String xx = request.getParameter("xx");
float sji=Float.parseFloat(fy)-Float.parseFloat(kc);
int flag = cBean.comUp("insert into fy(lr,fy,kc,zt,xx,sji) values('"+lr+"','"+fy+"','"+kc+"','"+zt+"','"+xx+"','"+sji+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/fy/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/fy/index.jsp").forward(request, response);
}
public class ComServlet extends HttpServlet {
/**
* Constructor of the object.
*/
public ComServlet() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
else if(method.equals("addqj")){ //请假信息
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into qj(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("upqj")){ //修改请假信息
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update qj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("delqj")){//删除请假信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from qj where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/qj/index.jsp").forward(request, response);
}
}
else if(method.equals("upcw")){
String id=request.getParameter("id");
String cw = request.getParameter("cw");
int flag = cBean.comUp("update lr set cw='"+cw+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/cw/index.jsp").forward(request, response);
}
if(page<=1){
}else{
form3.action="<%=basePath%>admin/lr/index2.jsp?page="+(page-1);
form3.submit();
}
}
function next2(){
var page=parseInt(form3.page.value);
var pageCount=parseInt(form3.pageCount.value);
if(page>=pageCount){
}else{
form3.action="<%=basePath%>admin/lr/index2.jsp?page="+(page+1);
form3.submit();
}
}
function bjump2(){
var pageCount=parseInt(form3.pageCount.value);
if( fIsNumber(form3.busjump.value,"1234567890")!=1 ){
form3.busjump.select();
form3.busjump.focus();
return false;
}
if(pageCount==0){
form3.action="<%=basePath%>admin/lr/index2.jsp?page=1";
form3.submit();
}
else{
form3.action="<%=basePath%>admin/lr/index2.jsp?page="+pageCount;
form3.submit();
}
}
else if(form3.busjump.value<=pageCount){
var page=parseInt(form3.busjump.value);
if(page==0){
form3.action="<%=basePath%>admin/lr/index2.jsp?page="+page;
form3.submit();
}else{
form3.action="<%=basePath%>admin/lr/index2.jsp?page="+page;
form3.submit();
}
}
}
function fIsNumber (sV,sR){
var sTmp;
/**
* MD5密码加密类
*/
public final class MD5 {
public final static String MD5(String s) {
char hexDigits[] = {
'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',
'e', 'f'};
try {
byte[] strTemp = s.getBytes();
MessageDigest mdTemp = MessageDigest.getInstance("MD5");
mdTemp.update(strTemp);
byte[] md = mdTemp.digest();
int j = md.length;
char str[] = new char[j * 2];
int k = 0;
for (int i = 0; i < j; i++) {
byte byte0 = md[i];
str[k++] = hexDigits[byte0 >>> 4 & 0xf];
str[k++] = hexDigits[byte0 & 0xf];
}
return new String(str);
} catch (Exception e) {
return null;
}
}
public static void main(String[] args) {
String s = MD5("123456");
System.out.println(s);
}
}
package com.util;
/**
*
}
else if( ch == '>' ) {
buf.append( ">" );
}
else if(ch=='&'){
buf.append("&");
}
else {
buf.append( ch );
}
}
return buf.toString();
}
}
package com.util;
/**
* 常量
*
*/
public final class Constant {
public final static String CONTENTTYPE="text/html;charset=gb2312";
public final static String CHARACTERENCODING="gb2312";
public final static int DEFAULT_ERROR=0;
public final static int SUCCESS=1;
public final static int NAME_ERROR=2;
public final static int PASSWORD_ERROR=3;
public final static int SYSTEM_ERROR=4;
public final static int SAME_NAME=5;
public final static String NONAME_ERROR="noname_error";
}
package com.util;
/**
* 验证码生成类
*/
public class CheckCode {
public String getCheckCode(){
Random random = new Random();
String sRand="";
for (int i=0;i<4;i++){
String rand=String.valueOf(random.nextInt(10));
sRand+=rand;
}
return sRand;
}
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
package com.bean;
public class ComBean {
private List list;
private ResultSet rs = null;
private int EVERYPAGENUM = 2;
private int count = -1;
private int qq = 0;
//声明时间变量
String date1=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
//分页查询
public void setEVERYPAGENUM(int EVERYPAGENUM){
this.EVERYPAGENUM=EVERYPAGENUM;
}
public int getMessageCount(String sql) { //得到信息总数
DBO dbo=new DBO();
dbo.open();
try {
rs = dbo.executeQuery(sql);
rs.next();
count = rs.getInt(1);
return count;
} catch (SQLException ex) {
ex.printStackTrace();
return -1;
} finally {
dbo.close();
}
}
public int getPageCount() { //得到共多少页(根据每页要显示几条信息)
else if(method.equals("dellr")){//删除老人信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from lr where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
}
}
else if(method.equals("addsg")){ //事故记录
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into sg(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
}
else if(method.equals("upsg")){ //修改事故记录
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update sg set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
}
else if(method.equals("delsg")){//删除事故记录
String id = request.getParameter("id");
int flag = cBean.comUp("delete from sg where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
</head>
<script language="javascript" >
function top2(){
form3.action="<%=basePath%>admin/cw/index.jsp?page=1";
form3.submit();
}
function last2(){
form3.action="<%=basePath%>admin/cw/index.jsp?page=1";
form3.submit();
}else{
form3.action="<%=basePath%>admin/cw/index.jsp?page="+form3.pageCount.value;
form3.submit();
}
}
function pre2(){
var page=parseInt(form3.page.value);
if(page<=1){
}else{
form3.action="<%=basePath%>admin/cw/index.jsp?page="+(page-1);
form3.submit();
}
}
function next2(){
var page=parseInt(form3.page.value);
var pageCount=parseInt(form3.pageCount.value);
if(page>=pageCount){
}else{
form3.action="<%=basePath%>admin/mb/index.jsp?page="+(page+1);
form3.submit();
}
}
function bjump2(){
var pageCount=parseInt(form3.pageCount.value);
if( fIsNumber(form3.busjump.value,"1234567890")!=1 ){
form3.busjump.select();
form3.busjump.focus();
return false;
}
}
else if(method.equals("delm")){//删除系统用户
String id = request.getParameter("id");
int flag=cBean.comUp("delete from admin where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/system/index.jsp").forward(request, response);
}
else {
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/system/index.jsp").forward(request, response);
}
}
else{//无参数传入转到错误页面
request.getRequestDispatcher("error.jsp").forward(request, response);
}
}catch(Exception e){
e.printStackTrace();
request.getRequestDispatcher("error.jsp").forward(request, response);
}
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
package com.bean;
public class ComBean {
String method=request.getParameter("method").trim();
ComBean cBean = new ComBean();
HttpSession session = request.getSession();
if(method.equals("one")){//用户登录
String username = request.getParameter("username");
String password = request.getParameter("password");
String sf = request.getParameter("sf");
String sql="select realname from admin where username='"+username+"' and password='"+password+"' and sf='"+sf+"' ";
String str=cBean.getString(sql);
if(str==null){
request.setAttribute("message", "登录信息错误!");
request.getRequestDispatcher("index.jsp").forward(request, response);
}
else{
session.setAttribute("user", username);
session.setAttribute("sf", sf);
request.getRequestDispatcher("admin/index.jsp").forward(request, response);
}
}
else if(method.equals("uppwd")){//修改密码
String username=(String)session.getAttribute("user");
String oldpwd = request.getParameter("oldpwd");
String newpwd = request.getParameter("newpwd");
String str=cBean.getString("select id from admin where username='"+username+"' and password='"+oldpwd+"'");
if(str==null){
request.setAttribute("message", "原始密码信息错误!");
request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response);
}
else{
int flag=cBean.comUp("update admin set password='"+newpwd+"' where username='"+username+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response);
}
else {
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response);
}
}
}
else if(method.equals("adminexit")){//退出登录
session.removeAttribute("user"); session.removeAttribute("sf");
request.getRequestDispatcher("index.jsp").forward(request, response);
}
else if(method.equals("addm")){//增加系统用户
String username = request.getParameter("username");
String password = request.getParameter("password");
String realname = request.getParameter("realname");
}
try{
byte b[]=str.getBytes("iso-8859-1");
str=new String(b);
str=str.trim();
}catch(Exception e){
e.printStackTrace();
}
return str;
}
}
package com.util;
/**
* MD5密码加密类
*/
public final class MD5 {
public final static String MD5(String s) {
char hexDigits[] = {
'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',
'e', 'f'};
try {
byte[] strTemp = s.getBytes();
MessageDigest mdTemp = MessageDigest.getInstance("MD5");
mdTemp.update(strTemp);
byte[] md = mdTemp.digest();
int j = md.length;
char str[] = new char[j * 2];
int k = 0;
for (int i = 0; i < j; i++) {
byte byte0 = md[i];
str[k++] = hexDigits[byte0 >>> 4 & 0xf];
str[k++] = hexDigits[byte0 & 0xf];
}
return new String(str);
} catch (Exception e) {
}
else if(method.equals("uphgqj")){ //修改请假信息
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update hgqj set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
}
}
else if(method.equals("delhgqj")){//删除请假信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from hgqj where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/hgqj/index.jsp").forward(request, response);
}
}
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
package com.action;
/**
</tr>
<%
cb.setEVERYPAGENUM(12);
String page1=request.getParameter("page");
if(page1==null){
page1="1";
}
session.setAttribute("busMessageCount", cou + "");
session.setAttribute("busPage", page1);
List pagelist1 = cb.getMessage(Integer.parseInt(page1),"select * from lr order by id desc",14);
session.setAttribute("qqq", pagelist1);
session.setAttribute("busPageCount", pageCount + "");
List pagelist3=(ArrayList)session.getAttribute("qqq");
if(!pagelist3.isEmpty()){
for(int i=0;i<pagelist3.size();i++){
List pagelist2 =(ArrayList)pagelist3.get(i);
%>
<tr align="center">
<td nowrap="nowrap"><%=i+1 %></td>
<td nowrap="nowrap"><%=pagelist2.get(1).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(2).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(3).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(4).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(5).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(6).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(7).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(8).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(9).toString() %></td>
function del()
{
pageform.submit();
}
</script>
<%
String message = (String)request.getAttribute("message");
if(message == null){
message = "";
}
if (!message.trim().equals("")){
out.println("<script language='javascript'>");
out.println("alert('"+message+"');");
out.println("</script>");
}
request.removeAttribute("message");
String username=(String)session.getAttribute("user"); String sf=(String)session.getAttribute("sf");
if(username==null){
response.sendRedirect(path+"index.jsp");
}
else{
%>
<body>
<div class="right_cont">
<div style="width:100%;margin:auto;">
<form action="" method="post" name="form3">
<table class="table table-bordered table-striped table-hover">
<tbody>
<tr align="center">
if(page<=1){
}else{
form3.action="<%=basePath%>admin/cw/index.jsp?page="+(page-1);
form3.submit();
}
}
function next2(){
var page=parseInt(form3.page.value);
var pageCount=parseInt(form3.pageCount.value);
if(page>=pageCount){
}else{
form3.action="<%=basePath%>admin/mb/index.jsp?page="+(page+1);
form3.submit();
}
}
function bjump2(){
var pageCount=parseInt(form3.pageCount.value);
if( fIsNumber(form3.busjump.value,"1234567890")!=1 ){
form3.busjump.select();
form3.busjump.focus();
return false;
}
if(pageCount==0){
form3.action="<%=basePath%>admin/cw/index.jsp?page=1";
form3.submit();
}
else{
form3.action="<%=basePath%>admin/cw/index.jsp?page="+pageCount;
form3.submit();
}
}
else if(form3.busjump.value<=pageCount){
var page=parseInt(form3.busjump.value);
if(page==0){
form3.submit();
}
}
}
function fIsNumber (sV,sR){
var sTmp;
if(sV.length==0){ return (false);}
for (var i=0; i < sV.length; i++){
sTmp= sV.substring (i, i+1);
if (sR.indexOf (sTmp, 0)==-1) {return (false);}
}
return (true);
}
function del()
{
pageform.submit();
}
</script>
<%
String message = (String)request.getAttribute("message");
if(message == null){
message = "";
}
if (!message.trim().equals("")){
out.println("<script language='javascript'>");
out.println("alert('"+message+"');");
out.println("</script>");
}
request.removeAttribute("message");
String username=(String)session.getAttribute("user");String sf=(String)session.getAttribute("sf");
if(username==null){
response.sendRedirect(path+"index.jsp");
}
else{
%>
<body>
<div class="right_cont">
<div style="width:100%;margin:auto;">
<form action="" method="post" name="form3">
<table class="table table-bordered table-striped table-hover">
<tbody>
<tr align="center">
",lxr='"+lxr+"',dh='"+dh+"',zz='"+zz+"',cw='"+cw+"',hg='"+hg+"',rz='"+rz+"',cy='"+cy+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
}
}
else if(method.equals("dellr")){//删除老人信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from lr where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/lr/index.jsp").forward(request, response);
}
}
else if(method.equals("addsg")){ //事故记录
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into sg(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
}
else if(method.equals("upsg")){ //修改事故记录
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update sg set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/sg/index.jsp").forward(request, response);
public class CheckCode {
public String getCheckCode(){
Random random = new Random();
String sRand="";
for (int i=0;i<4;i++){
String rand=String.valueOf(random.nextInt(10));
sRand+=rand;
}
return sRand;
}
}
<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312"%>
<jsp:useBean id="cb" scope="page" class="com.bean.ComBean" />
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="<%=basePath %>images/css/bootstrap.css" />
<link rel="stylesheet" href="<%=basePath %>images/css/css.css" />
</head>
<script language="javascript" >
function top2(){
form3.action="<%=basePath%>admin/lr/index.jsp?page=1";
form3.submit();
}
function last2(){
form3.action="<%=basePath%>admin/lr/index.jsp?page=1";
form3.submit();
}else{
form3.action="<%=basePath%>admin/lr/index.jsp?page="+form3.pageCount.value;
form3.submit();
}
}
function pre2(){
var page=parseInt(form3.page.value);
if(page<=1){
}else{
<tbody>
<tr align="center">
</tr>
<%String word=Common.toChineseAndTrim(request.getParameter("word"));
cb.setEVERYPAGENUM(12);
String page1=request.getParameter("page");
if(page1==null){
page1="1";
}
session.setAttribute("busMessageCount", cou + "");
session.setAttribute("busPage", page1);
List pagelist1 = cb.getMessage(Integer.parseInt(page1),"select * from lr where hg = '"+username+"' order by id desc",14);
session.setAttribute("qqq", pagelist1);
session.setAttribute("busPageCount", pageCount + "");
List pagelist3=(ArrayList)session.getAttribute("qqq");
if(!pagelist3.isEmpty()){
for(int i=0;i<pagelist3.size();i++){
List pagelist2 =(ArrayList)pagelist3.get(i);
%>
<tr align="center">
<td nowrap="nowrap"><%=i+1 %></td>
<td nowrap="nowrap"><%=pagelist2.get(1).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(2).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(3).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(4).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(5).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(6).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(7).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(8).toString() %></td>
<td nowrap="nowrap"><%=pagelist2.get(9).toString() %></td>
}
}
}
function fIsNumber (sV,sR){
var sTmp;
if(sV.length==0){ return (false);}
for (var i=0; i < sV.length; i++){
sTmp= sV.substring (i, i+1);
if (sR.indexOf (sTmp, 0)==-1) {return (false);}
}
return (true);
}
function del()
{
pageform.submit();
}
</script>
<%
String message = (String)request.getAttribute("message");
if(message == null){
message = "";
}
if (!message.trim().equals("")){
out.println("<script language='javascript'>");
out.println("alert('"+message+"');");
out.println("</script>");
}
request.removeAttribute("message");
String username=(String)session.getAttribute("user"); String sf=(String)session.getAttribute("sf");
if(username==null){
response.sendRedirect(path+"index.jsp");
}
else{
%>
<body>
<div class="right_cont">
<div style="width:100%;margin:auto;">
<form action="" method="post" name="form3">
<table class="table table-bordered table-striped table-hover">
<tbody>
<tr align="center">
for(int cc=1;cc<=rr;cc++){
list2.add(rs.getString(cc));
}
list.add(list2);
} else {
break; //减少空循环的时间
}
}
return list;
} catch (SQLException ex) {
ex.printStackTrace();
return null;
} finally {
dbo.close();
}
}
public int comUp(String sql){
DBO dbo = new DBO();
dbo.open();
try{
int i = dbo.executeUpdate(sql);
if(i == 1){
return Constant.SUCCESS;
}
else{
return Constant.SYSTEM_ERROR;
}
}catch(Exception e){
e.printStackTrace();
return Constant.SYSTEM_ERROR;
}finally{
dbo.close();
}
}
public List getCom(String sql,int row){
DBO dbo = new DBO();
list = new ArrayList();
dbo.open();
else if(method.equals("uppwd")){//修改密码
String username=(String)session.getAttribute("user");
String oldpwd = request.getParameter("oldpwd");
String newpwd = request.getParameter("newpwd");
String str=cBean.getString("select id from admin where username='"+username+"' and password='"+oldpwd+"'");
if(str==null){
request.setAttribute("message", "原始密码信息错误!");
request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response);
}
else{
int flag=cBean.comUp("update admin set password='"+newpwd+"' where username='"+username+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response);
}
else {
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/system/editpwd.jsp").forward(request, response);
}
}
}
else if(method.equals("adminexit")){//退出登录
session.removeAttribute("user"); session.removeAttribute("sf");
request.getRequestDispatcher("index.jsp").forward(request, response);
}
else if(method.equals("addm")){//增加系统用户
String username = request.getParameter("username");
String password = request.getParameter("password");
String realname = request.getParameter("realname");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String address = request.getParameter("address");
String tel = request.getParameter("tel");
String str=cBean.getString("select id from admin where username='"+username+"'");
if(str==null){
int flag=cBean.comUp("insert into admin(username,password,realname,sex,age,address,tel,addtime ) " +
"values('"+username+"','"+password+"','"+realname+"','"+sex+"','"+age+"','"+address+"','"+tel+"','"+date+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/system/index.jsp").forward(request, response);
}
public static String toChineseAndTrim(String str){
if(str==null){
str="";
}
try{
byte b[]=str.getBytes("iso-8859-1");
str=new String(b);
str=str.trim();
}catch(Exception e){
e.printStackTrace();
}
return str;
}
}
package com.util;
/**
* MD5密码加密类
*/
public final class MD5 {
public final static String MD5(String s) {
char hexDigits[] = {
'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd',
'e', 'f'};
try {
byte[] strTemp = s.getBytes();
MessageDigest mdTemp = MessageDigest.getInstance("MD5");
mdTemp.update(strTemp);
byte[] md = mdTemp.digest();
int j = md.length;
char str[] = new char[j * 2];
int k = 0;
for (int i = 0; i < j; i++) {
byte byte0 = md[i];
str[k++] = hexDigits[byte0 >>> 4 & 0xf];
str[k++] = hexDigits[byte0 & 0xf];
}
return new String(str);