vocationcondb.java

用java实现的一个应用程序,源码非常完整,可以直接运行

package 毕业设计;
import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Vector;
public class VocationConDB {
    private Connection con;
    private Statement st;
    private ResultSet rs;
    private PreparedStatement pst;
    public VocationConDB() {
        //*************************连接数据库*************************************
         try {
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         } catch (ClassNotFoundException ex) {
             System.out.println("Driver 出错");
         }
        try {
            String url = "jdbc:odbc:chenhaiLibrary";
            con = DriverManager.getConnection(url);
            st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                     ResultSet.CONCUR_UPDATABLE);
        } catch (SQLException ex1) {
            System.out.println("lib 出错");
        }
    }

    //**************************添加读者职业************************************
     public boolean AddVocation(String Vocation) {
         boolean Success = true;
         try {
             String strSQL = "insert Vocation values ( '" + Vocation + "')";
             pst = con.prepareStatement(strSQL);
             pst.executeUpdate();
             pst.close();
         } catch (SQLException ex) {
             Success = false;
         }
         return Success;
     }

    //******************************查询所有读者职业********************************
     public Vector SearchAll() {
         Vector vt = new Vector();
         try {
             String str = "select * from Vocation";
             rs = st.executeQuery(str);
             while (rs.next()) {
                 Vector temp = new Vector();
                 temp.add(rs.getString(1));
                 temp.add(rs.getString(2));
                 vt.add(temp);
             }
             rs.close();
         } catch (SQLException ex) {
         }
         return vt;
     }

    //*****************************查询读者职业*********************************
     public Vector SearchVocation(String Vocation) {
         Vector vt = new Vector();
         try {
             String str = "select * from Vocation where VocationName like '%" +
                          Vocation + "%'";
             rs = st.executeQuery(str);
             while (rs.next()) {
                 Vector temp = new Vector();
                 temp.add(rs.getString(1));
                 temp.add(rs.getString(2));
                 vt.add(temp);
             }
             rs.close();
         } catch (SQLException ex) {
         }
         return vt;
     }

    //*********************************更新读者职业*****************************
     public boolean UpdateVocation(int Id, String VocationName) {
         boolean Success = true;
         try {
             String strSQL = "update Vocation set VocationName = '" +
                             VocationName +
                             "' where Id = " + Id;
             pst = con.prepareStatement(strSQL);
             pst.executeUpdate();
             pst.close();
         } catch (SQLException ex) {
             Success = false;
         }
         return Success;
     }

    //*******************************删除读者职业*******************************
     public void DeleteVocation(int Id) {
         try {
             String strSQL = "delete from Vocation where Id = " + Id;
             pst = con.prepareStatement(strSQL);
             pst.executeUpdate();
             pst.close();
         } catch (SQLException ex) {
         }
     }

    //*****************************关闭数据库连接*********************************
     public void CloseVocationDB() {
         try {
             st.close();
             con.close();
         } catch (SQLException ex) {
         }
     }
}