JSP制作员工管理系统后台：admin.jsp

最新推荐文章于 2024-03-27 19:55:06 发布

码界一棵葱

最新推荐文章于 2024-03-27 19:55:06 发布

阅读量1.9k

点赞数

分类专栏： JSP网页设计

本文链接：https://blog.csdn.net/lyyybz/article/details/8782158

版权

JSP网页设计专栏收录该内容

25 篇文章 0 订阅

订阅专栏

员工管理系统，登录成功后页面：admin.jsp

<jsp:include page="check.jsp" flush="true" />

check.jsp实现验证用户是否登录功能，参考：

JSP验证用户是否登录:check.jsp http://blog.csdn.net/lyyybz/article/details/8782157

<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<jsp:include page="check.jsp" flush="true" />
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>www.xin126.cn原创：admin.jsp </title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="JSP,员工管理系统">
<meta http-equiv="description" content="www.xin126.cn原创教程">

<style type="text/css">

</style>
</head>

<body>
<table width="491" border="0" align="center" cellpadding="0" cellspacing="10">
<tr>
<td colspan="3"><div align="center"><span class="STYLE2">员工管理系统</span></div></td>
</tr>
<tr>
<td width="177"><a href="add_employee.jsp">添加员工信息</a></td>

<form name="form1" method="post" action="">
<td width="232">姓名：
<input name="username" type="text" id="username">
</td>
<td width="42"><input type="submit" name="Submit" value="查找"></td> </form>
</tr>
<tr>
<td colspan="3"><% request.setCharacterEncoding("gb2312");
String username=request.getParameter("username");
String condition;

if(username==null)
{
username="";
}
if(username==""){
condition="SELECT * FROM employee_info";
}
else
{
//condition="SELECT * FROM employee_info where employee_name='"+username+"'";
condition="SELECT * FROM employee_info where employee_name like '%"+username+"%'";
}
Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{ out.print(e);
}

try { con=DriverManager.getConnection("jdbc:odbc:employee_dsn","sa","2005");
sql=con.createStatement();
rs=sql.executeQuery(condition);
out.print("<table border='1' width='100%'>");
out.print("<tr>");
out.print("<th >雇员号</th >");
out.print("<th >姓名</th >");
out.print("<th >出生日期</th >");
out.print("<th >薪水</th >");
out.print("<th >编辑</th >");
out.print("<th >删除</th >");
out.print("</TR>");
while(rs.next())
{ out.print("<tr>");
int id=rs.getInt("employee_num");
out.print("<td >"+id+"</td>");
out.print("<td >"+rs.getString("employee_name")+"</td>");
out.print("<td >"+rs.getDate("birthday")+"</td>");
out.print("<td >"+rs.getInt("salary")+"</td>");
out.print("<td><a href=modify.jsp?id="+id+">编辑</a></td>");
out.print("<td ><a href=delete.jsp?id="+id+" οnclick=return(confirm('确定删除吗？'))>删除</a></td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e)
{ out.print(e);
}
%></td>
</tr>
</table>
</body>
</html>

out.print("<td ><a href=delete.jsp?id="+id+" οnclick=return(confirm('确定删除吗？'))>删除</a></td>");

本代码完成功能：在删除信息前，弹出确认删除对话框。

码界一棵葱

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
JSP制作员工管理系统后台：admin.jsp

员工管理系统，登录成功后页面：admin.jspcheck.jsp实现验证用户是否登录功能，参考：JSP验证用户是否登录:check.jsp http://blog.csdn.net/lyyybz/article/details/8782157String path = request.getContextPath();String basePath =
复制链接

扫一扫

专栏目录