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:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/booksystem/db/bs.mdb;");
	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 idadmin='"+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);
%>