connectiondatabase.java

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

package cx;

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

public class ConnectionDatabase
{
	private static Connection con;
	ConnectionDatabase(){}
	public static Connection getConnection()  //连接数据库
	{
		if (con == null)
		{
			try
			{
				File file = new File("config.ini");//配置文件
				FileReader fr = new FileReader(file);
				BufferedReader br = new BufferedReader(fr);
				String strDriver = br.readLine();
				String strUrl = br.readLine();
				String strUser = br.readLine();
				String strPwd = br.readLine();
				Class.forName(strDriver);
				con = DriverManager.getConnection(strUrl, strUser, strPwd);
			}
			catch (Exception e)
			{
				e.printStackTrace();
			}
		}
		return (con);
	}
	
	public static void close(Connection conn)
	{
		try
		{
			if (conn != null)
			{
				conn.close();
			}
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	
	public static void close()//任何"关闭"的重写方法
	{
		
	}
	
   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);
    }*/
}