query.java~6~

来自「图书管理系统,B/S,C/S都有,附有源代码」· JAVA~6~ 代码 · 共 42 行

package book;

import java.sql.*;
import java.util.Vector;
import database.*;
import book.authors;

/**
 * <p>Title: library</p>
 * <p>Description: library</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author nino
 * @version 0.1
 */

public class query extends DataBase{
  private Vector authorlist;
  private int rscount = 0;

  public Vector getauthorlist() {
          return authorlist;
  }

  public boolean queryExecute(String strSql) throws Exception {
    try
    {
      rs = stmt.executeQuery(strSql);
      authorlist = new Vector();
      while (rs.next()){
        authors author = new authors();
        author.setName(rs.getString("au_lname"));
        authorlist.addElement(author);
      }
      rs.close();
      return true;
    }catch(SQLException e){
      System.out.println(e);
      return false;
    }
  }
}