📄 807c90933f52001d1ff5bccdca24d2c1

📁 酒店预订系统具有登录

💻

字号:

<%@ 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>
<form>
<body>
<%
String username1=request.getParameter("username1");
username1=new String(username1.getBytes("ISO8859-1"),"GB2312");
String password1=request.getParameter("password1");
password1=new String(password1.getBytes("ISO8859-1"),"GB2312");
String sql="select * from 管理员表";
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);%>
<%if(username1 != null  && password1 != null){
         sql="select * from 管理员表 where  username='"+username1+"' and password='"+password1+"'";
        ResultSet rs=stmt.executeQuery(sql);%>
     <%while(rs.next()){%>
          用户名:<input type="text" name="username1" values=<%=rs.getString("username")%>><br>
          密码:<input type="passwoud" name="password1" values=<%=rs.getString("password")%>><br>
<%response.sendRedirect("zhuce.jsp");      
rs.close();
stmt.close();
conn.close();
}
}%>
</body>
</form>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -