📄 lhh_addingview.jsp
字号:
<%@ page language="java" import="java.sql.*" %>
<%!
Connection con=null;
int iBedId=0;
int iBedStatus=0;
int iCheckInSeqnum=0;
int iSroomId=0;
int iSroomType=0;
int iBedNum=0;
int iBedRealNum=0;
//String sSelect=null;
String sInsert=null;
String sUpdate=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{
iSroomId=Integer.parseInt(request.getParameter("sroomId"));
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 sickroom where sroom_id="+iSroomId;
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sSelectquery);
if(rs.next()){
while(rs.next())
{
iBedRealNum=rs.getInt(3);
iSroomType=rs.getInt(2);
}
rs.close();
st.close();
if(iSroomType==1){
iBedNum=4;
}
else if(iSroomType==2){
iBedNum=2;
}
else {
iBedNum=1;
}
if(iBedRealNum<iBedNum){
sSelectquery="select max(bed_id) from bed ";
Statement st1=con.createStatement();
ResultSet rs1=st1.executeQuery(sSelectquery);
while(rs1.next())
{
iBedId=rs1.getInt(1);
}
rs1.close();
st1.close();
iBedId++;
iBedStatus=0;
iCheckInSeqnum=0;
sInsert="insert into bed values(?,?,?,?)";
PreparedStatement ps = con.prepareStatement(sInsert);
ps.setInt(1,iBedId);
ps.setInt(2,iSroomId);
ps.setInt(3,iBedStatus);
ps.setInt(4,iCheckInSeqnum);
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(2);
}
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 Inserted");
}
else{
out.println("This sickroom is full,please choose another sickroom!");
}
}
else{
out.println("This sickroom is not exit,please choose another sickroom!");
}
}
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 + -