dbcom.java~5~

一个功能强大的图书管理系统,是个人版,适合学习swing的初学者阅读.

package booksboeeowreadsystem;

/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫、程颖丽、张阳、黄家贵、陈波、涂帆
 * @version 1.0
 */
import java.sql.*;
import javax.swing.JOptionPane;
public class Dbcom {
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;

    public Dbcom() {
        if(!getconn()){
         JOptionPane.showMessageDialog(null,"连接数据库失败","连接错误",JOptionPane.WARNING_MESSAGE);
         //可以在这个位置放上建库 建表的代码
         System.exit(0);
        }
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    //创建连接
    public boolean getconn()
    {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          //  conn =  DriverManager.getConnection("Jdbc:Odbc:books");
            conn = DriverManager.getConnection("jdbc:odbc:Driver={SQL Server};server=.;database=booksboeeowreadsystem;uid=sa;pwd=111111");
        } catch (ClassNotFoundException ex) {
            System.out.println(ex.toString());
        }catch(SQLException se){
            System.out.println(se.toString());
        }
        if(conn!=null)
            return true;
        else
            return false;
    }
    //查询
    public ResultSet search(String sql)
   {

       try {
           pstmt = conn.prepareStatement(sql,
                                         ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
           rs = pstmt.executeQuery();
       } catch (SQLException ex) {
           System.out.println(ex.toString());
           ex.printStackTrace();
       }
       return rs;
   }


    //图书生成树的专用查询查询
    public ResultSet searchTree()
    {
        String sql = "select * from booksType";
        try {
            pstmt = conn.prepareStatement(sql,
                                          ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
            rs = pstmt.executeQuery();
        } catch (SQLException ex) {
        }
        return rs;
    }
    //期刊生成树的专用查询
    public ResultSet searchMagazinTree()
   {
       String sql = "select * from magazineType2";
       try {
           pstmt = conn.prepareStatement(sql,
                                         ResultSet.TYPE_SCROLL_INSENSITIVE,
                                     ResultSet.CONCUR_UPDATABLE);
           rs = pstmt.executeQuery();
       } catch (SQLException ex) {
       }
       return rs;
   }

    //查询图书信息到表中
    public ResultSet booksInfosearch(String sql)
    {
      //  String sql = "select * from booksInfo";
        try {
            pstmt = conn.prepareStatement(sql,
                                          ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
            rs = pstmt.executeQuery();
        } catch (SQLException ex) {
        }

        return rs;
    }

    //关闭所有的对象方法

    public void myClose()
    {

            try {
                if(rs!=null)
                    rs.close();
                if(pstmt!=null)
                    pstmt.close();
                if(conn!=null)
                    conn.close();
            } catch (SQLException ex) {
                System.out.println(ex.toString());
            }
    }
    //关闭结果集、语句对象，保留连接对象的可用
    public void myClose(int a)
   {

           try {
               if(rs!=null){
                   rs.close();
                   rs=null;
               }
               if(pstmt!=null){
                   pstmt.close();
                   pstmt=null;
               }
           } catch (SQLException ex) {
               System.out.println(ex.toString());
           }
   }

   public boolean add(String sql)
   {
       int result=-1;
    try {
        pstmt = conn.prepareStatement(sql);
        result = pstmt.executeUpdate();

    } catch (SQLException ex) {
        System.out.println(ex.toString());
    }
    if(result>0)
       return true;
   else
       return false;
   }

    private void jbInit() throws Exception {
    }

    //
    public boolean add(PreparedStatement pt)
   {

       int result=-1;
    try {
        result = pt.executeUpdate();

    } catch (SQLException ex) {
        System.out.println(ex.toString());
        ex.printStackTrace();
    }
    if(result>0)
       return true;
   else
       return false;
   }

}