class_add.jsp

来自「它主要应用于教育系统」· JSP 代码 · 共 75 行

JSP
75
字号

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'class_add.jsp' starting page</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  <jsp:useBean id="test1" scope="application" class="test.Connect_db"/>
  <body>
  <FORM action="teacher/class_add_db.jsp" method="post">
    <%
    String sql1="select major from major";
    out.print("专业:		");
    Connection con=test1.getConnection(); 
    Statement stmt1=con.createStatement();
	ResultSet rs1=stmt1.executeQuery(sql1);
    %>
   <SELECT name="major">
<% while(rs1.next()){
%>
<OPTION value="<%=rs1.getString(1)%>" > <%=rs1.getString(1)%></OPTION>
<%}%>
</SELECT>

    
    <BR><BR>
<%   out.print("学期:	");
String sql2="select semester_id from semester";
Statement stmt2=con.createStatement();
	ResultSet rs2=stmt2.executeQuery(sql2);
%>
<SELECT name="semester_id">
<% while(rs2.next()){
%>
<OPTION value="<%=rs2.getInt(1)%>" ><%=rs2.getInt(1)%></OPTION>
<%}%>
</SELECT>


<BR><BR>
<%out.print("课程名:	");
String sql3="select cname from course";
Statement stmt3=con.createStatement();
ResultSet rs3=stmt3.executeQuery(sql3);
   %>
  
<SELECT name="cname">
<% while(rs3.next()){
%>
<OPTION value="<%=rs3.getString(1)%>" ><%=rs3.getString(1)%></OPTION>
<%}%> 
</SELECT>

<INPUT type="submit" value="提交">   
 </FORM>   
  </body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?