📄 initstate2.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>
<form id="form1" name="form1" method="post" action="initstate.jsp">
<table width="519" border="1" align="center">
<tr>
<td width="253"><input type="checkbox" name="checkbox" />
豪华套</td>
<td width="250"><input type="checkbox" name="checkbox2" />
总统套</td>
</tr>
<tr>
<td><input type="checkbox" name="checkbox3" />
标准间</td>
<td><input type="checkbox" name="checkbox4" />
三人间</td>
</tr>
<tr>
<td><input type="checkbox" name="checkbox5" />
单人间</td>
<td><input type="submit" name="Submit" value="选中房类详情" /></td>
</tr>
</table>
</form>
<form id="form2" name="form2" method="post" action="initstate2.jsp">
<table width="518" border="1" align="center">
<tr>
<td width="252"><input type="submit" name="Submit2" value="全部房类详情" /></td>
<td width="124"><input type="reset" name="Submit3" value="退出" /></td>
<td width="124"><a href="index.htm">返回</a></td>
</tr>
</table>
</form>
<p align="center"> </p>
<p align="center">查询结果为：</p>
<table width="618" height="26" border="1" align="center">
<tr>
<td><p>
<%
int roomnum=0;
int beds=0;
String classno1="";
String class1="";
String beds1="";
String price1="";
String wholenum1="";
String remarks1="";
//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");
boolean key=true;
boolean key2=true;
boolean key3=true;
boolean key4=true;
boolean key5=true;
int keynum=5;
/*out.print(checkbox);
out.print(checkbox2);
out.print(checkbox3);
out.print(checkbox4);
out.print(checkbox5);
out.print(checkbox6);*/
/*if(checkbox!=null)
{
key=true;
keynum++;
//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");
}*/
//Connection con;
//Statement sql;
//ResultSet rs;
/*try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到！");
}*/
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 * FROM roomclass ";
/*condition=condition+"SELECT * FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode INNER JOIN roomclass ON room.classno = roomclass.classno ";*/
if(keynum>=1)
{
condition=condition+"WHERE roomclass.classno<0 ";
}
if(key)
{
condition=condition+"OR (classno = 1000) ";
}
if(key2)
{
condition=condition+"OR (roomclass.classno = 2000)";
}
if(key3)
{
condition=condition+"OR (roomclass.classno = 3000)";
}
if(key4)
{
condition=condition+"OR (roomclass.classno = 4000)";
}
if(key5)
{
condition=condition+"OR (roomclass.classno = 5000)";
}
//String condition="SELECT * FROM roomstate";
//rs=stmt.executeQuery(condition);
//String condition="SELECT * FROM roomclass";
rs=stmt.executeQuery(condition);
out.print("<TR>");
out.print("<TD width=100>"+"房间类型");
out.print("<TD width=100>"+"房价");
out.print("<TD width=100>"+"床位数");
out.print("<TD width=100>"+"备注");
out.print("<TD width=100>"+"总房数");
out.print("<TD width=100>"+"可租房数");
out.print("</TR>");
while(rs.next()&&(keynum!=0))
{
classno1=rs.getString("classno");
class1=rs.getString("class");
beds1=rs.getString("beds");
price1=rs.getString("price");
wholenum1=rs.getString("wholenum");
remarks1=rs.getString("remarks");
//out.print("<TD width=100>"+classno1);
out.print("<TR>");
out.print("<TD>"+class1+"</TD>");
out.print("<TD>"+price1+"</TD>");
out.print("<TD>"+beds1+"</TD>");
out.print("<TD>"+remarks1+"</TD>");
out.print("<TD>"+"共"+wholenum1+"房间"+"</TD>");
out.print("<TD>"+wholenum1+"可租"+"</TD>");
out.print("</TR>");
/*out.print("<TR>");
//out.print("<TD>"+rs.getString("class")+"</TD>");
out.print("<TD>"+rs.getString("price")+"</TD>");
//out.print("<TD>"+rs.getString("beds")+"</TD>");
out.print("<TD>"+"2床位"+"</TD>");
//out.print("<TD>"+rs.getString("remarks")+"</TD>");
out.print("<TD>"+"remarks"+"</TD>");
out.print("<TD>"+"共"+rs.getString("remarks")+"房间"+"</TD>");
//out.print("<TD>"+rs.getString("")+"</TD>");
out.print("<TD>"+"可租房数"+"</TD>");
out.print("</TR>");*/
/*out.print("<TR>");
out.print("<TD>"+rs.getString("class")+"</TD>");
out.print("<TD>"+rs.getString("beds")+"</TD>");
out.print("<TD>"+rs.getString("price")+"</TD>");
out.print("<TD>"+"共"+rs.getString("remarks")+"房间"+"</TD>");
out.print("</TR>");*/
}
stmt.close();
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
</p></td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -