部门管理代码

一、servlet1、删除功能代码：package com.dept.servlet;import java.io.IOException; io异常包import java.io.PrintWriter; 打印字符包import java.io.UnsupportedEncodingException;import java.sql.SQLException; sql异常包import java.sql.Statement; sql 下的statementimport javax.servlet.ServletException; servlet下面的servlet异常包import javax.servlet.http.HttpServlet; http协议下面的HttpServlet包import javax.servlet.http.HttpServletRequest; HTTP协议下面的请求包import javax.servlet.http.HttpServletResponse; http协议下的响应包import com.model.tools.JDBConnection; 连接数据库包public class DepDeleteSevlet extends HttpServlet {public void doGet(HttpServletRequest request, HttpServletResponse response) 服务器请求类响应类throws ServletException, IOException {doPost(request,response); 接受网页提交的如表单等信息，比较安全}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType("text/html;charset=GBK ");响应内容类型以txt 和html显示出来，用GBK字符集响应出来request.setCharacterEncoding("GBK"); 客户端以GBK这种字符集发出请求PrintWriter out = response.getWriter(); 响应的信息存放于outString Dep_ID=request.getParameter("Dep_ID");从页面上获得参数部门号赋给Dep_ID//创建数据库连接java.sql.Connection conn; 调用sql里connection类接口，声明了conn接口try {conn = JDBConnection.getConnection();//JDBConnection类调用getConnection方法赋给connStringBuffer sql=new StringBuffer(); 带缓冲区的字符串类，声明sql变量，给sql的空间sql.append("delete from departmentinfo whereDep_ID='"+Dep_ID+"' ");//作用发送sql到数据库端Statement st=conn.createStatement();int count=st.executeUpdate(sql.toString());if(count>0){request.getRequestDispatcher("dept/DepSuccess.jsp").forward(request, response);st.close();conn.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}2、修改和添加功能代码：/** To change this template, choose Tools | Templates* and open the template in the editor.*/package com.dept.servlet;import java.io.*;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.servlet.ServletException;import javax.servlet.http.*;import com.model.tools.*;public class DepInfoServlet extends HttpServlet {private int method;// private UserInfo userInfo = null;//// private UserInfoDaoImp userInfoDao = null;private HttpSession session = null;public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {method = Integer.parseInt(request.getParameter("method"));if (method == 1) {this.DepAdd(request, response);}if (method == 2) {this.DepUpdate(request, response);}}private void DepUpdate(HttpServletRequest request,HttpServletResponse response) throwsUnsupportedEncodingException,ServletException, IOException {request.setCharacterEncoding("GBK");response.setContentType("text/html;charset=GBK ");PrintWriter out=response.getWriter();String Dep_ID = newString(request.getParameter("Dep_ID").getBytes("ISO8859-1"),"GBK");String Dep_Name =newString( request.getParameter("Dep_Name").getBytes("ISO8859-1"),"GBK");String Dep_About = newString(request.getParameter("Dep_About").getBytes("ISO8859-1"),"GBK");String Dep_Leader = new String(request.getParameter("Dep_Leader").getBytes("ISO8859-1"),"GBK");boolean isTrue=false;// 创建数据库连接java.sql.Connection conn;try {conn = JDBConnection.getConnection();StringBuffer sql = new StringBuffer();Statement st = conn.createStatement();sql.append("update departmentinfo set Dep_Name=");sql.append("'" + Dep_Name + "',Dep_About=");sql.append("'" + Dep_About + "',Dep_Leader=");sql.append("'" + Dep_Leader + "'where Dep_ID=");sql.append("'" + Dep_ID + "'");// 作用发送sql到数据库端int count = st.executeUpdate(sql.toString());if (count > 0) {request.getRequestDispatcher("dept/DepSuccess.jsp").forward(request, response);st.close();conn.close();}else{out.print("<script type='text/javascript'>alert('数据库加载错误请重试');window.location.back(-1)</script>");}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}private void DepAdd(HttpServletRequest request,HttpServletResponse response) throws UnsupportedEncodingException,ServletException, IOException {int i = 0;response.setContentType("text/html;charset=GBK ");request.setCharacterEncoding("GBK");PrintWriter out = response.getWriter();String Dep_ID = newString(request.getParameter("DepID").getBytes("ISO8859-1"),"GBK");String Dep_Name = newString(request.getParameter("DepName").getBytes("ISO8859-1"),"GBK");String Dep_About = newString(request.getParameter("DepAbout").getBytes("ISO8859-1"),"GBK");String Dep_Leader = newString(request.getParameter("DepLeader").getBytes("ISO8859-1"),"GBK"); // String Dep_Name = request.getParameter("DepName");// String Dep_About = request.getParameter("DepAbout");// String Dep_Leader = request.getParameter("DepLeader");// 创建数据库连接if(i==0){Connection conn;try {conn = JDBConnection.getConnection();StringBuffer sql = new StringBuffer();Statement st1 = conn.createStatement();ResultSet sb=st1.executeQuery("Select *from departmentinfo where Dep_ID='"+Dep_ID+"'");if(sb.next()){out.print("<script Type='text/JavaScript'Language='JavaScript' >alert('ERROR Dep_ID重复');window.location.href='dept/DepReg.jsp';</script>");}else{sql.append("insert intodepartmentinfo(Dep_ID,Dep_Name,Dep_About,Dep_Leader)values(");sql.append("'" + Dep_ID + "',");sql.append("'" + Dep_Name + "',");sql.append("'" + Dep_About + "',");sql.append("'" + Dep_Leader + "')");// 作用发送sql到数据库端Statement st = conn.createStatement();int count = st.executeUpdate(sql.toString());if (count > 0) {request.getRequestDispatcher("dept/DepSuccess.jsp").forward(request, response);st.close();conn.close();}}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}JSP代码1、部门信息管理<%@ page language="java" import="java.util.*" pageEncoding="GBK"%> <%@ page import="java.sql.*"%><%@ page import="com.model.tools.*"%><%@ include file="../checkuser.jsp"%><HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=GBK"> <link href="../css/css.css" rel="stylesheet" type="text/css"><script type="text/javascript" language="javascript">function CheckDelete(){return confirm("是否删除此信息！");}</script></HEAD><BODY BGCOLOR="#FFFFFF" leftmargin=20 topmargin=5><BR><%//变量声明Connection sqlCon; //数据库连接对象Statement sqlStmt; //SQL语句对象ResultSet sqlRst; //结果集对象String strCon; //数据库连接字符串String strSQL; //SQL语句int intPageSize; //一页显示的记录数int intRowCount; //记录总数int intPageCount; //总页数int intPage; //待显示页码String strPage;int i; //设置一页显示的记录数intPageSize = 4; //取得待显示页码strPage = request.getParameter("page");if (strPage == null) {//表明在QueryString中没有page这一个参数，此时显示第一页数据intPage = 1;} else {//将字符串转换成整型intPage = Integer.parseInt(strPage);if (intPage < 1)intPage = 1;}sqlCon = JDBConnection.getConnection();//创建一个可以滚动的只读的SQL语句对象sqlStmt =sqlCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//准备SQL语句strSQL = "select * from departmentinfo";//执行SQL语句并获取结果集sqlRst = sqlStmt.executeQuery(strSQL);//获取记录总数st();intRowCount = sqlRst.getRow();//记算总页数intPageCount = (intRowCount + intPageSize - 1) / intPageSize;//调整待显示的页码if (intPage > intPageCount)intPage = intPageCount;%><div align=center><table width="98%" border="0" ><tr align="center" class="bg_tr"><td><font size=2><b>部门信息管理</b></font></td></tr></table></div><form name="SearchForm" method="post" action=""><table border=0 width="100%"><tr><td>&nbsp;&nbsp;<a href="DepReg.jsp">[添加新部门]</a></td></tr></table><div align=center><table border=0 width="70%" cellspacing="1" cellpadding=3bgcolor="#005AB5"><tr class="bg_tr"><td>部门编号</td><td>部门名称</td><td>部门介绍</td><td>部门负责人</td><td colspan=2 align=center width="10%">操作</td></tr><%if (intPageCount > 0) {//将记录指针定位到待显示页的第一条记录上sqlRst.absolute((intPage - 1) * intPageSize + 1);//显示数据i = 0;while (i < intPageSize && !sqlRst.isAfterLast()) { %><tr class="td_bg"><td nowrap width=80><%=sqlRst.getString("Dep_ID") %></td><td ><%=sqlRst.getString("Dep_Name") %></td><td><%=sqlRst.getString(3) %></td><td><%=sqlRst.getString(4) %></td><td nowrap><ahref="DepEdit.jsp?Dep_ID=<%=sqlRst.getString("Dep_ID") %>">修改</a></td> <td nowrap><ahref="../DepDelete?Dep_ID=<%=sqlRst.getString("Dep_ID") %>"onClick="return CheckDelete();">删除</a></td></tr><%sqlRst.next();i++;}}%></table></div><div align="right" ><table><td>第<%=intPage%>页共<%=intPageCount%>页</td><td><a href="DepControl.jsp?page=1"/>第一页</a></td><%if (intPage > 1) {%><td><a href="DepControl.jsp?page=<%=intPage - 1%>">上一页</a></td> <%}%><%if (intPage < intPageCount) {%><td><a href="DepControl.jsp?page=<%=intPage + 1%>">下一页</a></td><%}%><td><a href="DepControl.jsp?page=<%=intPageCount%>">尾页</a>&nbsp&nbsp</td></table></div><BR><BR></BODY></HTML><%//关闭结果集sqlRst.close();//关闭SQL语句对象sqlStmt.close();//关闭数据库sqlCon.close();%>2、修改部门信息页面<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%@ page import="java.sql.*"%><%@page import="com.model.tools.*"%><%@ include file="../checkuser.jsp"%><HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=GBK"> <link rel=stylesheet href="../css/css.css" type="text/css"><script type="text/javascript">function checkForm(depForm){if(depForm.Dep_Name.value==""){window.alert("请输入部门名称！");document.depForm.Dep_Name.focus();return false;}if(depForm.Dep_About.value==""){window.alert("请输入部门介绍！");document.depForm.Dep_About.focus();return false;}if(depForm.Dep_Leader.value==""){window.alert("请输入部门负责人！");document.depForm.Dep_Leader.focus();return false;}}</script></HEAD><BODY BGCOLOR="#FFFFFF"><BR>String Dep_ID = request.getParameter("Dep_ID");//创建数据库连接Connection conn = JDBConnection.getConnection();Statement st = conn.createStatement();ResultSet rs = st.executeQuery("select * from departmentinfo where Dep_ID='"+Dep_ID+ "'");while (rs.next()) {%><br><br><form name="depForm" method="post" onSubmit="returncheckForm(depForm)" action="../DepInfoServlet?method=2" ><table align="center" border=0 cellpadding=3 cellspacing=1width="60%" bgcolor=#005AB5 bordercolordark="#FFFFFF"bordercolorlight="#999999"><tr bgcolor="#FFFFFF"><td colspan=2 ><a href="DepControl.jsp">返回部门管理界面</a></td></tr><tr class="bg_tr"><td colspan=2 align="center"><b>修改部门信息页面</b></td></tr><tr><td bgcolor="#FFFFFF">部门编号：</td><td bgcolor="#FFFFFF"><input type="text" name="Dep_ID" readonlyclass="input" size=30maxlength=50 value="<%=rs.getString(1)%>"><font color=#ff0000>*</font></td></tr><tr><td bgcolor="#FFFFFF">部门名称：</td><td bgcolor="#FFFFFF"><input type="text" name="Dep_Name" class="input" size=30maxlength=50 value="<%=rs.getString(2)%>"><font color=#ff0000>*</font></td></tr><tr><td bgcolor="#FFFFFF">部门介绍：</td><td bgcolor="#FFFFFF"><input type="text" name="Dep_About" class="input"maxlength=50 value="<%=rs.getString(3)%>"></td></tr><tr><td bgcolor="#FFFFFF">部门负责人：</td><td bgcolor="#FFFFFF"><input type="text" name="Dep_Leader" class="input" size=30maxlength=50 value="<%=rs.getString(4)%>"></td></tr><tr><%}%><td colspan=2 align="center" bgcolor="#FFFFFF"><input type="submit" name="cmdUp" value="提交"class="bg_tr"><input type="reset" value="重置" class="bg_tr"></td></tr></table><INPUT TYPE="hidden" name="ID" value="0"></form><BR><BR></BODY></HTML>3、部门信息<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><%@ page import="java.sql.*"%><%@ page import="com.model.tools.*"%><%@ include file="../checkuser.jsp"%><HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=GBK"><link href="../css/css.css" rel="stylesheet" type="text/css"><script type="text/javascript" language="javascript"></script></HEAD><BODY BGCOLOR="#FFFFFF" leftmargin=20 topmargin=5><BR><%//变量声明Connection sqlCon; //数据库连接对象Statement sqlStmt; //SQL语句对象ResultSet sqlRst; //结果集对象String strCon; //数据库连接字符串String strSQL; //SQL语句int intPageSize; //一页显示的记录数int intRowCount; //记录总数int intPageCount; //总页数int intPage; //待显示页码String strPage;int i; //设置一页显示的记录数intPageSize = 4; //取得待显示页码strPage = request.getParameter("page");if (strPage == null) {//表明在QueryString中没有page这一个参数，此时显示第一页数据intPage = 1;} else {//将字符串转换成整型intPage = Integer.parseInt(strPage);if (intPage < 1)intPage = 1;}sqlCon = JDBConnection.getConnection();//创建一个可以滚动的只读的SQL语句对象sqlStmt =sqlCon.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//准备SQL语句strSQL = "select * from departmentinfo";//执行SQL语句并获取结果集sqlRst = sqlStmt.executeQuery(strSQL);//获取记录总数st();intRowCount = sqlRst.getRow();//记算总页数intPageCount = (intRowCount + intPageSize - 1) / intPageSize;//调整待显示的页码if (intPage > intPageCount)intPage = intPageCount;%><div align=center><table width="98%" border="0" ><tr align="center" class="bg_tr"><td><font size=2><b>部门信息</b></font></td></tr></table></div><form name="SearchForm" method="post" action=""><table border=0 width="100%"><tr><td>第<%=intPage%>页共<%=intPageCount%>页</td></tr></table><div align=center><table border=0 width="60%" cellspacing="1" cellpadding=3bgcolor="#005AB5"><tr class="bg_tr"><td>部门编号</td><td>部门名称</td><td>部门介绍</td><td>部门负责人</td></tr><%if (intPageCount > 0) {//将记录指针定位到待显示页的第一条记录上sqlRst.absolute((intPage - 1) * intPageSize + 1);//显示数据i = 0;while (i < intPageSize && !sqlRst.isAfterLast()) { %><tr class="td_bg"><td nowrap width=80><%=sqlRst.getString("Dep_ID") %></td><td ><%=sqlRst.getString("Dep_Name") %></td><td><%=sqlRst.getString(3) %></td><td><%=sqlRst.getString(4) %></td></tr><%sqlRst.next();i++;}}%></table></div><div align="right" ><td><a href="DepControl.jsp?page=1"/>第一页</a></td><%if (intPage > 1) {%><td><a href="DepControl.jsp?page=<%=intPage - 1%>">上一页</a></td> <%}%><%if (intPage < intPageCount) {%><td><a href="DepControl.jsp?page=<%=intPage + 1%>">下一页</a></td><%}%><td><a href="DepControl.jsp?page=<%=intPageCount%>">尾页</a>&nbsp&nbsp</td></div><BR><BR></BODY></HTML><%//关闭结果集sqlRst.close();//关闭SQL语句对象sqlStmt.close();//关闭数据库sqlCon.close();%>4、部门设置<%@ page language="java" import="java.util.*" pageEncoding="GBK"%> <%@ include file="../checkuser.jsp"%><HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=GBK"> <link rel=stylesheet href="../css/css.css" type="text/css"><script type="text/javascript">function checkForm(depForm){if(depForm.DepID.value==""){window.alert("请输入部门编号！");document.depForm.DepID.focus();return false;}if(depForm.DepName.value==""){window.alert("请输入部门名称！");document.depForm.DepName.focus();return false;}if(depForm.DepAbout.value==""){window.alert("请输入部门介绍！");document.depForm.DepAbout.focus();return false;}if(depForm.DepLeader.value==""){window.alert("请输入部门负责人！");document.depForm.DepLeader.focus();return false;}}</script></HEAD><BODY BGCOLOR="#FFFFFF"><BR><form name="depForm" method="post" onSubmit="return checkForm(depForm)" action="../DepInfoServlet?method=1" ><table align="center" border=0 cellpadding=3 cellspacing=1 width="70%" bgcolor=#005AB5 bordercolordark="#FFFFFF" bordercolorlight="#999999"> <tr BGCOLOR="#FFFFFF"><td colspan=2 ><a href="DepControl.jsp">返回部门管理界面</a></td> </tr><tr class="bg_tr"><td colspan=2 align="center" ><b>部门设置界面</b></td> </tr><tr><td bgcolor="#FFFFFF">部门编号：</td><td bgcolor="#FFFFFF"><input type="text" name="DepID" title="请输入部门编号" class="input" size=30 maxlength=50 value=""><font color=#ff0000>*</font></td></tr><tr><td bgcolor="#FFFFFF">部门名称：</td><td bgcolor="#FFFFFF"><input type="text" name="DepName" title="请输入部门名称" class="input" size=30 maxlength=50 value=""><font color=#ff0000>*</font></td></tr><tr><td bgcolor="#FFFFFF">部门介绍：</td><td bgcolor="#FFFFFF"><input type="text" name="DepAbout"class="input" size=30 maxlength=50 value=""></td></tr><tr><td bgcolor="#FFFFFF">部门负责人：</td><td bgcolor="#FFFFFF"><input type="text" name="DepLeader"class="input" size=30 maxlength=50 value=""></td></tr><td colspan=2 align="center" bgcolor="#FFFFFF"><input type="submit" name="cmdUp" value="提交"class="bg_tr"><input type="reset" value="重置" class="bg_tr"></td></table><INPUT TYPE="hidden" name="ID" value="0"></form><BR><BR></BODY></HTML>5、信息操作成功<%@ page language="java" import="java.util.*" pageEncoding="GBK"%> <%@ include file="../checkuser.jsp"%><html><head><title>信息操作成功</title><meta http-equiv="Content-Type" content="text/html; charset=GBK"><link rel=stylesheet href="css/css.css" type="text/css"><SCRIPT LANGUAGE="JavaScript">var start=new Date();start=Date.parse(start)/1000;var counts=2;function CountDown(){var now=new Date();now=Date.parse(now)/1000;var x=parseInt(counts-(now-start),10);if(document.form1){document.form1.clock.value = x;}if(x>0){timerID=setTimeout("CountDown()", 100)}else{location.href="dept/DepControl.jsp"}}window.setTimeout('CountDown()',100);</script><FORM NAME="form1"><INPUT TYPE="text" NAME="clock" SIZE="2" VALUE="1">秒后自动跳转网页</FORM><body><div align=center><br><br><table><tr class="bg_tr"><td >信息操作成功<br>长时间不跳转<a href="dept/DepControl.jsp">请点这里</a></tr></table></div></body></html>三、cssbody {FONT-SIZE: 12px;margin-left: 4px;margin-top: 0px;margin-right: 0px;PADDING-RIGHT: 0px; PADDING-LEFT: 0px; SCROLLBAR-FACE-COLOR: #59D6FF; PADDING-BOTTOM: 0px; SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;SCROLLBAR-SHADOW-COLOR: #ffffff; SCROLLBAR-3DLIGHT-COLOR: #007BC6; SCROLLBAR-DARKSHADOW-COLOR: #007BC6; SCROLLBAR-ARROW-COLOR: #007BC6; PADDING-TOP: 0px; SCROLLBAR-TRACK-COLOR: #009ED2;}.table{border: 1px solid #CAF2FF;/*边框颜色*/margin-top: 5px;margin-bottom: 5px;background:#B8D3F1;}.td_bg {background:#ffffff;}/* .ACT_btn {background-color:#EAEAEA;border-top:2px solid #FEFEFE;border-right:1px solid #BCBCBCborder-bottom:1px solid #BCBCBC;border-left:2px solid #FEFEFE;height:29px;cursor:hand;font-size: 14px;}*/.ACT_btn {background: url(../act_btn.gif) no-repeat;height:26px;width:94px;cursor:hand;border:solid 0px #111;font-size: 12px;}.bg_tr {font-family: "微软雅黑,Verdana, 新宋体";color:#1E5494;/*标题字体色*/font-size:12px;font-weight:bolder;background:#E4F1FA;/*标题背景色*/line-height: 22px;}td {color:#1E5494;font-size:12px;line-height: 18px;}.tdbg1 {background:#F9F9F9;}.tdbg {BACKGROUND: #ffffff;}.top_link{text-decoration:none;font-size:14px;color:#FFDED2;height:0;fi lter:dropshadow(offX=1,offY=1,color=BD3400);}A.top_link:link{text-decoration:none;font-size:14px;color:#FFDED2;heigh t:0;filter:dropshadow(offX=1,offY=1,color=BD3400);}A.top_link:visited{text-decoration:none;font-size:14px;color:#FFDED2;he ight:0;filter:dropshadow(offX=1,offY=1,color=BD3400);}A.top_link:active{text-decoration:underline;font-size:14px;color:#fff;h eight:0;filter:dropshadow(offX=1,offY=1,color=BD3400);}A.top_link:hover{text-decoration:underline;font-size:14px;color:#fff;he ight:0;filter:dropshadow(offX=1,offY=1,color=BD3400);}.subbg{ width:100%; height:26px; background:url(Images/sub_bg.jpg); background-repeat:repeat-x;}.topbar {color:#ffffff}.topbar a:link,.topbar a:visited{color:#ffffff;}.topbar a:hover{background:#ccffcc; display:block; height:26px;padding-top:6px; color:#000000; text-decoration:none}#table2 {width:100%;height:30px;border-bottom : 1px solid #fff;background-color: #6E4000;}.topBorder{background:url(Images/admin_topbg1.jpg);background-repeat:repeat-x; } .titledaohang {FONT-SIZE: 12px;FILTER: Glow(Color=#EDD2C6, Strength=1) dropshadow(Color=#EDD2C6, OffX=1, OffY=1,);COLOR: #551C02;font-weight:bolder;FONT-FAMILY: '微软雅黑,宋体'}/*input{height:15px;padding-top:2px;border:1px solid #7F9DB9;color:#1E5494;}*/.Leftback {background:#865802;}.leftframetable{border: 1px solid #4C3500;margin-top: 3px;margin-bottom: 3px;background:#FDF6E6;}a{text-decoration: none;} /* 链接无下划线,有为underline */a:link {color: #1E5494;} /* 未访问的链接 */a:visited {color: #1E5494;} /* 已访问的链接 */a:hover{color: #1E5494;} /* 鼠标在链接上 */a:active {color: #1E5494;} /* 点击激活链接 */四、数据库连接数据库连接package com.model.tools;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class JDBConnection {private static Stringurl="jdbc:mysql://localhost:3306/kq?useUnicode=true&characterEncoding=g bk";private static String username="root";private static String password="123456";static{try {Class.forName("com.mysql.jdbc.Driver");} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.print(e);}}public static Connection getConnection() {try {return DriverManager.getConnection(url,username,password);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.print("数据库连接失败"+e);}return null;}}。