connectdatabase.java~121~

用java实现的固定资产管理系统相信对于初学者可以从中学到一点知识....!

package 固定资产管理系统;

import java.sql.*;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.JTree;
import javax.swing.tree.DefaultMutableTreeNode;

public class ConnectDataBase {
    Connection con;
    Statement st;
    ResultSet rs;
    Vector vt;
    Vector tempvt;
    Vector vtColName;
    DefaultTableModel dt;
    DefaultTreeModel dtm;

    public ConnectDataBase() {
        try {
            getconnect();
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void getconnect(){
        try {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       } catch (ClassNotFoundException ex) {
       }
       String url="jdbc:odbc:AssetData";
        try {
            con = DriverManager.getConnection(url);
            st = con.createStatement();
        } catch (SQLException ex1) {
        }
    }

    public DefaultTableModel getAstinfo(){
        try {
            rs = st.executeQuery("select * from Asset");
            vt=new Vector();
            while (rs.next()) {
                tempvt=new Vector();
                for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       tempvt.add(rs.getString(i));
                vt.add(tempvt);
            }
            vtColName=new Vector();
            for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
                vtColName.add(rs.getMetaData().getColumnName(i));
            }
            dt=new DefaultTableModel(vt,vtColName);
        } catch (SQLException ex) {
        }
        return dt;
    }


    public DefaultTableModel getAstsearchinfo(String str){
    try {
        rs = st.executeQuery(str);
        vt=new Vector();
        while (rs.next()) {
            tempvt=new Vector();
            for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                   tempvt.add(rs.getString(i));
            vt.add(tempvt);
        }
        vtColName=new Vector();
        for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
            vtColName.add(rs.getMetaData().getColumnName(i));
        }
        dt=new DefaultTableModel(vt,vtColName);
    } catch (SQLException ex) {
    }
    return dt;
}


    public Vector getAstlendid(){
        try {
            rs = st.executeQuery("select assetid from Asset where status='在库'");
            vt=new Vector();
            while (rs.next()) {
                vt.add(rs.getString(1));
            }
        } catch (SQLException ex) {
        }
        return vt;
    }

    public Vector getAstreturnid(){
        try {
            rs = st.executeQuery("select assetid from lend where isreturn='否'");
            vt=new Vector();
            while (rs.next()) {
                vt.add(rs.getString(1));
            }
        } catch (SQLException ex) {
        }
        return vt;
    }


    public Vector getAstlendinfo(String id){
        try {
            vt=new Vector();
            rs = st.executeQuery("select Asset.asset_name,Category.catename,Category.subcatename from Asset full join Category on Asset.subcateid=Category.subcateid and Asset.cateid=Category.cateid where Asset.assetid='"+id+"'");
            while(rs.next()){
                vt.add(rs.getString(1));
                vt.add(rs.getString(2));
                vt.add(rs.getString(3));
            }
        } catch (SQLException ex) {
        }
        return vt;
    }

    public Vector getAstlendemp(){
        try {
            vt=new Vector();
            rs = st.executeQuery("select ename from employee");
            while(rs.next()){
                vt.add(rs.getString(1));
            }
        } catch (SQLException ex) {
        }
        return vt;
    }

    public Vector getAstlendoperator(){
            try {
                vt=new Vector();
                rs = st.executeQuery("select name from operator");
                while(rs.next()){
                    vt.add(rs.getString(1));
                }
            } catch (SQLException ex) {
            }
            return vt;
    }


    public DefaultTableModel getempinfo(){
       try {
           rs = st.executeQuery("select * from Employee");
           vt=new Vector();
           while (rs.next()) {
               tempvt=new Vector();
               for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                      tempvt.add(rs.getString(i));
               vt.add(tempvt);
           }
           vtColName=new Vector();
           for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
               vtColName.add(rs.getMetaData().getColumnName(i));
           }
           dt=new DefaultTableModel(vt,vtColName);
       } catch (SQLException ex) {
       }
       return dt;
   }


   public DefaultTreeModel getcateinfo(){
          try {
              rs = st.executeQuery(
                      "select Max(catename) from Category group by cateid");
              vt=new Vector();
              while (rs.next()) {
                  vt.add(rs.getString(1));
                  }
              DefaultMutableTreeNode root=new DefaultMutableTreeNode("固定资产");
              for(int i=0;i<vt.size();i++){
                  DefaultMutableTreeNode parent=new DefaultMutableTreeNode(vt.get(i));
                  root.add(parent);
                      rs=st.executeQuery("select subcatename from Category where catename='"+
                         vt.get(i)+"'");
                      Vector vtemp=new Vector();
                      while(rs.next()){
                          vtemp.add(rs.getString(1));
                     }
                      for(int j=0;j<vtemp.size();j++){
                          DefaultMutableTreeNode child = new
                                  DefaultMutableTreeNode(vtemp.get(j));
                          parent.add(child);
                      }

                  }
             dtm = new DefaultTreeModel(root);
          } catch (SQLException ex) {
          }
          return dtm;
   }

   public DefaultTableModel getCategoryinfo(){
        try {
            rs = st.executeQuery("select * from Category");
            vt=new Vector();
            while (rs.next()) {
                tempvt=new Vector();
                for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
                       tempvt.add(rs.getString(i));
                vt.add(tempvt);
            }
            vtColName=new Vector();
            for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
                vtColName.add(rs.getMetaData().getColumnName(i));
            }
            dt=new DefaultTableModel(vt,vtColName);
        } catch (SQLException ex) {
        }
        return dt;
    }


   public Vector getcategoryinfo(String subcatename){
          Vector vt=new Vector();
          try {
              rs = st.executeQuery(
                      "select * from Category where subcatename='"+subcatename+"'");
              while (rs.next()) {
                  vt.add(rs.getString(1));
                  vt.add(rs.getString(2));
                  vt.add(rs.getString(3));
                  vt.add(rs.getString(4));
                  }
          } catch (SQLException ex) {
          }
          return vt;
   }

   public Vector getcateid(){
             try {
                 rs = st.executeQuery(
                         "select cateid from Category group by cateid");
                 vt=new Vector();
                 while (rs.next()) {
                     vt.add(rs.getString(1));
                     }
             } catch (SQLException ex) {
             }
             return vt;
   }

   public Vector getsubcateid(String cateid){
             try {
                 rs = st.executeQuery(
                         "select subcateid from Category where cateid='"+
                         cateid+"'group by subcateid");
                 vt=new Vector();
                 while (rs.next()) {