📄 stu1.jsp

📁 酒店预订系统具有登录
💻 JSP
字号:
<%@ 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="stu.jsp" class="style4">返回</a>
<%
String xh1=request.getParameter("xh1");
xh1=new String(xh1.getBytes("ISO8859-1"),"GB2312");
String xm1=request.getParameter("xm1");
xm1=new String(xm1.getBytes("ISO8859-1"),"GB2312");
String xb1=request.getParameter("xb1");
xb1=new String(xb1.getBytes("ISO8859-1"),"GB2312");
String nl1=request.getParameter("nl1");
nl1=new String(nl1.getBytes("ISO8859-1"),"GB2312");
String zzmm1=request.getParameter("zzmm1");
zzmm1=new String(zzmm1.getBytes("ISO8859-1"),"GB2312");
String bh1=request.getParameter("bh1");
bh1=new String(bh1.getBytes("ISO8859-1"),"GB2312");
String jtzz1=request.getParameter("jtzz1");
jtzz1=new String(jtzz1.getBytes("ISO8859-1"),"GB2312");
String sql="insert into xsb values('"+xh1+"','"+xm1+"','"+xb1+"','"+nl1+"','"+zzmm1+"','"+bh1+"','"+jtzz1+"')";
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 xsb";
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("xh")%></td>
<td><%=rs.getString("xm")%></td><td><%=rs.getString("xb")%></td>
<td><%=rs.getString("nl")%></td><td><%=rs.getString("zzmm")%></td>
<td><%=rs.getString("bh")%></td><td><%=rs.getString("jtzz")%></td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
 </table>
 </form>
</body>
</html>
⌨️ 快捷键说明

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