航空母舰拼装玩具视频:急求jsp用户登陆口令密码验证代码！

将一个JSP表单的name和password提交到一个servlet（如CheckLogin ，在test包中）,具体代码如下：
package test;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;

public class CheckLogin extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";

//Initialize global variables
public void init() throws ServletException {
}

//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);

String name=request.getParameter("name");
String pswd=request.getParameter("password");

String sql="select sname,spassword from fly";
Connection conn=test.getConnection();
Statement stmt=conn.createStatement();
ReslutSet rs=stmt.executeQuery(sql);
String sname = rs.getString("sname");
String spassword = rs.getString("spassword");

if (name.equals(smane) && pswd.equals(spassword)){

response.sendRedirect("success.jsp");

}
else{
response.sendRedirect("error.jsp");
}
}

//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

public void destroy() {
}
}
连接数据库的类DBConnection 例如也放在test包下
package test;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.*;

public class DBConnection {
public static Connection getConnection() {
String driver =驱动连接串;
String url =驱动连接url;
String name =数据库用户名;
String password = 该用户的密码;
Connection conn = null;
try {
Class.forName(driver);

conn = DriverManager.getConnection(url , name, password);
}
catch (SQLException ex1) {
ex1.printStackTrace();
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
return conn;
}
}

如果这样不可以的话！我也没有话说了（Access的驱动串和URL我不知道，没有用过这个数据库）