代码:
login.jsp<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<BODY>
<Font size=4><center>
<FORM action="check.jsp" Method="post">
<P>系统登陆界面
<P>用户名:
<Input type=text name="uid">
<p>密 码:
<Input type=text name="pwd">
<p>
<Input type=submit name="g" value="提交"></Form></BODY>
</HTML>check.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
String id=request.getParameter("uid");
String pwd=request.getParameter("pwd");
try
{
String spath="data//data.mdb";
String dbpath = application.getRealPath(spath);
String dbname = ""; //Acess
String user = ""; //Acess
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
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select uid,pwd from login";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
if (id==rs.getString("uid")||pwd==rs.getString("pwd"))
{response.sendRedirect("show.jsp");}
else
{ out.print("错误");
response.sendRedirect("1.txt");}
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
out.print("数据库连接错误!,错误信息如下:<br>");
out.print(e.getMessage());
}
%>
</BODY>
</HTML>
但是达不到效果 错在哪里请指教
login.jsp<%@ page contentType="text/html;charset=GB2312" %>
<HTML>
<BODY>
<Font size=4><center>
<FORM action="check.jsp" Method="post">
<P>系统登陆界面
<P>用户名:
<Input type=text name="uid">
<p>密 码:
<Input type=text name="pwd">
<p>
<Input type=submit name="g" value="提交"></Form></BODY>
</HTML>check.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
String id=request.getParameter("uid");
String pwd=request.getParameter("pwd");
try
{
String spath="data//data.mdb";
String dbpath = application.getRealPath(spath);
String dbname = ""; //Acess
String user = ""; //Acess
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
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select uid,pwd from login";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
if (id==rs.getString("uid")||pwd==rs.getString("pwd"))
{response.sendRedirect("show.jsp");}
else
{ out.print("错误");
response.sendRedirect("1.txt");}
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
out.print("数据库连接错误!,错误信息如下:<br>");
out.print(e.getMessage());
}
%>
</BODY>
</HTML>
但是达不到效果 错在哪里请指教
Connection conn= DriverManager.getConnection(url)
改为
Connection conn= DriverManager.getConnection(url,user,pwd)
其中,user和pwd为数据库的用户名、密码