pview.jsp

一个自已编写的用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;
}
body {
	background-color: #CCCCFF;
}
-->
</style>
<div align="center"><span class="STYLE1">DSY 人事管理系统</span></div>
<form name="form1" method="post" action="">
  <table align="center" width="502" border="1">
    <tr>
      <td width="70"><div align="center">职工编号</div></td>
      <td width="294"><div align="center">人员变动信息</div></td>
      <td width="116"><div align="center">该职工详细信息</div></td>
    </tr>
 <%
 request.setCharacterEncoding("GBK");
 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";
   String sql=(String)session.getAttribute("sql2");
    rs=stmt.executeQuery(sql);
    session.setAttribute("sql2","");
 }
 catch(SQLException e)
 {
    out.println(e.getMessage());
 }
	 while(rs.next())
	    {
		    id=rs.getString("id");
		    out.println("<tr>");
			out.println("<td>"+id+"</td>");
			out.println("<td>"+rs.getString("bdxx")+"</td>");
			out.println("<td><a href='pview2.jsp?id="+id+"'>"+"该员工信息"+"</a></td>");
			out.println("</tr>");
		}
		rs.close();
		stmt.close();
		conn.close();

%>

  </table>
</form>
<p>&nbsp;</p>