kccx.jsp

jsp+acess+tomcat6.0 编写的员工培训管理系统 供初学者参考

%@p<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%
       Connection conn=null;
       Statement stmt=null;
       ResultSet rs=null;
       String kc_id = request.getParameter("kc_id");
try
{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
      out.println(ce.getMessage());
}
/*requset.setCharacterEncoding("GB2312");*/
try
{
        conn=DriverManager.getConnection("jdbc:odbc:movie");
        stmt=conn.createStatement();
        rs=stmt.executeQuery("SELECT * FROM xuanke  where kc_id='"+kc_id+"' ");
        out.print("<table align=CENTER bgcolor=pink border='1' align=middle>");
        out.print("<tr align=middle><td>课程ID<td>课程名称<td>课程成绩<td>员工名称<td>员工ID<td>");
        while(rs.next())
        {
                  out.println("<tr><td>"+rs.getString("kc_id")+"</td>");   

                  out.println("<td>"+rs.getString("kc_mc")+"</td>");
                  out.println("<td>"+rs.getString("kc_cj")+"</td>");
                  out.println("<td>"+rs.getString("user_name")+"</td>");    
                  out.println("<td>"+rs.getString("user_id")+"</td>");
           




        }
        out.print("</table>");
}
catch(SQLException e)
{
out.println(e.getMessage());
}
finally
{
stmt.close();
conn.close();
}
%>