resultsetmodelfortable.java

学员信息管理系统

package com.javasme.table;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import javax.swing.table.AbstractTableModel;

public class ResultSetModelForTable extends AbstractTableModel {
    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    private ResultSet         rs               = null;

    private ResultSetMetaData rsmd             = null;

    /**
     * 构造函数
     */
    public ResultSetModelForTable(ResultSet rs) {
        super();
        this.rs = rs;
        try {
            rsmd = rs.getMetaData();// 检索此 ResultSet 对象的列的编号、类型和属性
        } catch (Exception e) {
            // e.printStackTrace();
            System.out.println("异常：“发生数据库访问错误”；类：“ResultSetModelForTable extends AbstractTableModel”；方法：“ResultSetModelForTable(ResultSet rs)”；异常出处：“rsmd = rs.getMetaData();”");
        }
    }

    /**
     * 获取行数
     */
    public int getRowCount() {
        int rowCount = 0;// 存储表的行数
        try {
            rs.last();// 将指针移动到最后一条记录
            rowCount = rs.getRow();// 获取当前记录的行数
        } catch (Exception e) {
            // e.printStackTrace();
            System.out.println("异常：“发生数据库访问错误或者结果集类型为 TYPE_FORWARD_ONLY”；类：“ResultSetModelForTable extends AbstractTableModel”；方法：“getRowCount()”；异常出处：“rs.last();”");
        }
        return rowCount;
    }

    /**
     * 获取列数
     */
    public int getColumnCount() {
        int columnCount = 0;// 存储表的列数
        try {
            columnCount = rsmd.getColumnCount();// 获取当前表的列数
        } catch (Exception e) {
            // e.printStackTrace();
            System.out.println("异常：“发生数据库访问错误”；类：“ResultSetModelForTable extends AbstractTableModel”；方法：“getColumnCount()”；异常出处：“columnCount = rsmd.getColumnCount();”");
        }
        return columnCount;
    }

