mentlogin.jsp
上传用户:xjrzjk
上传日期:2022-07-31
资源大小:1585k
文件大小:1k
- <%@ 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";
- String strUid = request.getParameter("uid");
- String strPwd = request.getParameter("pwd");
- String strJs = "";
- Connection con = DriverManager.getConnection(strUrl, strUser, strPassword);
- Statement st = con.createStatement();
- 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="ment1.jsp" />
- <%
- }else{
- strJs = "alert('用户登录失败,请输入正确的帐号和密码重新登录!');";
- strJs += "window.location.href='ment.jsp';";
- }
- %>
- <html>
- <head>
- <title>
- mentlogin
- </title>
- <script language="javascript">
- <!--
- <%=strJs%>
- //-->
- </script>
- </head>
- <body bgcolor="#ffffff">
- </body>
- </html>
- <%
- }catch(Exception e){
- throw (e);
- }
- %>