员工信息系统管理源程序.docx
- 文档编号:10570769
- 上传时间:2023-02-21
- 格式:DOCX
- 页数:40
- 大小:26.46KB
员工信息系统管理源程序.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);
}
//查询方法
publicArrayList
Connectionconn=null;
Statementstat=null;
ResultSetrs=null;
conn=connect();
stat=conn.createStatement();
ArrayList
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");
ArrayList
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");
ArrayList
Pagepager=newPage();
pager=setpage(request,response);
List
intcurrentRecord=pager.getCurrentRecord();
if(currentRecord==0){
if(pager.getTotalRecord()<8){
subResult=(List
}
else{
subResult=(List
}
}
elseif(pager.getCurrentRecord()+pager.getPageSize() { subResult=(List } else { subResult=(List } 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(
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 员工 信息 系统管理 源程序