/** access mysql database through JDBC Driver */
package mypack;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;

public class BookDB {

  private ArrayList books;
  private String dbUrl = "jdbc:mysql://localhost:3306/BookDB?useUnicode=true&characterEncoding=GB2312";
  private String dbUser="root";
  private String dbPwd="731616";

  public BookDB () {
    try{ Class.forName("com.mysql.jdbc.Driver");
    
  }
  catch(Exception e){
  	}
  	}

 

 public BookDetails getBookDetails(String bookId){
 	Connection con=null;
   PreparedStatement prepStmt=null;
   // Statement stmt =null; 
    ResultSet rs =null;
    BookDetails bd =null;
     
   try{
  
      con=java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
      String selectStatement = "select * from books where id=?";
      prepStmt = con.prepareStatement(selectStatement);
      prepStmt.setString(1, bookId);
      rs = prepStmt.executeQuery();
    // stmt = con.createStatement();
     //rs=stmt.executeQuery(selectStatement);
    // System.out.println("dsfdsf");
   // while(rs.next()){
   
    // System.out.println("jhjk"+rs.getString(1));
    // }
   while(rs.next()){
    String template=new String( rs.getString(2).getBytes("ISO-8859-1"),"GB2312");
       bd = new BookDetails(rs.getString(1),template, rs.getString(3),
          rs.getFloat(4), rs.getInt(5), rs.getString(6),rs.getInt(7));
          }
      }
      catch(Exception e){
      }           
        
      return bd;
      
      }
   
    
  public static void main(String args[]){
 	BookDB bookDB= new BookDB();
  	 BookDetails book=bookDB.getBookDetails("201"); 
  	
  	  System.out.println(""+book.getBookId()+book.getPrice()+book.getName());
  	 	} 
}