readdata.java

小型简单的旅馆预订系统. 客户:预定,更改,撤销,会员积分累积,查询预定,会员. 后台:会员更改,房间更改,预定更改,预定信息统计.

package servlet;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class readData
{
	public static void main(String[] args)
	{
		
		String query="SELECT * FROM Room;";
		operateDB(query);
		
		
	}
	public static void operateDB(String qry)
	{

		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
			String driver = "Driver={Microsoft Access Driver (*.mdb)}";
			String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
			String connectionString = "jdbc:odbc:" + driver + ";" + dbq;
			Connection conn = DriverManager.getConnection(connectionString);
			Statement stmt;
			stmt = conn.createStatement(
					ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			String query = qry;
			ResultSet rs = stmt.executeQuery(query);
			ResultSetMetaData   rm=rs.getMetaData(); 
			int colNum=rm.getColumnCount();//get column number
			int rowNum=0;
			int lop=1;
			if (rs.next())
			{
				for (rs.first(); !rs.isAfterLast(); rs.next())
				{
					rowNum++;
				}// get row number
			}
			
			String data[][]=new String[rowNum+1][colNum+1];
			for (int i=0;i<(colNum);i++)
			{
				data[0][i]=rm.getColumnName(i+1);
			}
			for (rs.first();!rs.isAfterLast();rs.next())
			{
				
				for (int i=0;i<(colNum);i++)
				{
							data[lop][i]=rs.getString(i+1);
							
				}
				lop++;
			}
			for (int i=0;i<(rowNum+1);i++)
			{
				for (int k=0;k<(colNum+1);k++)
				{
					System.out.print(data[i][k]);
					System.out.print("|");
				}
				System.out.println("");
			}
			rs.close();
			stmt.close();
			conn.close();
			
		}
		catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (InstantiationException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (IllegalAccessException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		catch (ClassNotFoundException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}