📄 add1.jsp

📁 酒店预订系统具有登录
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:directive.page import="hote.query"/>

<html>
 <head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>无标题文档</title>
<LINK href=style.css type=text/css rel=stylesheet>
</head>
<body>
<form>
<jsp:useBean id="connBean" scope="page" class="hote.query"/>



<a href="bianji.jsp" class="style4">返回</a>
<%
String fjid1=request.getParameter("fjid1");
fjid1=new String(fjid1.getBytes("ISO8859-1"),"GB2312");
String cwcount1=request.getParameter("cwcount1");
cwcount1=new String(cwcount1.getBytes("ISO8859-1"),"GB2312");
String fjjb1=request.getParameter("fjjb1");
fjjb1=new String(fjjb1.getBytes("ISO8859-1"),"GB2312");
String fjwz1=request.getParameter("fjwz1");
fjwz1=new String(fjwz1.getBytes("ISO8859-1"),"GB2312");
String fjmj1=request.getParameter("fjmj1");
fjmj1=new String(fjmj1.getBytes("ISO8859-1"),"GB2312");
String fjdj1=request.getParameter("fjdj1");
fjdj1=new String(fjdj1.getBytes("ISO8859-1"),"GB2312");
String zk1=request.getParameter("zk1");
zk1=new String(zk1.getBytes("ISO8859-1"),"GB2312");
String bz1=request.getParameter("bz1");
bz1=new String(bz1.getBytes("ISO8859-1"),"GB2312");
String sfyyd1=request.getParameter("sfyyd1");
sfyyd1=new String(sfyyd1.getBytes("ISO8859-1"),"GB2312");
String sql="insert into 房间表 values('"+fjid1+"','"+cwcount1+"','"+fjjb1+"','"+fjwz1+"','"+fjmj1+"','"+fjdj1+"','"+zk1+"','"+bz1+"','"+sfyyd1+"')";
connBean.executeUpdate(sql);
sql="select * from 房间表";
%>
<%while(connBean.executeQuery(sql).next()){%>
      房间号:<input type="text" name="fjid1" value=<%=connBean.executeQuery(sql).getString("fjid")%>><br>
    床位数量:<input type="text" name="cwcount1" value=<%=connBean.executeQuery(sql).getString("cwcount")%>><br>
    房间级别:<input type="text" name="fjjb1" value=<%=connBean.executeQuery(sql).getString("fjjb")%>><br>
    房间位置:<input type="text" name="fjwz1" value=<%=connBean.executeQuery(sql).getString("fjwz")%>><br>
    房间面积:<input type="text" name="fjmj1" value=<%=connBean.executeQuery(sql).getString("fjmj")%>><br>
    房间单价:<input type="text" name="fjdj1" value=<%=connBean.executeQuery(sql).getString("fjdj")%>><br>   
        折扣:<input type="text" name="zk1" value=<%=connBean.executeQuery(sql).getString("zk")%>><br>
        备注:<input type="text" name="bz1" value=<%=connBean.executeQuery(sql).getString("bz")%>><br>
  是否已预订:<input type="text" name="sfyyd1" value=<%=connBean.executeQuery(sql).getString("sfyyd")%>><br>
<%}
connBean.executeQuery(sql).close();

%>

</form>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -