login2.jsp

jsp图书管理系统

<%@page contentType="text/html;charset=gbk"%>
<%@page import="java.sql.*" %>
<%
	String susername=request.getParameter("username");
	
	String spassword=request.getParameter("password");
	String sselect=request.getParameter("select");

	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:booksystem");
	Statement sql=con.createStatement();
	
	ResultSet rs=sql.executeQuery("select * from customers  where username='"+susername+"' and password='"+spassword+"'");
	
	if(rs.next()&&sselect.equals("customer"))
		response.sendRedirect("mainframe.jsp");
	else
	{
	rs=sql.executeQuery("select * from admin  where username='"+susername+"' and password='"+spassword+"'");
	if(rs.next()&&sselect.equals("admin"))
		{response.sendRedirect("adminmainframe.jsp");}
	else
		response.sendRedirect("loginerror.jsp");
	}
	 
		
		
	con.close();
%>

<%
//获取登录时输入的用户名并储存起来
session.setAttribute("inputusername",susername);
%>