网上书店
源代码在线查看： booklist.java
| 软件大小： |
72 K |
| 上传用户： |
wuqiweipp |
|
|
| 关键词： |
|
| 下载地址： |
免注册下载 普通下载
|
|
package com.bitc.store;
//定义Bean所属的套件
//定义欲使用的套件
import java.sql.*;
public class BookList
{
//与资料库连结有关的Bean属性
private Connection con = null;
private Statement stmt = null;
private ResultSet BookRs = null;
public BookList() //建构子
{
}
//以下为设定Bean属性的方法
public void InitBookRs(Connection con, String filter)
{
try{
if(this.con != con)
{
this.con = con;
}
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//建立Statement物件
BookRs = stmt.executeQuery
("SELECT * FROM Book WHERE " + filter);
//执行SQL叙述从Book资料表取得记录
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
}
//关闭ResultSet物件
public void CloseBookRs ()
{
try{
if(BookRs != null)
{
BookRs.close();
BookRs = null;
}
if(stmt != null)
{
stmt.close();
stmt = null;
}
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
}
//移至下一笔记录
public boolean next()
{
boolean result = false;
try{
result = BookRs.next();
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
//取得记录集中ID栏位的资料
public String getID()
{
String result = null;
try{
result = BookRs.getString("ID");
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
//取得记录集中BookID栏位的资料
public String getBookID()
{
String result = null;
try{
result = BookRs.getString("BookID");
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
//取得记录集中BookNm栏位的资料
public String getBookNm()
{
String result = null;
try{
result = BookRs.getString("BookNm");
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
//取得记录集中Author栏位的资料
public String getAuthor()
{
String result = null;
try{
result = BookRs.getString("Author");
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
//取得记录集中Price栏位的资料
public String getPrice()
{
String result = null;
try{
result = BookRs.getString("Price");
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
//取得记录集中Abstract栏位的资料
public String getAbstract()
{
String result = null;
try{
result = BookRs.getString("Abstract");
}
catch(SQLException sex)
{
System.out.println(sex.toString());
}
return result;
}
}
