员工信息系统管理源程序.docx
《员工信息系统管理源程序.docx》由会员分享,可在线阅读,更多相关《员工信息系统管理源程序.docx(40页珍藏版)》请在冰豆网上搜索。
员工信息系统管理源程序
大作业源程序
Bean
packagebean;
publicclassPage{
privateinttotalPage;
privateintcurrentPage;
privateinttotalRecord;
privateintcurrentRecord;
privateintpageSize=10;
//获得和设置当前页
publicintgetCurrentPage(){
returncurrentPage;
}
publicvoidsetCurrentPage(intcurrentRecord,intpageSize){
if(currentRecord%pageSize==0){
currentPage=currentRecord/pageSize;
}
else{
currentPage=currentRecord/pageSize+1;
}
}
//获得和设置当前记录
publicintgetCurrentRecord(){
returncurrentRecord;
}
publicvoidsetCurrentRecord(intcurrentRecord){
this.currentRecord=currentRecord;
}
//获得和设置每页记录数量
publicintgetPageSize(){
returnpageSize;
}
publicvoidsetPageSize(intpageSize){
this.pageSize=pageSize;
}
//获得和设置总页数
publicintgetTotalPage(){
returntotalPage;
}
publicvoidsetTotalPage(inttotalRecord,intpageSize){
if(totalRecord%pageSize==0){
totalPage=totalRecord/pageSize;
}
else{
totalPage=totalRecord/pageSize+1;
}
}
//获得和设置总记录
publicintgetTotalRecord(){
returntotalRecord;
}
publicvoidsetTotalRecord(inttotalRecord){
this.totalRecord=totalRecord;
}
}
packagebean;
publicclassStudentInfo{
privateintid;//员工编号
privateStringname;//姓名
privateintage;//年龄
privateStringgender;//性别
privateStringmajor;//专业
publicStudentInfo(){
}
publicStudentInfo(intid,Stringname,intage,Stringgender,Stringmajor){
this.id=id;
this.name=name;
this.age=age;
this.gender=gender;
this.major=major;
}
publicintgetId(){
returnid;
}
publicvoidsetId(intid){
this.id=id;
}
publicStringgetName(){
returnname;
}
publicvoidsetName(Stringname){
this.name=name;
}
publicintgetAge(){
returnage;
}
publicvoidsetAge(intage){
this.age=age;
}
publicStringgetGender(){
returngender;
}
publicvoidsetGender(Stringgender){
this.gender=gender;
}
publicStringgetMajor(){
returnmajor;
}
publicvoidsetMajor(Stringmajor){
this.major=major;
}
}
Dbservlet
packagedbservlet;
importjava.io.IOException;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importbean.Page;
importbean.StudentInfo;
publicclassAllServletextendsHttpServlet{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
//doPost方法
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
StringmethodName=request.getParameter("methodName");
intmethod=Integer.parseInt(methodName);
try{
switch(method)
{
case0:
insert(request,response);
case1:
difpage(request,response);
break;
case2:
delete(request,response);
break;
case3:
update(request,response);
break;
case4:
update1(request,response);
break;
case5:
dispatch(request,response);
break;
}
}catch(ClassNotFoundExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}
//doGet方法
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
//数据库连接方法
publicConnectionconnect()throwsClassNotFoundException,SQLException{
Connectionconn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Stringurl="jdbc:
odbc:
driver={MicrosoftAccessDriver(*.mdb,*.accdb)};DBQ=d:
//student.accdb";
Stringuser="";
Stringpassword="";
conn=DriverManager.getConnection(url,user,password);
returnconn;
}
//关闭数据库资源
publicvoidclose(Statementstat,Connectionconn)throwsSQLException{
if(stat!
=null){
stat.close();
}
if(conn!
=null){
conn.close();
}
}
//插入方法
publicvoidinsert(HttpServletRequestrequest,HttpServletResponseresponse)throwsClassNotFoundException,SQLException{
Connectionconn=null;
Statementstat=null;
Stringid=request.getParameter("id");
Stringname=request.getParameter("name");
Stringage=request.getParameter("age");
Stringgender=request.getParameter("gender");
Stringmajor=request.getParameter("major");
conn=connect();
stat=conn.createStatement();
stat.execute("insertintostudent(id,name,age,gender,major)values("+id+",'"+name+"',"+age+",'"+gender+"','"+major+"')");
close(stat,conn);
}
//查询方法
publicArrayListselect(Stringid,Stringname)throwsClassNotFoundException,SQLException{
Connectionconn=null;
Statementstat=null;
ResultSetrs=null;
conn=connect();
stat=conn.createStatement();
ArrayListresult=newArrayList();
if(id==""&&name==""){
rs=stat.executeQuery("select*fromstudent");
}
if(id!
=""&&name==""){
rs=stat.executeQuery("select*fromstudentwhereid="+id+"");
}
if(id==""&&name!
=""){
rs=stat.executeQuery("select*fromstudentwherename='"+name+"'");
}
if(id!
=""&&name!
=""){
rs=stat.executeQuery("select*fromstudentwhereid="+id+"andname='"+name+"'");
}
while(rs.next())
{
StudentInfost=newStudentInfo();
st.setId(rs.getInt("id"));
st.setName(rs.getString("name"));
st.setAge(rs.getInt("age"));
st.setGender(rs.getString("gender"));
st.setMajor(rs.getString("major"));
result.add(st);
}
if(rs!
=null){
rs.close();
}
close(stat,conn);
returnresult;
}
//条件查询跳转
publicvoiddispatch(HttpServletRequestrequest,HttpServletResponseresponse)throwsClassNotFoundException,SQLException,ServletException,IOException{
Stringid5=request.getParameter("id");
Stringname5=request.getParameter("name");
if(select(id5,name5).isEmpty()){
request.getRequestDispatcher("selectnothing.jsp").forward(request,response);
}
else{
request.setAttribute("result",select(id5,name5));
request.getRequestDispatcher("idnameselect.jsp").forward(request,response);
}
}
//设置分页相关参数方法
publicPagesetpage(HttpServletRequestrequest,HttpServletResponseresponse)throwsClassNotFoundException,SQLException{
Stringcrd=request.getParameter("currentRecord");
//Stringid=request.getParameter("id");
//Stringname=request.getParameter("name");
ArrayListresult=select("","");
Pagepager=newPage();
pager.setTotalRecord(result.size());
pager.setTotalPage(result.size(),pager.getPageSize());
if(crd!
=null)
{
intcurrentRecord=Integer.parseInt(crd);
pager.setCurrentRecord(currentRecord);
pager.setCurrentPage(currentRecord,pager.getPageSize());
}
returnpager;
}
//获得分页显示的子集
publicvoiddifpage(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException,ClassNotFoundException,SQLException{
//Stringid=request.getParameter("id");
//Stringname=request.getParameter("name");
ArrayListresult=select("","");
Pagepager=newPage();
pager=setpage(request,response);
ListsubResult=null;
intcurrentRecord=pager.getCurrentRecord();
if(currentRecord==0){
if(pager.getTotalRecord()<8){
subResult=(List)result.subList(0,pager.getTotalRecord());
}
else{
subResult=(List)result.subList(0,pager.getPageSize());
}
}
elseif(pager.getCurrentRecord()+pager.getPageSize(){
subResult=(List)result.subList(pager.getCurrentRecord(),pager.getCurrentRecord()+pager.getPageSize());
}
else
{
subResult=(List)result.subList(pager.getCurrentRecord(),result.size());
}
request.setAttribute("pager",pager);
request.setAttribute("subResult",subResult);
request.getRequestDispatcher("layout.jsp").forward(request,response);
}
//信息删除方法
publicvoiddelete(HttpServletRequestrequest,HttpServletResponseresponse)throwsClassNotFoundException,SQLException,ServletException,IOException{
Connectionconn=null;
Statementstat=null;
conn=connect();
stat=conn.createStatement();
Stringid2=request.getParameter("id");
stat.execute("deletefromstudentwhereid="+id2+"");
request.getRequestDispatcher("delete.jsp").forward(request,response);
}
//信息修改方法
publicvoidupdate1(HttpServletRequestrequest,HttpServletResponseresponse)throwsClassNotFoundException,SQLException,ServletException,IOException{
Stringid4=request.getParameter("id");
request.setAttribute("result",select(id4,""));
request.getRequestDispatcher("update1.jsp").forward(request,response);
}
publicvoidupdate(HttpServletRequestrequest,HttpServletResponseresponse)throwsClassNotFoundException,SQLException,ServletException,IOException{
Connectionconn=null;
Statementstat=null;
Stringid3=request.getParameter("id");
Stringname3=request.getParameter("name");
Stringage3=request.getParameter("age");
Stringgender3=request.getParameter("gender");
Stringmajor3=request.getParameter("major");
conn=connect();
stat=conn.createStatement();
stat.execute("updatestudentsetid="+id3+",name='"+name3+"',age="+age3+",gender='"+gender3+"',major='"+major3+"'whereid="+id3+"");
request.setAttribute("result",select(id3,""));
request.getRequestDispatcher("update.jsp").forward(request,response);
}
}
登录页面
<%@pagelanguage="java"import="java.util.*"pageEncoding="utf-8"%>
<%
Stringpath=request.getContextPath(