databaseoperate.java

酒店管理系统（单机版）,根据酒店的日常业务运作而设计

package cg;

import java.util.*;
import java.sql.*;

public class DatabaseOperate
{
    private Connection con;

    
    public DatabaseOperate()
    {
        con = getConnection();        
    }
    
    public Connection getConnection()
    {
    	Connection conn = null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:myOdbc", "sa", "");
        }
        catch (ClassNotFoundException cnfe)
        {
            cnfe.printStackTrace();
        }
        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }
        
        return (conn);
    }
    
    public Vector<String> getColumnNamesByTabname()
    {
        Vector<String> cols = new Vector<String>();
        try
        {
            Statement sta = con.createStatement();
            String strSql = "SELECT * FROM guestroomBase WHERE 1=2";
            ResultSet rs = sta.executeQuery(strSql);
            ResultSetMetaData rsmd = rs.getMetaData();
            int colCount = rsmd.getColumnCount();
            for (int i = 1; i <= colCount; i++)
            {
                cols.add(rsmd.getColumnName(i));
            }
            rs.close();
            sta.close();
        }
        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }
        
        return (cols);
    }
    
    public Vector<Object> getDataByTabname()
    {
        Vector<Object> data = new Vector<Object>();
        try
        {
            Statement sta = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                                ResultSet.CONCUR_READ_ONLY);
            String strSql = "SELECT * FROM guestroomBase";
            ResultSet rs = sta.executeQuery(strSql);
            int cols = rs.getMetaData().getColumnCount();
            while (rs.next())
            {
                Vector<Object> vec = new Vector<Object>();
                for (int i = 1; i <= cols; i++)
                {
                    vec.add(rs.getObject(i));
                }
                data.add(vec);
            }
            rs.close();
            sta.close();
        }
        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }
        
        return (data);
    }
    
    public Vector<String> getAllTabelName()
    {
        Vector<String> vec = new Vector<String>();
        try
        {
            Statement sta = con.createStatement();
            String strSql = "select 客房编号 from guestroomBase";
            ResultSet rs = sta.executeQuery(strSql);
            while (rs.next())
            {
                vec.add(rs.getString("客房编号"));
            }
            rs.close();
            sta.close();
        }
        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }
        
        return (vec);
    }
    
    public void closeConnection()
    {
        try
        {
            con.close();
        }
        catch (SQLException sqle)
        {
            sqle.printStackTrace();
        }
    }
}