📄 5078bec31a52001d1ff5bccdca24d2c1

📁 酒店预订系统具有登录
💻
字号:
<%@ 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 background="image/l2.jpg">
<%
String yhname1=request.getParameter("yhname1");
yhname1=new String(yhname1.getBytes("ISO8859-1"),"GB2312");
String yhid1=request.getParameter("yhid1");
yhid1=new String(yhid1.getBytes("ISO8859-1"),"GB2312");
String fjid1=request.getParameter("fjid1");
fjid1=new String(fjid1.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 fjdj1=request.getParameter("fjdj1");
fjdj1=new String(fjdj1.getBytes("ISO8859-1"),"GB2312");
String rzrq1=request.getParameter("rzrq1");
rzrq1=new String(rzrq1.getBytes("ISO8859-1"),"GB2312");
String zk1=request.getParameter("zk1");
zk1=new String(zk1.getBytes("ISO8859-1"),"GB2312");
String tfrq1=request.getParameter("tfrq1");
tfrq1=new String(tfrq1.getBytes("ISO8859-1"),"GB2312");
String bz1=request.getParameter("bz1");
bz1=new String(bz1.getBytes("ISO8859-1"),"GB2312");
String sql="insert into 预订信息表 values('"+yhname1+"','"+yhid1+"','"+fjid1+"','"+fjjb1+"','"+fjdj1+"','"+rzrq1+"','"+zk1+"','"+tfrq1+"','"+bz1+"')";
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);%>
  用户名:<input type="text" name="yhname1"><br>
    身份证号:<input type="text" name="yhid1"><br>
      房间号:<input type="text" name="fjid1"><br>
    房间级别:<input type="text" name="fjjb1"><br>
    房间位置:<input type="text" name="fjwz1"><br>
    房间单价:<input type="text" name="fjdj1"><br>
    入住日期:<input type="text" name="rzrq1"><br>
        折扣:<input type="text" name="zk1"><br>
    退房日期:<input type="text" name="tfrq1"><br>
        备注:<input type="text" name="bz1"><br>
<%while(rs.next()){%>
<tr bgcolor="#f8f8f8" class=time >      <td><%=rs.getString("yhname")%></td>
<td><%=rs.getString("yhid")%></td>
<td><%=rs.getString("fjid")%></td>
<td><%=rs.getString("fjjb")%></td>
<td><%=rs.getString("fjwz")%></td>
<td><%=rs.getString("fjdj")%></td>
<td><%=rs.getString("rzrq")%></td>
<td><%=rs.getString("zk")%></td>
<td><%=rs.getString("tfrq")%></td>
<td><%=rs.getString("bz")%></td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
⌨️ 快捷键说明

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