📄 initstate.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">
<!--
a:link {
color: #000000;
}
body {
background-image: url(picture/background.JPG);
}
-->
</style></head>
<%!
public String codeToString(String str)
{//处理中文字符串的函数
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%
%>
<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="250"><input type="reset" name="Submit3" value="重置" />
<a href="index.htm">返回</a></td>
</tr>
</table>
</form>
<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="";
/*int rnum1000=0;
int rnum2000=0;
int rnum3000=0;
int rnum4000=0;
int rnum5000=0;*/
int rnum[]={0,0,0,0,0,0,0};
//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=false;
boolean key2=false;
boolean key3=false;
boolean key4=false;
boolean key5=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;
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 condition2="SELECT room.classno, roomstate.roomstate FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode WHERE roomstate.roomstate='r' AND (room.classno =1000)";
rs=stmt.executeQuery(condition2);
while(rs.next())
{
rnum[1]++;
}
//out.print(rnum[1]);
condition2="SELECT room.classno, roomstate.roomstate FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode WHERE roomstate.roomstate='r' AND (room.classno =2000)";
rs=stmt.executeQuery(condition2);
while(rs.next())
{
rnum[2]++;
}
//out.print(rnum2000);
condition2="SELECT room.classno, roomstate.roomstate FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode WHERE roomstate.roomstate='r' AND (room.classno =3000)";
rs=stmt.executeQuery(condition2);
while(rs.next())
{
rnum[3]++;
}
//out.print(rnum3000);
condition2="SELECT room.classno, roomstate.roomstate FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode WHERE roomstate.roomstate='r' AND (room.classno =4000)";
rs=stmt.executeQuery(condition2);
while(rs.next())
{
rnum[4]++;
}
//out.print(rnum4000);
condition2="SELECT room.classno, roomstate.roomstate FROM roomstate INNER JOIN room ON roomstate.roomcode = room.roomcode WHERE roomstate.roomstate='r' AND (room.classno =5000)";
rs=stmt.executeQuery(condition2);
while(rs.next())
{
rnum[5]++;
}
//out.print(rnum5000);
String condition="";
condition=condition+"SELECT * FROM roomclass ";
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)";
}
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))
{
int classnoint=rs.getInt("classno");
//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>"+rnum[(classnoint/1000)]+"可租"+"</TD>");
//String id=classno1;
//String id=codeToString("5000 ");
//Integer ddd=new Integer(Integer.parseInt(classno1));
//int xdd=ddd.intValue();
//String a=codeToString(classno1);
//String s="10000";
//s=classno1;
//int xdd=Integer.parseInt(s);
//int xdd=Integer.parseInt((String)classno1);
//out.print(classno1);///
//if(classno1.equals("1000"))out.print("-----------");else out.print("+++++++");
//if(classnoint==1000)out.print("-----------");else out.print("+++++++");
out.print("</TR>");
}
stmt.close();
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
</p></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -