📄 detailroom.jsp

📁 本源码
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
<p align="center">相应房间号列表如下:</p>
<form id="form1" name="form1" method="post" action="detailroom2.jsp">
  <p><label></label></p>
  <table width="166" border="1" align="center">
    <tr>
      <td width="156"><%
							 	
			//String textfield1=request.getParameter("textfield");  
			//out.print(textfield1);
			
			String select1=request.getParameter("select"); 
			String checkbox=request.getParameter("checkbox"); 
			String checkbox2=request.getParameter("checkbox2"); 
			String checkbox3=request.getParameter("checkbox3"); 
			String checkbox4=request.getParameter("checkbox4"); 

			boolean key=false;
			boolean key2=false;
			boolean key3=false;
			boolean key4=false;
			boolean keyselect1=false;
			
			int keynum=0;
			//out.print(select1);
			/*out.print(checkbox);
			out.print(checkbox2);
			out.print(checkbox3);
			out.print(checkbox4);*/
			
			if(select1.equals("0000"))
			{
				keynum++;
				keyselect1=true;
				//out.print("checkbox");
			}
		
			if(checkbox!=null)
			{
				keynum++;
				key=true;
				//out.print("checkbox");
			}
			if(checkbox2!=null)
			{
				keynum++;
				key2=true;
				//out.print("checkbox2");
			}
			if(checkbox3!=null)
			{
				keynum++;
				key3=true;
				//out.print("checkbox3");
			}
			if(checkbox4!=null)
			{
				keynum++;
				key4=true;
				//out.print("checkbox4");
			}

			//String[] id=request.getParameterValues("checkbox");
			//String ids=id[1];
			//for(int i=0;i<id.length;i++){
				//ids += "'"+id[i]+"'";
				//if(i!=id.length-1) ids+=", ";
			
			//} 
			
			//String textfield1=request.getParameter("textfield");   
			//String[]  checkbox=(String[])request.getParameterValues("checkbox");  
			//String checkbox1=request.getParameterValues("checkbox");
			//out.print(checkbox);
			//out.print(checkbox[1]);
			//int checkbox=0;
			//checkbox=request.getParameterValues("checkbox")
			//String   s[]=request.getParameterValues("checkbox");   
  			//for(int   i=0;i<s.length;i++)   
  			//{   
			//out.print(s[i]);
			
  			//sql="delete   from   tablename   where   id="+s[i];   
 			 //ResultSet   result5=conndb.executeQuery(sql);   
 			// }
			
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				String url="jdbc:odbc:lazy";
				String user="sa";
				String password="111";
				ResultSet rs=null;
				String deusername="";
				Connection con=DriverManager.getConnection(url,user,password);
				Statement stmt=con.createStatement();
					
				String condition="";

					//condition=condition+"SELECT roomclass.class, roomstate.roomcode, roomstate.roomstate FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode INNER JOIN roomclass ON room.classno = roomclass.classno ";
				/*if(keyselect1)
				{
			condition=condition+"SELECT roomcode FROM roomstate WHERE (class='"+select1+"') ";
			condition=condition+"AND (roomcode <0";
					
					if(key)
					{
						condition=condition+"OR (roomstate ='r')";
					}
					if(key2)
					{
						condition=condition+"OR (roomstate='l')";
					}
					if(key3)
					{
						condition=condition+"OR (roomstate ='o')";
					}
					if(key4)
					{
						condition=condition+"OR (roomstate ='z')";
					}
			condition=condition+")";
			
				}else
				{*/
					condition=condition+"SELECT roomcode FROM roomstate WHERE (roomcode<0) ";
					
					if(key)
					{
						condition=condition+"OR (roomstate ='r')";
					}
					if(key2)
					{
						condition=condition+"OR (roomstate='l')";
					}
					if(key3)
					{
						condition=condition+"OR (roomstate ='o')";
					}
					if(key4)
					{
						condition=condition+"OR (roomstate ='z')";
					}
					
				//}

					
				rs=stmt.executeQuery(condition);
				
				out.print("<TR>");
					out.print("<TD width=100>"+"房号");
				out.print("</TR>");
				

				while(rs.next())
				{
					//if(checkbox==1)
					//roomclass1=rs.getString("roomclass.class");
					//roomcode1=rs.getString("roomstate.roomcode");
					//roomstate1=rs.getString("roomstate.roomstate");
					//class1=rs.getString("class");
					String roomcode1=rs.getString("roomcode");
					//roomstate1=rs.getString("roomstate");
						out.print("<TR>");
						//out.print("<TD>"+class1+"</TD>");
						out.print("<TD>"+roomcode1);
						//+"</TD>");
						//out.print("<input type="+"radio" +"name="+"sex1" +"value="+"male"+" />");
						%>
          <input type="radio" name="sex1" value="<%=roomcode1%>" />
          <%
						out.print("</TR>");

					
				}
				
				stmt.close();
				con.close();
			
			}
			catch(SQLException e1)
			{
				out.print("SQL异常！");
			}
	
	%>
        &nbsp;</td>
    </tr>
  </table>
  <table width="166" border="1" align="center">
    <tr>
      <td><label>
        <input type="submit" name="Submit" value="提交" />
      </label></td>
      <td><label>
        <input type="reset" name="Submit2" value="重置" />
      </label></td>
      <td><a href="index.htm">返回</a></td>
    </tr>
  </table>
</form>
</body>

</html>
💿 文件大小 582 K
👤 上传用户 hushanlyn
📂 所属分类 Jsp/Servlet
🏷️ 相关标签

#源码
⌨️ 快捷键说明

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