query.java~5~

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

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 String queryExecute(String strSql) throws Exception {
    try
    {

      rs = stmt.executeQuery(strSql);
      rs.next();
      String sname = rs.getString("au_lname");
      rs.close();
      return sname;
    }catch(SQLException e){
      System.out.println(e);
    }
  }
}