web用户管理系统源代码Word格式.docx
- 文档编号:22515633
- 上传时间:2023-02-04
- 格式:DOCX
- 页数:22
- 大小:18.42KB
web用户管理系统源代码Word格式.docx
《web用户管理系统源代码Word格式.docx》由会员分享,可在线阅读,更多相关《web用户管理系统源代码Word格式.docx(22页珍藏版)》请在冰豆网上搜索。
}
}
//EMP表的增删改查功能实现
packagecom.dao;
importjava.sql.Date;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.Statement;
importjava.text.SimpleDateFormat;
importjava.util.ArrayList;
importcom.bean.Emp;
importcom.tools.DBUtil;
publicclassEmpDAO{
publicstaticvoidmain(String[]args)throwsClassNotFoundException,
SQLException{
EmpDAOdao=newEmpDAO();
dao.queryAll();
publicArrayList<
Emp>
queryAll()throwsClassNotFoundException,
Connectionconn=DBUtil.getConnection();
//4.创建Statement
Statements=conn.createStatement();
//5.执行SQL语句
Stringsql="
select*fromemp"
;
//6.处理结果集
ResultSetrs=s.executeQuery(sql);
ArrayList<
list=newArrayList<
();
while(rs.next()){
Empe=newEmp();
e.setEmpno(rs.getInt("
empno"
));
e.setEname(rs.getString("
ename"
e.setJob(rs.getString("
job"
e.setManager(rs.getInt("
mgr"
e.setSal(rs.getFloat("
sal"
e.setComm(rs.getFloat("
comm"
Datedate=rs.getDate("
hiredate"
e.setHiredate(date.getYear()+1900+"
年"
+(date.getMonth()+1)+"
月"
+date.getDate()+"
日"
e.setDeptno(rs.getInt("
deptno"
list.add(e);
}
//7.关闭
rs.close();
s.close();
conn.close();
returnlist;
publicEmpfindById(intid)throwsClassNotFoundException,SQLException{
//SQL语句生成
select*fromempwhereempno=?
"
PreparedStatementps=conn.prepareStatement(sql);
ps.setInt(1,id);
ResultSetrs=ps.executeQuery();
Empe=newEmp();
if(rs.next()){
Dated=rs.getDate("
java.util.Datedd=newjava.util.Date(d.getTime());
Stringstr=dd.getYear()+1900+"
-"
+(dd.getMonth()+1)+"
+dd.getDate();
e.setHiredate(str);
ps.close();
returne;
publicvoiddeleteById(intid)throwsClassNotFoundException,SQLException{
deletefromempwhereempno=?
ps.executeUpdate();
publicvoidadd(Empe)throwsClassNotFoundException,SQLException{
insertintoemp("
+"
empno,"
+//员工编号
"
ename,"
job,"
mgr,"
sal,"
comm,"
hiredate,"
deptno)"
values(SEQ_EMP_EMPNO.nextval,?
?
to_date(?
'
YYYY-MM-DD'
),?
)"
ps.setString(1,e.getEname());
ps.setString(2,e.getJob());
ps.setInt(3,e.getManager());
ps.setFloat(4,e.getSal());
ps.setFloat(5,e.getComm());
ps.setString(6,e.getHiredate());
ps.setInt(7,e.getDeptno());
publicvoidupdate(Empe)throwsClassNotFoundException,SQLException{
updateempsetename=?
job=?
mgr=?
sal=?
comm=?
hiredate=to_date(?
),deptno=?
whereempno=?
ps.setInt(8,e.getEmpno());
//EMP表的各种数据成员
packagecom.bean;
publicclassEmp{
privateintempno;
privateStringename;
privateStringjob;
privateintmanager;
privatefloatsal;
privatefloatcomm;
privateintdeptno;
privateStringhiredate;
publicintgetEmpno(){
returnempno;
publicvoidsetEmpno(intempno){
this.empno=empno;
publicStringgetEname(){
returnename;
publicvoidsetEname(Stringename){
this.ename=ename;
publicStringgetJob(){
returnjob;
publicvoidsetJob(Stringjob){
this.job=job;
publicintgetManager(){
returnmanager;
publicvoidsetManager(intmanager){
this.manager=manager;
publicfloatgetSal(){
returnsal;
publicvoidsetSal(floatsal){
this.sal=sal;
publicfloatgetComm(){
returncomm;
publicvoidsetComm(floatcomm){
m=comm;
publicintgetDeptno(){
returndeptno;
publicvoidsetDeptno(intdeptno){
this.deptno=deptno;
publicStringgetHiredate(){
returnhiredate;
publicvoidsetHiredate(Stringhiredate){
this.hiredate=hiredate;
//增加用户信息
packagecom;
importjava.io.IOException;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importcom.dao.EmpDAO;
publicclassAddEmpextendsHttpServlet{
/**
*Constructoroftheobject.
*/
publicAddEmp(){
super();
*Destructionoftheservlet.<
br>
publicvoiddestroy(){
super.destroy();
//Justputs"
destroy"
stringinlog
//Putyourcodehere
*ThedoGetmethodoftheservlet.<
*
*Thismethodiscalledwhenaformhasitstagvaluemethodequalstoget.
*
*@paramrequesttherequestsendbytheclienttotheserver
*@paramresponsetheresponsesendbytheservertotheclient
*@throwsServletExceptionifanerroroccurred
*@throwsIOExceptionifanerroroccurred
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
//获得参数
Stringename=request.getParameter("
Stringjob=request.getParameter("
Stringmgr=request.getParameter("
Stringsal=request.getParameter("
Stringcomm=request.getParameter("
Stringhiredate=request.getParameter("
Stringdeptno=request.getParameter("
Empemp=newEmp();
emp.setEname(ename);
emp.setJob(job);
emp.setManager(Integer.parseInt(mgr));
emp.setSal(Float.parseFloat(sal));
emp.setComm(Float.parseFloat(comm));
emp.setHiredate(hiredate);
emp.setDeptno(Integer.parseInt(deptno));
//调用查询
try{
dao.add(emp);
}catch(NumberFormatExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}catch(ClassNotFoundExceptione){
}catch(SQLExceptione){
//设置参数
//重定向
response.sendRedirect("
ListEmp"
*ThedoPostmethodoftheservlet.<
*Thismethodiscalledwhenaformhasitstagvaluemethodequalstopost.
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
doGet(request,response);
*Initializationoftheservlet.<
*@throwsServletExceptionifanerroroccurs
publicvoidinit()throwsServletException{
//删除信息
importjava.io.PrintWriter;
importjavax.servlet.RequestDispatcher;
publicclassDeleteEmpextendsHttpServlet{
publicDeleteEmp(){
Stringempno=request.getParameter("
dao.deleteById(Integer.parseInt(empno));
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- web 用户 管理 系统 源代码