xuankecx.jsp

来自「jsp+acess+tomcat6.0 编写的员工培训管理系统 供初学者参考」· JSP 代码 · 共 46 行

<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%
       Connection conn=null;
       Statement stmt=null;
       ResultSet rs=null;
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 ");
        out.print("<table align=CENTER bgcolor=pink border='1' align=middle>");
        out.print("<tr align=middle><td>课程ID<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("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();
}
%>