JAVA C/S架构应用程序

用JAVA开发的一个简单桌面应用程序，实现ORACLE数据库的增删改查操作，所有操作均用存储过程实现，同时实现了Oracle 大对象BLOB 图像文件的存取，供初学者学习。

package com.qixin.mis;

import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;

/**
 * 数据库连接对象
 * @author qixin
 */
public class DatabaseBean {

    public static Connection getConnection（） throws SQLException {
        String jdbcUrl = “jdbc:oracle:thin:@teacher:1521/xe“;
        String userid = “qixin“;
        String password = “oracle“;

        OracleDataSource ds;
        ds = new OracleDataSource（）;
        ds.setURL（jdbcUrl）;
        return ds.getConnection（userid password）;
    }

    public static void close（ResultSet rs Statement st Connection conn） {
        try {
            if （rs != null） {
                rs.close（）;
            }
        } catch （SQLException ex） {
        }

        try {
            if （st != null） {
                st.close（）;
            }
        } catch （SQLException ex） {
        }

        try {
            if （conn != null） {
                conn.close（）;
            }
        } catch （SQLException ex） {
            ex.printStackTrace（）;
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      22698  2011-07-17 07:54  StudentMis_oracle_pro_blob\1.png

     文件      18501  2011-07-17 07:54  StudentMis_oracle_pro_blob\2.png

     文件      22600  2011-07-17 07:54  StudentMis_oracle_pro_blob\3.png

     文件      18484  2011-07-17 07:54  StudentMis_oracle_pro_blob\4.png

     文件      21600  2011-07-17 07:54  StudentMis_oracle_pro_blob\5.png

    I.A....        65  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\built-jar.properties

     文件          0  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\.netbeans_automatic_build

     文件       1374  2011-11-28 18:05  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\DatabaseBean.class

     文件       1970  2011-11-28 18:05  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\ImagePreviewer$1.class

    I.A....       900  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\ImagePreviewer.class

    I.A....       775  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Mainframe$1.class

    I.A....       775  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Mainframe$2.class

    I.A....       775  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Mainframe$3.class

    I.A....       775  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Mainframe$4.class

    I.A....      1014  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Mainframe$5.class

     文件       8008  2011-09-29 16:02  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Mainframe.class

     文件       2658  2011-07-17 08:28  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\MisUtils.class

    I.A....       987  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\MyFileChooser.class

    I.A....        91  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\MyFileChooser.rs

    I.A....       817  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuAddNewDialog$1.class

    I.A....       817  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuAddNewDialog$2.class

    I.A....       817  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuAddNewDialog$3.class

     文件       8800  2011-09-30 16:21  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuAddNewDialog.class

    I.A....      1736  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\Student.class

    I.A....      5114  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StudentBean.class

    I.A....      3156  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuModel.class

    I.A....       817  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuUpdateDialog$1.class

    I.A....       817  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuUpdateDialog$2.class

    I.A....       817  2011-12-02 07:57  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuUpdateDialog$3.class

     文件       9680  2011-09-30 16:21  StudentMis_oracle_pro_blob\build\classes\com\qixin\mis\StuUpdateDialog.class

............此处省略74个文件信息