📄
字号:
范例manager_meeting_person_left.jsp源代码
001<%@ page errorPage="ErrPage.jsp"
002 import="Java.util.Date, Java.sql.*"
003 contentType="text/html;charset=gb2312"%>
004<JSP:useBean id="pool" scope="application" class="com.PoolBean"/>
005 <!--利用JAVABEAN连接数据库-->
006<%
0007String strLoginUser = (String)session.getAttribute("LoginUser");
008if (strLoginUser == null || strLoginUser.length() == 0)
009 response.sendRedirect("../Login.jsp");
010%>
011<HTML>
012<HEAD>
013<LINK REL="stylesheet" HREF="../littleproject.css" TYPE="text/css">
014<script language="JavaScript" type="text/Javascript">
015<!--
016function onClickRadio()
017{
018 var meeting_name="";
019 meeting_name=meeting_kind.value;
020 if (meeting_name.length >0)
021 {
022 parent.main.location.replace
023 ("manager_meeting_person_right.jsp?num="+meeting_name);
024 }
025}
026-->
027</script>
028<TITLE>会议人员管理</TITLE>
029</HEAD>
030<BODY bgcolor=LightBlue>
031<%
032try{
033 if (pool.getConnectionSize() == 0)
034 {
035 pool.initializePool();
036 }
037 Connection con = null;
038 Statement stmt = null;
039 ResultSet rs=null;
040 con = pool.getConnection();
041 stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
042 ResultSet.CONCUR_READ_ONLY);
043 //建立Statement对象, 并设置记录指标类型为可前后移动
044 String sql=null;
045 sql="SELECT id,num,title FROM meeting order by num desc";
046 rs = stmt.executeQuery(sql);
047%>
048<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue width=200>
049 <tr>
050 <TD bgcolor=LightYellow width=200 align=center>会议主题</TD>
051 </tr>
052<%
053out.println("<TR>");
054out.println("<TD width=200>");
055out.println("<select name=meeting_kind size=29 onclick=\"onClickRadio()\"
056 style=\"background-color: LightBlue;border-style: solid; border-width: 0;
057 width:100%;font-size: 12pt\">");
058while(rs.next())
059{
060 int select_id = rs.getInt("id");
061 int select_num = rs.getInt("num");
062 String select_title= rs.getString("title");
063 out.println("<option value="+select_num+">" + select_title +"</option>");
064}
065 out.println("</select>");
066 out.println("</TD>");
067 out.println("</TR>");
068%>
069</TABLE>
070<%
071 if (rs != null) rs.close();
072 pool.releaseConnection(con);
073}
074catch(Exception e)
075{
076 System.out.println("Exception: " + e.getMessage());
077}
078 %>
079</BODY>
080</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -