📄 c0cc396b7051001d1faaab6f587d3124

📁 酒店预订系统具有登录

💻

字号:

<%@ 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>
<%
String yhname1=request.getParameter("yhname1");
String sex1=request.getParameter("sex1");
String yhid1=request.getParameter("yhid1");
String gj1=request.getParameter("gj1");
String dh1=request.getParameter("dh1");
String zz1=request.getParameter("zz1");
String bz1=request.getParameter("bz1");
String sql="insert into 用户表 values('"+yhname1+"','"+sex1+"','"+yhid1+"','"+gj1+"','"+dh1+"','"+zz1+"','"+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);%>
<table bgcolor="d1d1ff" align="center" bordercolor="#7188e0">
<tr bgcolor="d1d1ff"><Th width="100">用户名：</Th>
<th width="180">性别：</th><th widty="112">身份证号：</th>
<th width="112">国籍：</th><th widty="150">电话：</th>
<th width="150">住址：</th><th widty="210">备注：</th>
</tr>
<%while(rs.next()){%>
 <tr bgcolor="#f8f8f8" class=time>     <td><%=rs.getString("yhname")%></td>
<td><%=rs.getString("sex")%></td><td><%=rs.getString("yhid")%></td>
<td><%=rs.getString("gj")%></td><td><%=rs.getString("dh")%></td>
<td><%=rs.getString("zz")%></td><td><%=rs.getString("备注")%></td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -