username=new String(username.getBytes("ISO8859_1"), "GBK");
String pwd=request.getParameter("pwd");
//out.print(username+pwd);
String spath="\\database\\data.mdb"; //注意由网站根到文件的路径，用到了转义字符
String dbpath = application.getRealPath(spath); //转化成物理路径
String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from admin where username='"+username+"' and password='"+pwd+"'";
//out.print(sql);
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
session.setAttribute("name",username);
out.print("登陆成功！");
%>
<jsp:forward page="main1.jsp"/>
<%
}
else
{
out.print("用户名或密码错误，请重新登陆！");
}
rs.close();
stmt.close();
conn.close();
%>
Main1.jsp
<frameset cols="25%,*">
<frame src="menu.jsp" scrolling="no" name="left">
<frame src="article.jsp" scrolling="auto" name="main">
<noframes>
<body>
<p>对不起，您的浏览器不支持“框架”！</p>
</body>
</noframes>
</frameset>
