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

📄 meeting_detail.jsp

📁 一个ＪＳＰ范例
💻 JSP
字号:
🔍 
<%@ page errorPage="ErrPage.jsp"
         import="java.util.Date, java.sql.*"
         contentType="text/html;charset=gb2312"%>
<jsp:useBean id="pool" scope="application" class="com.PoolBean"/>
   <!--利用JAVABEAN连接数据库-->
<%
String strLoginUser = (String)session.getAttribute("LoginUser");
if (strLoginUser == null || strLoginUser.length() == 0)	
	response.sendRedirect("Login.jsp");	
%>
<HTML>
<HEAD>
<LINK REL="stylesheet" HREF="littleproject.css" TYPE="text/css">
<TITLE>记录的分页显示</TITLE>
</HEAD>
<BODY bgcolor=LightBlue>
<%
try{
    String meeting_title="";
	String meeting_touchman="";
	String meeting_touchtel="";
	String meeting_touchaddress="";
	String meeting_remark="";
	String meeting_touchemail="";
	String num = request.getParameter("num");		  
	if (pool.getConnectionSize() == 0)
	{
	    pool.initializePool();
	}	
	Connection con = null;
	Statement stmt = null;
    ResultSet  rs=null;		
	con = pool.getConnection();
	stmt= con.createStatement();
	//建立Statement对象, 并设置记录指标类型为可前后移动
	String sql=null;	
	//利用For循环配合PageSize属性输出一页中的记录
	sql="select title,touch_man,touch_tel,touch_address,remark,touch_email from meeting where num="+num;
	rs = stmt.executeQuery(sql);
	if(rs.next())
	{
	  meeting_title=rs.getString("title");
      meeting_touchman=rs.getString("touch_man");
	  meeting_touchtel=rs.getString("touch_tel");
	  meeting_touchaddress=rs.getString("touch_address");
	  meeting_remark=rs.getString("remark");
	  meeting_touchemail=rs.getString("touch_email");
	}
%>
<center>
<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue width=700>
    <tr>
      <td colspan="2" align="center">
	   <font size="6pt" face="隶书"><%=meeting_title%>简要情况</font>
	  </td>
	</tr>
</TABLE>
<TABLE border=0 width=700>
	<tr>
      <td align="center"><%=meeting_remark%></td>
	</tr>
	<tr>
	  <td width="700" align="right">
	    <font color="red">联系人:</font><%=meeting_touchman%> 
	  </td>
	</tr>
	<tr>
	  <td width="700" align="right">
	    <font color="red">通信地址:</font><%=meeting_touchaddress%>
	  </td>
	</tr>
	<tr>
	  <td width="700" align="right">
	    <font color="red">联系电话:</font><%=meeting_touchtel%>
	  </td>
	</tr>
	<tr>
	  <td width="700" align="right">
	    <font color="red">邮箱地址:</font><%=meeting_touchemail%>
	  </td>
   </tr>
</TABLE>
<%
boolean join_meeting=false;
String user_name="";
if (strLoginUser != null && strLoginUser.length() != 0)
{
   sql="select name from user where code ='"+strLoginUser+"'";
   rs = stmt.executeQuery(sql);
   if(rs.next())
   {
      user_name=rs.getString("name");
   }
}
else
{
   response.sendRedirect("Login.jsp");
}
sql="select name from meetingperson where num ="+num+" and name='"+user_name+"'";
rs = stmt.executeQuery(sql);
if(rs.next())
{
  join_meeting=true;
}
%>
<TABLE width=700>
    <tr>
      <td align="center">
<%
if(join_meeting)
{
%>
	    <font color=red><b>我是会议成员</b></font>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<a href="checkout_meeting.jsp?num=<%=num%>&title=<%=meeting_title%>">
           我退出会议</a>
<%
}
else
{
%>
	    <a href="checkin_meeting.jsp?num=<%=num%>&title=<%=meeting_title%>">
          我要参加会议</a>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<font color=red><b>我还没有参加此会议</b></font>
<%
}
%>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<a href="default.jsp">返回首页</a>
	  </td>
	</tr>
</TABLE>
</CENTER>
<%
	if (rs != null) rs.close();
	pool.releaseConnection(con);
}
catch(Exception e)
{
	System.out.println("Exception: " + e.getMessage());
}
%>
</BODY>
</HTML>

⌨️ 快捷键说明

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