高手帮我看看这段代码错在哪了，该怎么改？想了一整天了，郁闷阿

首先,你这样处理不妥当，逻辑处理应该封装到BEAN里面处理在这里顺便贴上我的办法参考吧,呵呵，希望对你有用，今晚喝多了点，暂时就不帮你看代码了:)
import java.util.*;
import java.sql.*;
import upload.*;public class databaseBean{
  private String dbName;
  private String dbUser;
  private String dbPass;
   private Vector memoVector;   Connection connection;  public databaseBean(){
    dbName=new String("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    dbUser=new String("bn");
    dbPass=new String("bn");
    String connectionUrl="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
    try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      connection=DriverManager.getConnection(connectionUrl,dbUser,dbPass);
    }
    catch(Exception e){
      System.out.println(e.toString());
      }
  }
//select * from resource where ResourceName LIKE'%计算机%'
  public void dbQueryMemos(String name){      String sql=new String ("select * from resource");
     if(name!=null)
      sql = sql+" where ResourceName Like'%"+name+"%'";
      try{
       memoVector=new Vector();
       Statement stmt = connection.createStatement();
       ResultSet rs = stmt.executeQuery(sql);       while(rs.next()){
        memoBean temp=new memoBean();
        temp.setResourceName(rs.getString(1));
        temp.setResourceSize(rs.getString(2));
        temp.setType(rs.getString(3));
        temp.setUploadTime(rs.getDate(4));
        temp.setTeacherName(rs.getString(5));
        memoVector.add(temp);
      }   }
   catch(SQLException e){
     System.out.println(e.toString());
   }  }    public void setDbName(String s){
    this.dbName=s;
  }
  public void setDbUser(String s){
    this.dbUser=s;
  }
  public void setDbPass(String s){
    this.dbPass=s;
  }  public String getDbName(){
    return this.dbName;
  }
  public String getDbUser(){
    return this.dbUser;
  }
  public String getDbPass(){
    return this.dbPass;
  }
    public Vector getMemoVector(){
    return this.memoVector;  }}