📄 studentwsxk2.jsp

📁 网上选课程序：a.使用JSP/Servlet开发

💻 JSP

字号:

<%@ page language = "java" contentType = "text/html;charset=gb2312"%>
<%@ page import = "java.sql.*, java.io.*" %>
<jsp:useBean id="sts" scope="page" class="wsxk.ConDB"/>

<%
	String strSQL1 = "select scid from sc order by scid asc";
	ResultSet rs2 = sts.executeQuery(strSQL1);
	String MaxID = new String();
	int id1 = 0;
	while(rs2.next())
	{
		id1 = rs2.getInt("scid");
	}
	/*int k = 0;
	for (k = 0; k < 999999; k++)
	{
 	  if (id.equals(MaxID.valueOf(k)))
		break;
	}
	++k;
	if (k >= 999999)
		k = 1;
	id = MaxID.valueOf(k);*/
	id1++;
	System.out.println("id1" + id1);
rs2.close();
%>

<%
String couid = new String();
String teaid = new String();

String tcid = new String (request.getParameter("xuan"));
System.out.println (tcid);
int id =  Integer.parseInt(tcid);
System.out.println (id);
String sql = "select  tcid,teaid,couid from tc where tcid = "+id+"";
ResultSet rs = sts.executeQuery(sql);
while(rs.next())
{
  	couid = rs.getString("couid");
	teaid = rs.getString("teaid");

}
%>
<%
String sql2 = "insert into sc(scid,teaid,couid,stuid) values("+id1+",'"+teaid+"','"+couid+"','"+session.getValue("wnum")+"')";
sts.executeUpdate(sql2);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta HTTP-EQUIV=REFRESH CONTENT="5; URL=studentwsxk.jsp">
<link href="_notes/aaa.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("_notes/ccc");
body,td,th {
	font-size: 12px;
	color: #FFFFFF;
	font-weight: bold;
}
.style1 {color: #000000}
-->
</style>
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
<div align="center">
  <p align="center">    <br>
  您已经成功选取该课程，本页将于5秒内自动<a href="studentwsxk.jsp" class="style1">返回前页</a>  </p>
  <p><br>
    <img src="images/index_globe.jpg" width="760" height="186"></p>
</div>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -