📄 kechengshezhi.jsp
字号:
<form name=login>
<body background="image/back.gif">
<table align=center width=90% cellspacing=0>
<tr><td align=center>管理员登录
<tr><td>
<table width=100% bgcolor>
<tr><td>
<tr><td align=center>
<input type=button onclick=UserEnter() value=课程设置和修改>
<input type=button onclick=ComEnter() value=选课结果查询>
<input type=button onclick=AdminEnter() value=成绩输入和查询>
<tr><td>
<tr><td align=center>
<input type=button onclick=Tj() value=添加课程>
<input type=button onclick=Xg() value=修改课程>
</table>
</table>
</form>
<script language=JavaScript>
function UserEnter()
{
window.location="kechengshezhi.jsp";
}
function ComEnter()
{
window.location="xuankecx.jsp"
}
function AdminEnter()
{
window.location="chengji.jsp"
}
function Tj()
{
window.location="tj.htm"
}
function Xg()
{
window.location="xg.htm"
}
</script>
<%@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 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 + -