    /**
     * 获取列名
     */
    public String getColumnName(int column) {
        String columnName = "";
        try {
            columnName = rsmd.getColumnName(column + 1);

            /*
             * 学生信息表头
             */
            if (columnName.equals("Student_ID")) {
                columnName = "学生编号";
            }
            if (columnName.equals("Student_Name")) {
                columnName = "学生姓名";
            }
            if (columnName.equals("Student_Sex")) {
                columnName = "学生性别";
            }
            if (columnName.equals("Student_Age")) {
                columnName = "学生年龄";
            }
            if (columnName.equals("Student_Phone")) {
                columnName = "家庭电话";
            }
            if (columnName.equals("Student_Handset")) {
                columnName = "手机号码";
            }
            if (columnName.equals("Student_Address")) {
                columnName = "家庭住址";
            }
            if (columnName.equals("Student_Native")) {
                columnName = "学生籍贯";
            }
            if (columnName.equals("Student_Edu")) {
                columnName = "学生学历";
            }
            if (columnName.equals("Student_Marry")) {
                columnName = "婚姻状况";
            }
            if (columnName.equals("Student_Work")) {
                columnName = "工作经验";
            }
            if (columnName.equals("Student_Class")) {
                columnName = "所在班级";
            }
            if (columnName.equals("Student_StartClassTime")) {
                columnName = "入学时间";
            }
            if (columnName.equals("Student_Stage")) {
                columnName = "学习阶段";
            }
            if (columnName.equals("Student_Like")) {
                columnName = "学生爱好";
            }
            if (columnName.equals("Student_Remarks")) {
                columnName = "学生点评";
            }
            if (columnName.equals("Student_InsertTime")) {
                columnName = "添加时间";
            }
            if (columnName.equals("Student_UpdateTime")) {
                columnName = "最后更新时间";
            }
            if (columnName.equals("Student_UpdateName")) {
                columnName = "更新用户";
            }

            /*
             * 教师信息表头
             */
            if (columnName.equals("Teacher_ID")) {
                columnName = "教师编号";
            }
            if (columnName.equals("Teacher_Name")) {
                columnName = "教师姓名";
            }
            if (columnName.equals("Teacher_Sex")) {
                columnName = "教师性别";
            }
            if (columnName.equals("Teacher_Age")) {
                columnName = "教师年龄";
            }
            if (columnName.equals("Teacher_Phone")) {
                columnName = "家庭电话";
            }
            if (columnName.equals("Teacher_Handset")) {
                columnName = "手机号码";
            }
            if (columnName.equals("Teacher_Address")) {
                columnName = "家庭住址";
            }
            if (columnName.equals("Teacher_Native")) {
                columnName = "教师籍贯";
            }
            if (columnName.equals("Teacher_Edu")) {
                columnName = "教师学历";
            }
            if (columnName.equals("Teacher_Marry")) {
                columnName = "婚姻状况";
            }
            if (columnName.equals("Teacher_Work")) {
                columnName = "工作经验";
            }
            if (columnName.equals("Teacher_Language")) {
                columnName = "教授语言";
            }
            if (columnName.equals("Teacher_StartTeachTime")) {
                columnName = "入教时间";
            }
            if (columnName.equals("Teacher_Post")) {
                columnName = "教师职务";
            }
            if (columnName.equals("Teacher_Like")) {
                columnName = "教师爱好";
            }
            if (columnName.equals("Teacher_Remarks")) {
                columnName = "教师点评";
            }
            if (columnName.equals("Teacher_InsertTime")) {
                columnName = "添加时间";
            }
            if (columnName.equals("Teacher_UpdateTime")) {
                columnName = "最后更新时间";
            }
            if (columnName.equals("Teacher_UpdateName")) {
                columnName = "更新用户";
            }

            /*
             * 课程信息表头
             */
            if (columnName.equals("Courses_ID")) {
                columnName = "课程编号";
            }
            if (columnName.equals("Courses_Name")) {
                columnName = "课程名称";
            }
            if (columnName.equals("Courses_Family")) {
                columnName = "所属类别";
            }
            if (columnName.equals("Courses_Term")) {
                columnName = "所属学期";
            }
            if (columnName.equals("Courses_Describe")) {
                columnName = "课程描述";
            }
            if (columnName.equals("Courses_Aim")) {
                columnName = "课程目标";
            }
            if (columnName.equals("Courses_InsertTime")) {
                columnName = "添加时间";
            }
            if (columnName.equals("Courses_UpdateTime")) {
                columnName = "最后更新时间";
            }
            if (columnName.equals("Courses_UpdateName")) {
                columnName = "更新用户";
            }

            /*
             * 班级信息表头
             */
            if (columnName.equals("Class_ID")) {
                columnName = "班级编号";
            }
            if (columnName.equals("Class_Name")) {
                columnName = "班级名称";
            }
            if (columnName.equals("Class_StartTime")) {
                columnName = "开办时间";
            }
            if (columnName.equals("Class_Family")) {
                columnName = "班级类别";
            }
            if (columnName.equals("Class_Time")) {
                columnName = "上课时间";
            }
            if (columnName.equals("Class_Teacher")) {
                columnName = "负责教师";
            }
            if (columnName.equals("Class_Describe")) {
                columnName = "班级描述";
            }
            if (columnName.equals("Class_Remarks")) {
                columnName = "班级点评";
            }
            if (columnName.equals("Class_InsertTime")) {
                columnName = "添加时间";
            }
            if (columnName.equals("Class_UpdateTime")) {
                columnName = "最后更新时间";
            }
            if (columnName.equals("Class_UpdateName")) {
                columnName = "更新用户";
            }
        } catch (SQLException e) {
            // e.printStackTrace();
        }
        return columnName;
    }

    /**
     * 获取记录
     */
    public Object getValueAt(int row, int column) {
        Object valueAt = null;// 存储查询到的记录
        try {
            rs.absolute(row + 1);
            valueAt = rs.getObject(column + 1);
        } catch (Exception e) {
            // e.printStackTrace();
            System.out.println("异常：“发生数据库访问错误或者结果集类型为 TYPE_FORWARD_ONLY”；类：“ResultSetModelForTable extends AbstractTableModel”；方法：“getValueAt(int row, int column)”；异常出处：“rs.absolute(row + 1);”或“valueAt = rs.getObject(column + 1);”");
            return null;
        }
        return valueAt;
    }
}