📄 lhh_queryingview.jsp
字号:
<%@ page language="java" import="java.sql.*, java.util.Date" %>
<%!
Connection con=null;
int iBedId=0;
int iSroomId=0;
int iBedStatus=0;
int iCheckInSeqnum=0;
int iSroomType=0;
float fBedFee=0;
int iBedNum=0;
int iBuySeqNun=0;
int iAttaBuyNum=0;
float fAttaPrice=0;
int iBedBuyNum=0;
float fBedPrice=0;
Date dBuyDate;
int iAttaAmount=0;
int iBedAmount=0;
int iStatisticBedNum=0;
String sCondition=null;
String sSelect=null;
String sSelectquery=null;
%>
<html>
<head>
<title>view querying</title>
</head>
<body>
<!--<@ include file="head.jsp"%>
<@ include file="foot.jsp"%> -->
<jsp:include page="../head.jsp" flush="true"/>
<table width="100%" height="100%" border="1">
<tr>
<td width="25%" valign="top"><div id="sectionLinks">
<h3>Section Links</h3>
<ul>
<li><a href="#">quering</a></li>
<li><a href="#">modifying</a></li>
<li><a href="#">adding</a></li>
<li><a href="#">buying</a></li>
<li><a href="#">deleting</a></li>
</ul>
</div>
</td>
<td width="53%" valign="top">
<%
try
{
sSelect=request.getParameter("querying");
//iBedId=Integer.parseInt(request.getParameter("bedId"));
//iSroomId=Integer.parseInt(request.getParameter("sroomId2"));
Class.forName("com.mysql.jdbc.Driver"); // MySQL driver to connect to MySQL database
con=DriverManager.getConnection("jdbc:mysql:///lenovo_db?user=root&password=amethyst"); // Connectin to database by giving databasename and giving deault username and password
if(sSelect.equals("abed")){
iBedId=Integer.parseInt(request.getParameter("bedId"));
sSelectquery="select * from Bed where Bed_id="+iBedId;
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sSelectquery);
while(rs.next())
{
iSroomId=rs.getInt(2);
iBedStatus=rs.getInt(3);
iCheckInSeqnum=rs.getInt(4);
}
out.println("bed ID :"+iBedId);
out.println("sickroom ID :"+iSroomId);
out.println("bed Status :"+iBedStatus);
out.println("check in seqnum :"+iCheckInSeqnum);
rs.close();
st.close();
}
else if(sSelect.equals("beds")){
sCondition=request.getParameter("condition");
if(sCondition.equals("no1"))
sSelectquery="select count(*) from bed where bed_status=0";
else if(sCondition.equals("no2"))
sSelectquery="select count(*) from bed,sickroom where bed.sroom_id=sickroom.sroom_id and sroom_type=1";
else if(sCondition.equals("no3"))
sSelectquery="select count(*) from bed,sickroom where bed.sroom_id=sickroom.sroom_id and sroom_type=2";
else
sSelectquery="select count(*) from bed,sickroom where bed.sroom_id=sickroom.sroom_id and sroom_type=3";
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sSelectquery);
while(rs.next())
{
iStatisticBedNum=rs.getInt(1);
}
out.println("bed number:"+iStatisticBedNum);
rs.close();
st.close();
}
else if(sSelect.equals("sickroom")){
iSroomId=Integer.parseInt(request.getParameter("sroomId"));
sSelectquery="select * from Sickroom where Sroom_id="+iSroomId;
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sSelectquery);
while(rs.next())
{
//iSroomId=rs.getInt(1);
iSroomType=rs.getInt(2);
//fBedFee=rs.getFloat(3);
//iBedNum=rs.getInt(4);
}
out.println("sickroom ID :"+iSroomId);
out.println("sickroom type :"+iSroomType);
//out.println("bed fee :"+fBedFee);
//out.println("bed number :"+iBedNum);
rs.close();
st.close();
}
else if(sSelect.equals("storage")){
sSelectquery="select * from Storage";
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sSelectquery);
while(rs.next())
{
iBedAmount=rs.getInt(1);
iAttaAmount=rs.getInt(2);
}
out.println("bed amount:"+iBedAmount);
out.println("attachments amount:"+iAttaAmount);
rs.close();
st.close();
}
else{
}
}
catch(Exception ex)
{
System.out.println(ex);
}
%>
</td>
<td width="22%" valign="top"><div class="relatedLinks">
<h3>Related Link Category</h3>
<ul>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
</ul>
</div>
</td>
</tr>
</table>
<jsp:include page="../foot.jsp" flush="true"/>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -