📄 kb.jsp
字号:
<style type="text/css">
<!--
.style1 {
font-size: 24px;
font-weight: bold;
}
-->
</style>
<body background="image/back.gif">
<form id="form1" name="form1" method="post" action="">
<div align="center" class="style1">课程选报 </div>
</form>
<form id="form2" name="form2" method="post" action="xbkc.jsp">
<label for="textfield">
<div align="center"></div>
</label>
<div align="center"><strong>选报课程ID号</strong>
<input type="text" name="kc_id" id="kc_id" />
</div>
<div align="center">
<p>
<label for="Submit"></label>
<input type="submit" name="Submit" value="提 交" id="Submit" />
</p>
<p> </p>
</div>
</form>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String user_id=(String)session.getAttribute("user_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 kecheng");
out.print("<table align=CENTER bgcolor=pink border='1' align=middle>");
out.print("<tr align=middle><td>课程ID<td>课程名称<td>起始时间<td>结束时间<td>上课时间<td>人数<td>课程难易程度<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_qs")+"</td>");
out.println("<td>"+rs.getString("kc_js")+"</td>");
out.println("<td>"+rs.getString("kc_ss")+"</td>");
out.println("<td>"+rs.getString("kc_rs")+"</td>");
out.println("<td>"+rs.getString("kc_ny")+"</td></tr>");
}
out.print("</table>");
}
catch(SQLException e)
{
out.println(e.getMessage());
}
finally
{
stmt.close();
conn.close();
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -