📄 b087c5e1da52001d1ae3aaac3a26ea5a

📁 酒店预订系统具有登录
💻
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<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>
<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+"')";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hotemanaga";
Connection conn=DriverManager.getConnection(url,"sa","");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
sql="select * from 房间表";
ResultSet rs=stmt.executeQuery(sql);%>
<%while(rs.next()){%>
      房间号:<input type="text" name="fjid1" value=<%=rs.getString("fjid")%>><br>
    床位数量:<input type="text" name="cwcount1" value=<%=rs.getString("cwcount")%>><br>
    房间级别:<input type="text" name="fjjb1" value=<%=rs.getString("fjjb")%>><br>
    房间位置:<input type="text" name="fjwz1" value=<%=rs.getString("fjwz")%>><br>
    房间面积:<input type="text" name="fjmj1" value=<%=rs.getString("fjmj")%>><br>
    房间单价:<input type="text" name="fjdj1" value=<%=rs.getString("fjdj")%>><br>   
        折扣:<input type="text" name="zk1" value=<%=rs.getString("zk")%>><br>
        备注:<input type="text" name="bz1" value=<%=rs.getString("bz")%>><br>
  是否已预订:<input type="text" name="sfyyd1" value=<%=rs.getString("sfyyd")%>><br>
<%}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
⌨️ 快捷键说明

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