database.java

JAVA图书管理系统有很多代码这只是很小的一部分

package library;
/*
 * DataBase.java
 *
 * Created on 2008年6月10日, 下午1:58
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

import java.util.*;
import java.sql.*;
import javax.swing.JOptionPane;
/**
 *
 * @author Administrator
 */
public class DataBase {
    
    /** Creates a new instance of DataBase */
    public DataBase() {
    }
    public ArrayList getReaders(){
     String code;
     String name;
     String sex;
     String type;
     String phone;
     String dept;
     String address;
   ArrayList list=new  ArrayList(); 
   try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             String s1="select * from readerInfo order by code";
             ResultSet rs=st.executeQuery(s1);
             while(rs.next()){
                 code=rs.getString("code");
                 name=rs.getString("name");
                 sex=rs.getString("sex");
                 type=rs.getString("type");
                 phone=rs.getString("phone");
                 dept=rs.getString("dept");
                 address=rs.getString("address");
                 Read read=new Read(code,name,sex,type,phone,dept,address);
                 list.add(read);
                }
           rs.close();
           st.close();
         con.close();
   }catch(Exception e){
       e.getMessage();
   }
   finally {
       return list;
   }
    }
      public ArrayList getBooks(){
     String code;
     String name;
     String type;
     String press;
     String writer;
     boolean isBorrow;
     String reader_code;
      ArrayList list=new  ArrayList(); 
         try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             String s1="select * from bookInfo order by code";
             ResultSet rs=st.executeQuery(s1);
             while(rs.next()){
                 code=rs.getString("code");
                 name=rs.getString("name");
                 type=rs.getString("type");
                 press=rs.getString("press");
                 writer=rs.getString("writer");
                  isBorrow=rs.getBoolean("isBorrow");
                 reader_code=rs.getString("reader_code");
                 Book book=new Book(code,name,type,press,writer,isBorrow,reader_code);
                 list.add(book);
             }
         rs.close();
           st.close();
         con.close();
   }catch(Exception e){
       e.getMessage();
   }
      finally {
         return list;
    }
    }
      public void addReader(Read read){
         try{
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             String s1="insert into readerInfo(code,name,sex,type,phone,dept,address) values('"+read.getCode()+"','"
                     +read.getName()+"','"+read.getSex()+"','"+read.getType()+"','"+read.getPhone()+"','"+read.getDept()
                     +"','"+read.getAddress()+"')";
        int result=  st.executeUpdate(s1);
        if(result>0){
            JOptionPane.showMessageDialog(null,"添加成功!");
        }
           }
         catch(Exception e){
          e.getMessage();
      }
}
      public void addBook(Book1 book1){
       try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             String s1="insert into bookInfo(code,name,type,press,writer) values('"+book1.getCode()+"','"
                     +book1.getName()+"','"+book1.getType()+"','"+book1.getPress()+"','"+book1.getWriter()+
                     "')";
          int result=st.executeUpdate(s1);
             if(result>0){
            JOptionPane.showMessageDialog(null,"添加成功!");
        }
       }catch(Exception e){
          e.getMessage();
      }
        }
      public void  updateReader(Read read){
        String code=read.getCode();
        String name=read.getName();
        String sex=read.getSex();
        String type=read.getType();
        String phone=read.getPhone();
        String dept=read.getDept();
        String address=read.getAddress();
       try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection("jdbc:odbc:library","","");
            Statement st=con.createStatement();  
            String s1="update readerInfo set name='"+name+"',sex='"
                    +sex+"',type='"+type+"',phone='"+phone+"',dept='"+dept+"',address='"+address+"'where code='"+code+"'";
             int result=st.executeUpdate(s1);
             if(result>0){
            JOptionPane.showMessageDialog(null,"修改成功!");
        }
            con.close();           
        }catch(Exception e){
            e.getMessage();
        }
    }
        public void  updateBook(Book1 book1){
         String code=book1.getCode();
        String name=book1.getName();
        String type=book1.getType();
        String press=book1.getPress();
        String writer=book1.getWriter();
       
       
       try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection("jdbc:odbc:library","","");
            Statement st=con.createStatement();  
            String s1="update bookInfo set  name='"+name+"',type='"
                    +type+"',press='"+press+"',writer='"+writer+"'where code='"+code+"'";
             int result=st.executeUpdate(s1);
             if(result>0){
            JOptionPane.showMessageDialog(null,"修改成功!");
        }
            con.close();           
        }catch(Exception e){
            e.getMessage();
        }
        }
           public void deleteReader(String code){
         try{
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             String s1="delete * from  readerInfo where code='"+code+"'";
          int result=st.executeUpdate(s1);
          if(result>0){
            JOptionPane.showMessageDialog(null,"删除成功!");    
          }
           }
         catch(Exception e){
          e.getMessage();
      }
}
         public void deleteBook(String code){
       try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             String s1="delete * from bookInfo where code='"+code+"'";
             int result=st.executeUpdate(s1);
             if(result>0){
            JOptionPane.showMessageDialog(null,"删除成功!");    
          }
       }catch(Exception e){
          e.getMessage();
      }
        }        
}