guestdb.java

Java Web 开发使用标签的一个综合例子

package zengjsp;
//数据库bean，存取数据库，同时提供方法向表里写入或者从表里读出值．
import java.io.*;
import java.sql.*;
import java.util.*;

public class GuestDB {
  private Connection con;//这是一个接口对象
  private  PreparedStatement add,get;
  public GuestDB()  throws Exception{//构造连接数据库,意外向外扔吧
    con=null;
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//这里绝对大小写敏感，一不当心就classnotfound了。
     String url="jdbc:odbc:combook";//url
     con=DriverManager.getConnection(url) ;
     System.err.println("成功连接");

     get= con.prepareStatement("select name,gender,tele,mail from telebook") ;
     add= con.prepareStatement("insert into telebook ( name,gender,tele,mail ) values(?,?,?,?)");
  }
  public ArrayList getGuestList() throws SQLException{
    ArrayList mylist = new ArrayList();

    ResultSet rs = get.executeQuery() ;
    String temp,ds;
    while ( rs.next() ){
      GuestBean guest = new GuestBean();
      guest.setName(rs.getString(1) ) ;
      temp= rs.getString(2) ;
      if (temp.equals("ma") )
          ds="男";
      else
          ds="女";

      guest.setGender(ds) ;
      guest.setTele(rs.getString(3) );
      guest.setMail(rs.getString(4) ) ;

      mylist.add(guest);

    }//while
    return mylist;//返回一个arraylist ，好

  }//get
  protected  void  finalize(){
    try{
      get.close() ;
      con.close() ;
    }catch(SQLException e){ e.printStackTrace() ;};
  }//fin
  public static  void   main(String [] s1){

    try{
    GuestDB db = new GuestDB();
    ArrayList ar = db.getGuestList() ;
    Iterator it = ar.iterator() ;
    GuestBean gb;
    while(it.hasNext() )
    {
       gb = (GuestBean) it.next() ;
       System.err.println("name "+ gb.getName() );
       System.err.println("gender "+ gb.getGender()  );
       System.err.println("tele "+ gb.getTele()  );
       System.err.println("mail "+ gb.getMail()  );


    }//while
    } catch(Exception e){ System.err.println("error yea! "); e.printStackTrace() ;};
  }
}