⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admincourse3_0002ejsp_jsp.java

📁 网上选课程序:a.使用JSP/Servlet开发
💻 JAVA
📖 第 1 页 / 共 2 页
字号:
            // HTML // begin [file="/admincourse3.jsp";from=(18,2);to=(21,0)]
                out.write("\r\n\r\n\r\n");

            // end
            // begin [file="/admincourse3.jsp";from=(21,2);to=(51,0)]
                
                	//String strSQL = "select id ,title from news order by id desc";
                	//ResultSet rs = sts.executeQuery(strSQL);
                
                	String temstuname = new String();
                	temstuname = request.getParameter("select");
                	temstuname = temstuname.trim();
                	temstuname = trans(temstuname);
                	String temstuid = new String();
                	//String temstuno = new String();
                	String temstupsw = new String();//备注
                	String temstugrade = new String();//学分
                	String strSQL = "select couid ,coumark,couback from course where couname = '"+temstuname+"'";
                	ResultSet rs = subject.executeQuery(strSQL);
                	while(rs.next())
                	{
                			temstuid = rs.getString("couid");
                           // temstuno = rs.getString("stuno");
                			temstupsw=  rs.getString("couback");
                			temstugrade = rs.getString("coumark");
                	}
                
                	rs.close();
                
                	//String strSQL2 = "delete from news where id =" + k;
                    	//sts.executeUpdate(strSQL2);
                
                
                
                
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(51,2);to=(151,36)]
                out.write("\r\n<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link href=\"_notes/aaa.css\" rel=\"stylesheet\" type=\"text/css\">\r\n<style type=\"text/css\">\r\n<!--\r\n@import url(\"_notes/ccc\");\r\nbody,td,th {\r\n\tcolor: #FFFFFF;\r\n\tfont-weight: bold;\r\n\tfont-size: 12px;\r\n}\r\na:link {\r\n\tcolor: #FFFFFF;\r\n}\r\na:visited {\r\n\tcolor: #FFFFFF;\r\n}\r\n-->\r\n</style>\r\n</HEAD>\r\n<BODY BGCOLOR=#0D85A6 BACKGROUND=\"images/bg.gif\" >\r\n\r\n<br>\r\n<br>\r\n<TABLE WIDTH=750 height=\"494\" BORDER=0 align=\"center\" CELLPADDING=0 CELLSPACING=0>\r\n  <TR> \r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=231 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=4 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=75 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=105 HEIGHT=1></TD>\r\n    <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=5 HEIGHT=1></TD>\r\n  </TR>\r\n  <TR> \r\n    <TD COLSPAN=4> <IMG SRC=\"images/temp_01.jpg\" WIDTH=420 HEIGHT=15></TD>\r\n    <TD COLSPAN=4> <IMG SRC=\"images/temp_02.jpg\" WIDTH=330 HEIGHT=15></TD>\r\n  </TR>\r\n  <TR> \r\n    <TD COLSPAN=8> <IMG SRC=\"images/temp_03.jpg\" WIDTH=750 HEIGHT=5></TD>\r\n  </TR>\r\n  <TR> \r\n    <TD> \r\n      <table width=\"231\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"226\" background=\"images/left_top.jpg\">\r\n        <tr> \r\n          <td width=\"231\" valign=\"bottom\"> \r\n            <div align=\"center\">\r\n              <p><br>\r\n              </p>\r\n              <p>【课程管理】</p>\r\n              <p align=\"center\"> 再这里您可以添加<br>\r\n              或删除课程的信息 <br>\r\n              <br>\r\n              <br>\r\n              </p>\r\n              <table width=\"200\" border=\"1\">\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"adminteacher.jsp\">【教师<strong>管理</strong>】</a></div></td>\r\n                </tr>\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"adminstudent.jsp\">【学生管理】</a></div></td>\r\n                </tr>\r\n              </table>\r\n              <p>  <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n          </div>          </td>\r\n        </tr>\r\n      </table>\r\n    </TD>\r\n    <TD ROWSPAN=2> <IMG SRC=\"images/temp_05.jpg\" WIDTH=4 HEIGHT=455></TD>\r\n    <TD COLSPAN=5 ROWSPAN=2> \r\n      <table width=\"510\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"455\" background=\"images/main_bg.jpg\">\r\n        <tr> \r\n          <td width=\"510\"> \r\n            <table width=\"510\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"455\">\r\n              <tr> \r\n                <td width=\"510\" height=\"78\"> \r\n                  <div align=\"center\"><img src=\"images/blank_banner.gif\" width=\"468\" height=\"60\"></div>\r\n                </td>\r\n              </tr>\r\n              <tr> \r\n                <td valign=\"top\">                  <div align=\"left\"><a href=\"index1.htm\">首页</a>&gt;<a href=\"index3.jsp\">后台管理</a>&gt;<a href=\"admincourse.jsp\">课程管理</a>&gt;删改已有课程<br>\r\n                  <br>\r\n                  <br>\r\n                  <br>\r\n                  <table width=\"500\" border=\"1\" bordercolor=\"#006666\">\r\n                    <tr>\r\n                      <td><div align=\"center\">删改已有课程</div>                        <div align=\"center\"></div></td>\r\n                      </tr>\r\n                    <tr>\r\n                      <td height=\"248\"><div align=\"center\">\r\n                        <form name=\"form1\" method=\"post\" action=\"admincourse4.jsp\">\r\n                          <table width=\"250\" border=\"0\" bordercolor=\"#006666\">\r\n                            <tr bordercolor=\"#006666\">\r\n                              <td width=\"68\" height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n                                <div align=\"right\">课程编号</div></td>\r\n                              <td colspan=\"2\" background=\"images/bg.gif\">\r\n                                  <div align=\"left\">\r\n                                    ");

            // end
            // begin [file="/admincourse3.jsp";from=(151,38);to=(151,131)]
                 out.print("<input name=\"stuid\" type=\"hidden\" id=\"stuid\" value = \""+temstuid+"\">" ); 
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(151,133);to=(152,36)]
                out.write("\r\n                                    ");

            // end
            // begin [file="/admincourse3.jsp";from=(152,38);to=(152,59)]
                 out.print(temstuid);
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(152,61);to=(159,32)]
                out.write("\r\n                                  </div></td>\r\n                            </tr>\r\n                            <tr bordercolor=\"#006666\">\r\n                              <td height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n                                <div align=\"right\">课程名称</div></td>\r\n                              <td colspan=\"2\" background=\"images/bg.gif\">\r\n                                ");

            // end
            // begin [file="/admincourse3.jsp";from=(159,34);to=(159,132)]
                 out.print("<input name=\"stuname\" type=\"text\" id=\"stuname2\" value = \""+temstuname+"\">" ); 
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(159,134);to=(172,46)]
                out.write("\r\n</td>\r\n                            </tr>\r\n                            <tr bordercolor=\"#006666\">\r\n                              <td height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n                                <div align=\"right\">学分</div></td>\r\n                              <td colspan=\"2\" background=\"images/bg.gif\">\r\n                                <table width=\"174\" height=\"28\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                                  <tr>\r\n                                    <td width=\"69\" align=\"left\">\r\n                                        <div align=\"left\">                                        </div>\r\n                                        <div align=\"left\"><span class=\"bbb\">\r\n                                            <select name=\"stugrade\" id=\"stugrade\">\r\n                                              ");

            // end
            // begin [file="/admincourse3.jsp";from=(172,48);to=(185,40)]
                 String tem[] = new String[4];
                											tem[0]= new String("一学分");
                											tem[1]= new String("二学分");
                											tem[2]= new String("三学分");
                											tem[3]= new String("四学分");
                											 for (int i = 0; i < 4; i++){
                										if(i== Integer.parseInt(temstugrade)-1)
                                                                                        		{out.print("<option selected>" + tem[i].trim() + "</option>");
                																				System.out.println("qqqqqqqqqqqqqqqq");}
                										else
                							  				out.print("<option>" + tem[i].trim() + "</option>");
                							  }
                
                                                        
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(185,42);to=(197,34)]
                out.write("\r\n                                            </select>\r\n                                        </span> </div></td>\r\n                                    <td width=\"33\" class=\"bbb\"><div align=\"right\"></div></td>\r\n                                    <td width=\"72\" class=\"bbb\">&nbsp;</td>\r\n                                  </tr>\r\n                              </table>                                </td>\r\n                            </tr>\r\n                            <tr bordercolor=\"#006666\">\r\n                              <td height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n                                <div align=\"right\">备注</div></td>\r\n                              <td colspan=\"2\" bordercolor=\"#006666\" background=\"images/bg.gif\">\r\n                                  ");

            // end
            // begin [file="/admincourse3.jsp";from=(197,36);to=(197,129)]
                 out.print("<textarea name=\"stupsw\" rows=\"3\" id=\"couback\">"+temstupsw+"</textarea>" ); 
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(197,131);to=(207,32)]
                out.write("</td>\r\n                        \r\n\t\t\t\t\t\t    </tr>\r\n                            <tr>\r\n                              <td>&nbsp;</td>\r\n                              <td width=\"90\">\r\n                                  <div align=\"center\">\r\n                                    <input name=\"tijiao\" type=\"submit\" id=\"tijiao\" value=\"提交\">\r\n                                  </div></td>\r\n                              <td width=\"78\" bordercolor=\"#006666\"><div align=\"left\">\r\n                                ");

            // end
            // begin [file="/admincourse3.jsp";from=(207,34);to=(207,107)]
                out.print("<a href='admincourse5.jsp?delpage=" +temstuid + "'>删除信息</a>");
            // end
            // HTML // begin [file="/admincourse3.jsp";from=(207,109);to=(265,7)]
                out.write("\r\n</div></td>\r\n                            </tr>\r\n                          </table>\r\n                          </form>\r\n                        </div></td>\r\n                      </tr>\r\n                  </table>\r\n                  <br>\r\n                </div></td>\r\n              </tr>\r\n            </table>\r\n          </td>\r\n        </tr>\r\n      </table>\r\n    </TD>\r\n    <TD ROWSPAN=2> <IMG SRC=\"images/temp_07.jpg\" WIDTH=5 HEIGHT=455></TD>\r\n  </TR>\r\n  <TR> \r\n    <TD> \r\n      <table width=\"231\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"229\" background=\"images/left_bottom.jpg\">\r\n        <tr> \r\n          <td width=\"231\" height=\"222\" valign=\"top\"><div align=\"center\">\r\n            <p><font color=\"#2DFFFF\" size=\"5\"> </font></p>\r\n              <table width=\"200\" border=\"1\">\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"admintc.jsp\">【课程分配】</a></div></td>\r\n                </tr>\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"adminscore.jsp\">【成绩录入】</a></div></td>\r\n                </tr>\r\n                <tr>\r\n                  <td><div align=\"center\">【购书管理】</div></td>\r\n                </tr>\r\n              </table>\r\n              <br>\r\n              <br>\r\n              <table width=\"200\" border=\"0\">\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"adminlyb.jsp\">查看留言</a></div></td>\r\n                </tr>\r\n              </table>\r\n              <p align=\"center\"><br>\r\n              <a href=\"index1.htm\" class=\"ccc\">[退出系统]</a></p>\r\n              </div>\r\n          </td>\r\n        </tr>\r\n      </table>\r\n    </TD>\r\n  </TR>\r\n  <TR> \r\n    <TD COLSPAN=8> <IMG SRC=\"images/temp_09.jpg\" WIDTH=750 HEIGHT=5></TD>\r\n  </TR>\r\n  <TR> \r\n    <TD COLSPAN=8> <img src=\"images/temp_10.jpg\" width=752 height=20></TD>\r\n  </TR>\r\n</TABLE>\r\n</BODY>\r\n</HTML>");

            // end

        } catch (Throwable t) {
            if (out != null && out.getBufferSize() != 0)
                out.clearBuffer();
            if (pageContext != null) pageContext.handlePageException(t);
        } finally {
            if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
        }
    }
}

⌨️ 快捷键说明

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