login.jsp
上传用户:sanhemotor
上传日期:2010-01-25
资源大小:381k
文件大小:1k
- <%@ page session="true" %>
- <%@ page import="java.sql.* " %>
- <html>
- <head>
- <title>Book store</title>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
- <body bgcolor="#F4F5FF">
- <font face="Times New Roman,Time" size="+3"> 网上书店 </font>
- <hr><p><center>
- <%
- String name=request.getParameter("name");
- String pwd=request.getParameter("password");
-
- //try
- {String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
- Class.forName(sDBDriver);
- String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Web";
- String username="sa";
- String password="";
- Connection connWeb=DriverManager.getConnection(sConnStr,username,password);
- Statement stmt=connWeb.createStatement();
- String query="select Customer_ID from customer_info where Name='"+name+"' and Passwd='"+pwd+"'";
- ResultSet res=stmt.executeQuery(query);
- if(res.next())
- {
- Integer temp=new Integer(res.getInt(1));
- res.close();
- String customerid=temp.toString();
- session.putValue("loginSign","OK");
- session.putValue("cID",customerid);
- %>
- <%response.sendRedirect("list.jsp");%>
- <%
- }
- else
- {
- res.close();
- session.putValue("login_message","用户名或密码错误");
- %>
- <jsp:forward page="register.jsp"/>
- <%
- }
- }
- //catch(Exception e)
- {
- //e.getMessage();
- }
- %>
- </center>
- </body>
- </html>