orderloginsb.jsp
上传用户:xjrzjk
上传日期:2022-07-31
资源大小:1585k
文件大小:2k
- <%@ page contentType="text/html; charset=GBK" %>
- <%@ page import="java.sql.*"%>
- <%
- try{
- //数据库连接
- Class.forName("oracle.jdbc.driver.OracleDriver");
- String strUrl = "jdbc:oracle:thin:@slight:1521:LOCAL";
- String strUser = "eshop";
- String strPassword = "eshop";
- Connection con = DriverManager.getConnection(strUrl, strUser, strPassword);
- Statement st = con.createStatement();
- //获取用户名及密码
- String strUID = request.getParameter("uid");
- String strPWD = request.getParameter("pwd");
- String sql = "select * from reguser where userid = '" + strUID + "' and pwd = '" + strPWD + "'" ;
- ResultSet rs = st.executeQuery(sql);
- //判断数据库中是否已有此用户
- if(rs.next()){
- request.getSession(true).setAttribute("LoginSuccess",rs.getString("userid"));
- %>
- <jsp:forward page="index.jsp" />
- <%
- }else{
- %>
- <html>
- <head>
- <title>
- orderloginsb
- </title>
- <link rel="stylesheet" type="text/css" href="style.css">
- </head>
- <body bgcolor="#ffffff">
- <TABLE cellSpacing=1 cellPadding=4 width=306 bgColor=#416327 height="100" align="center">
- <TBODY>
- <TR vAlign=top bgColor=#eeeeee>
- <TD width="292" height="53">
- <p align="center"><br>
- 用户登录失败,请输入正确账号和密码重新登录!</p>
- </TD></TR>
- <TR bgColor=#eeeeee>
- <TD width="292" height="27">
- <DIV align=center><INPUT class=main type=submit size=3 value=返回 name=Submit2 onclick="javascript:window.history.go(-1)">
- </DIV></TD></TR></TBODY></TABLE>
- <%
- }
- %>
- </body>
- </html>
- <%
- }catch(Exception e){
- //错误处理
- throw (e);
- }
- %>