📄 lhh_deletingview.jsp
字号:
<%@ page language="java" import="java.sql.*" %>
<%!
Connection con=null;
int iBedId=0;
int iSroomId=0;
int iBedRealNum=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 sUpdate=null;
String sDelete=null;
String sSelectquery=null;
%>
<html>
<head></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 valign="top">
<td width="25%"><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%">
<%
try{
iBedId=Integer.parseInt(request.getParameter("bedId"));
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
sSelectquery="select * from bed where bed_id="+iBedId;
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sSelectquery);
if(rs.next()){
//while(rs.next())
//{
iSroomId=rs.getInt(2);
iBedStatus=rs.getInt(3);
if(iBedStatus==0){
sDelete="delete from bed where bed_id="+iBedId;
PreparedStatement ps = con.prepareStatement(sDelete);
ps.executeUpdate();
sSelectquery="select * from sickroom where sroom_id="+iSroomId;
Statement st2=con.createStatement();
ResultSet rs2=st2.executeQuery(sSelectquery);
while(rs2.next())
{
iBedRealNum=rs2.getInt(3);
}
rs2.close();
st2.close();
iBedRealNum--;
sUpdate="update sickroom set bed_real_num=? where sroom_id="+iSroomId;
ps = con.prepareStatement(sUpdate);
ps.setInt(1,iBedRealNum);
ps.executeUpdate();
ps.close();
out.println("Successfully Delete");
}
else{
out.println("Now you can not delete this bed!!");
}
//}
rs.close();
st.close();
}
else{
out.println("This bed is not exit,please choose another bed!");
}
}
catch(Exception ex)
{
System.out.println(ex);
}
%>
</td>
<td width="22%"><div class="relatedLinks" valign="top">
<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 + -