📄 复件 44.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<style type="text/css">
<!--
.STYLE1 {font-family: "方正舒体", "方正姚体";
font-size: 50px;
color: #0066FF;
}
.STYLE2 {
font-size: 20px;
font-family: "方正姚体";
color: #FF0033;
}
body {
background-color: #CCCCFF;
}
-->
</style>
<body>
<p align="center"><span class="STYLE1">DSY 人事管理系统</span></p>
<p>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String id="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
out.println(ce.getMessage());
}
try
{
conn=DriverManager.getConnection("jdbc:odbc:dong");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql="select * from people order by id desc";
String sql2=(String)session.getAttribute("sql1");
if(sql2!="")
{
sql=sql2;
sql+=" order by id desc";
}
rs=stmt.executeQuery(sql);
session.setAttribute("sql1","");
}
catch(SQLException e)
{
out.println(e.getMessage());
}
session.setAttribute("flag","0");
session.setAttribute("flag1","0");
%>
</p>
<p align="center" class="STYLE2">注意：此删除为永久性删除，请管理员确认后再执行！！</p>
<table width="769" border="1" align="center" bgcolor="lightpink">
<tr>
<td>职工编号</td>
<td>姓名</td>
<td>部门</td>
<td>性别</td>
<td>生日</td>
<td>民族</td>
<td>籍贯</td>
<td>家庭出身</td>
<td>基本工资</td>
<td>职务</td>
<td>职称</td>
<td>学历</td>
<td>奖罚情况</td>
<td>主要经历</td>
<td>社会兼职</td>
<td colspan="2" >操作</td>
</tr>
<%
while(rs.next())
{
id=rs.getString("id");
out.println("<tr>");
out.println("<td>"+rs.getString("id")+"</td>");
out.println("<td>"+rs.getString("name")+"</td>");
out.println("<td>"+rs.getString("bm")+"</td>");
out.println("<td>"+rs.getString("sex")+"</td>");
out.println("<td>"+rs.getString("sr")+"</td>");
out.println("<td>"+rs.getString("mz")+"</td>");
out.println("<td>"+rs.getString("jg")+"</td>");
out.println("<td>"+rs.getString("jtcs")+"</td>");
out.println("<td>"+rs.getString("jbgz")+"</td>");
out.println("<td>"+rs.getString("zw")+"</td>");
out.println("<td>"+rs.getString("zc")+"</td>");
out.println("<td>"+rs.getString("xl")+"</td>");
out.println("<td>"+rs.getString("jfqk")+"</td>");
out.println("<td>"+rs.getString("zyjl")+"</td>");
out.println("<td>"+rs.getString("shjz")+"</td>");
out.println("<td><a href='66.jsp?id="+id+"'>"+"修改"+"</a></td>");
//out.println("<td><a href='test1.jsp?id="+id+"'>"+"修改"+"</a></td>");
out.println("<td><a href='shangchu.jsp?id="+id+"'>"+"删除"+"</a></td>");
out.println("</tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -