📄 statesearch.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>
<style type="text/css">
<!--
body {
background-image: url(picture/background.JPG);
}
-->
</style></head>
<body>
<p align="center">房态查询：</p>
<p align="center">查询结果为：</p>
<table width="355" border="1" align="center">
<tr>
<td>
<%
String class1="";
String roomcode1="";
String roomstate1="";
String textfield1=request.getParameter("textfield");
//out.print(textfield1);
String checkbox=request.getParameter("checkbox");
String checkbox2=request.getParameter("checkbox2");
String checkbox3=request.getParameter("checkbox3");
String checkbox4=request.getParameter("checkbox4");
String checkbox5=request.getParameter("checkbox5");
String checkbox6=request.getParameter("checkbox6");
boolean key=false;
boolean key2=false;
boolean key3=false;
boolean key4=false;
boolean key5=false;
boolean key6=false;
int keynum=0;
/*out.print(checkbox);
out.print(checkbox2);
out.print(checkbox3);
out.print(checkbox4);
out.print(checkbox5);
out.print(checkbox6);*/
if(checkbox!=null)
{
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");
}
if(checkbox5!=null)
{
keynum++;
key5=true;
//out.print("checkbox5");
}
if(checkbox6!=null)
{
keynum++;
key6=true;
//out.print("checkbox6");
}
//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(key)
{
//condition=condition+"";
}else
{
if(keynum>=1)
{
condition=condition+"WHERE room.classno<0 ";
}
if(key2)
{
condition=condition+"OR (room.classno = 1000)";
}
if(key3)
{
condition=condition+"OR (room.classno = 2000)";
}
if(key4)
{
condition=condition+"OR (room.classno = 3000)";
}
if(key5)
{
condition=condition+"OR (room.classno = 4000)";
}
if(key6)
{
condition=condition+"OR (room.classno = 5000)";
}
}
//String condition="SELECT * FROM roomstate";
rs=stmt.executeQuery(condition);
out.print("<TR>");
out.print("<TD width=300>"+"房间类型");
out.print("<TD width=100>"+"房号");
out.print("<TD width=100>"+"状态");
out.print("<TD width=300>"+"客人数目");
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");
roomcode1=rs.getString("roomcode");
roomstate1=rs.getString("roomstate");
out.print("<TR>");
out.print("<TD>"+class1+"</TD>");
out.print("<TD>"+roomcode1+"</TD>");
out.print("<TD>"+roomstate1+"</TD>");
out.print("<TD>"+"0ren"+"</TD>");
out.print("</TR>");
}
stmt.close();
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
</td>
</tr>
</table>
<table width="200" border="1" align="center">
<tr>
<td><div align="center"><a href="index.htm">返回</a></div></td>
</tr>
</table>
<p> </p>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -