📄 99.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: #6666FF;
}
.STYLE3 {
font-size: 20px;
color: #FF6666;
}
body {
background-color: #CCCCFF;
}
-->
</style>
<body>
<p align="center"><span class="STYLE1">DSY 人事管理系统</span></p>
<p>
<%
String id1="";
if(session.getAttribute("username1")!=null)
{
id1=(String)session.getAttribute("username1");
}
%>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
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);
rs=stmt.executeQuery("select * from people where id='"+id1+"'");
}
catch(SQLException e)
{
out.println(e.getMessage());
}
rs.next();
String id=rs.getString("id");
String name=rs.getString("name");
String pass=rs.getString("pass");
String bm=rs.getString("bm");
String sex=rs.getString("sex");
String sr=rs.getString("sr");
String mz=rs.getString("mz");
String jg=rs.getString("jg");
String jtcs=rs.getString("jtcs");
String jbgz=rs.getString("jbgz");
String zw=rs.getString("zw");
String zc=rs.getString("zc");
String xl=rs.getString("xl");
String jfqk=rs.getString("jfqk");
String zyjl=rs.getString("zyjl");
String shjz=rs.getString("shjz");
String sf=rs.getString("sf");
%>
<p class="STYLE2"> <img src="99.gif"> 您的个人信息如下：</p>
<div align="center">
<table width="714" height="230" border="1">
<tr>
<td width="167" class="STYLE3" >员工编号</td>
<td width="176" class="STYLE3" ><%=id%></td>
<td width="167" class="STYLE3" >员工姓名</td>
<td width="176" class="STYLE3" ><%=name%></td>
</tr>
<tr>
<td class="STYLE3" >密码</td>
<td class="STYLE3" ><%=pass%></td>
<td class="STYLE3" >性别</td>
<td class="STYLE3" ><%=sex%></td>
</tr>
<tr>
<td class="STYLE3" >生日</td>
<td class="STYLE3" ><%=sr%></td>
<td class="STYLE3" >民族</td>
<td class="STYLE3" ><%=mz%></td>
</tr>
<tr>
<td class="STYLE3" >籍贯</td>
<td class="STYLE3" ><%=jg%></td>
<td class="STYLE3" >家庭出身</td>
<td class="STYLE3" ><%=jtcs%></td>
</tr>
<tr>
<td class="STYLE3" >部门</td>
<td class="STYLE3" ><%=bm%></td>
<td class="STYLE3" >职务</td>
<td class="STYLE3" ><%=zw%></td>
</tr>
<tr>
<td class="STYLE3" >职称</td>
<td class="STYLE3" ><%=zc%></td>
<td class="STYLE3" >基本工资</td>
<td class="STYLE3" ><%=jbgz%></td>
</tr>
<tr>
<td class="STYLE3" >学历</td>
<td class="STYLE3" ><%=xl%></td>
<td class="STYLE3" >奖罚情况</td>
<td class="STYLE3" ><%=jfqk%></td>
</tr>
<tr>
<td class="STYLE3" >主要经历</td>
<td class="STYLE3" ><%=zyjl%></td>
<td class="STYLE3" >社会兼职</td>
<td class="STYLE3" ><%=shjz%></td>
</tr>
</table>
</div>
<span class="STYLE3">
<%
rs.close();
stmt.close();
conn.close();
%>
</span>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -