王晁集团:大家帮我看看这段程序的问题啊 谢谢啊。。。

来源:百度文库 编辑:高校问答 时间:2024/05/11 19:09:52
<% try{
String username=request.getParameter("user");
String password=request.getParameter("pwd");
if((username.equals(""))||(password.equals("")))
{
out.print("<script>");
out.print("alert('用户名或密码不能为空!');");
out.print("window.location.href='login.jsp';");
out.print("</script>");
}
else
{

Connection conn=DBconn.GetConn();
Statement sqlrs= conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY) ;
String sql="select * from admin where username='"+username+"' And password='"+password+"'";
ResultSet rs=sqlrs.executeQuery(sql);
if(rs.next()){
rs.close();
//登录成功
out.print("<script>");
out.print("alert('登录成功!');");
out.print("window.location.href='admindex.jsp';");
out.print("</script>");
session.putValue("UserName",username);
}
else{
rs.close();
out.print("<script>");
out.print("alert('登录失败!');");
out.print("window.location.href='login.jsp';");
out.print("</script>");
}
}
}
catch(Exception e)
{
out.print(e.toString());
}

%>
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 2。

会出现这个错误
package MyJsp;

import java.sql.*;
public class DBconn
{

String url;
String user;
String pwd;
Connection conn;

public DBconn()
{
url = "jdbc:odbc:guestbook";
user = "";
pwd = "";
conn = null;
}

public Connection GetConn()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url, user, pwd);
}
catch(Exception exception)
{
exception.printStackTrace();
}
return conn;
}
}

运行一下,不就知道了

好象是你的连接字符串的问题。。。
检查一下