book.java

这是个用struts开发的电话卡销售与管理系统.具有网络设备监控能力

/**
 * 
 */
package com.phone.struts.db;

import java.sql.*;
import java.util.ArrayList;
import com.phone.struts.db.DatabaseConn;
/**
 * @author cong 
 * Struts分页显示数据Bean，对应数据库中Book表
 */
public class Book {
 private String userID; //书名
 private String userName;   //作者
 private String userAddr;    //价格
 
public Book(String userID,String userName,String userAddr){
 this.userID=userID;
 this.userName=userName;
 this.userAddr=userAddr;
}

 public String getUserID() {
  return userID;
 }

 public void setUserID(String userID) {
  this.userID = userID;
 }

 public String getUserName() {
  return userName;
 }

 public void setUserName(String userName) {
  this.userName = userName;
 }
 
 public String getUserAddr(){
     return this.userAddr; 
 }
 
 public void setUserAddr(String userAddr){
     this.userAddr=userAddr; 
 }
 
 public static ArrayList getAllBook(Connection connection){
   String sql="select * from TABLE_USERS";
   ArrayList arrayList = new ArrayList();
   try{
   Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
   ResultSet resultSet = statement.executeQuery(sql);  
   System.out.println("BookBean 数据查询已完成！");
      while(resultSet.next())
      {  
    	  DatabaseConn conn = new DatabaseConn();
        String name = conn.strans(resultSet.getString("userID"));
        String author = resultSet.getString("userName");
        String price = resultSet.getString("userAddr");
        System.out.println("开始数据封装：name="+name+"author="+author+"price="+price);
        Book book = new Book(name,author,price);       
        arrayList.add(book);
      }
    resultSet.close();
    statement.close();
    connection.close();
   
   }catch(SQLException e)
   {
    System.out.println("数据库异常"+e.toString());
   }

      return arrayList;
 }
}