orderdata.java.bak

java与mdb,一个简单的java访问数据库系统

import java.sql.*;

public class OrderData 
{
	private Statement stmt=null;
	ResultSet rs=null;
	private Connection con=null;
	String sql;
	String strUrl="jdbc:odbc:CRRS";
  
	public OrderData()
	{
	}
	//打开数据连接
	public void OpenConn() throws Exception
	{
		try 
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection(strUrl);
		}
		catch(Exception e)
		{
			System.out.println("OpenCon : "+e.getMessage());
		}
	}

	//将会议室定单信息写入数据库
	public void insertOrder(String sql)
	{
		stmt=null;
		rs=null;
		try
		{
			stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			stmt.executeQuery(sql);
			con.commit();
		}
		catch(SQLException e)
		{
			//System.err.println("executeInsert : "+e.getMessage());
		}
	}
	
	//将已经预定会议室信息从数据库中读取出来并返回OrderList对象
	public OrderList selectOrderList(String sql)
	{
		Room rm;
		Applicant app;
		BusyTime bt;
		
		Order od;
		OrderList odl=new OrderList();
		stmt=null;
		rs=null;
		try
		{
			stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				String room=rs.getString("ol_Room");
				int capacity=rs.getInt("ol_Capacity");
				String applicant=rs.getString("ol_Applicant");
				String phone=rs.getString("ol_Phone");
				String date=rs.getString("ol_Date");
				String time=rs.getString("ol_Time");
				rm=new Room(room,capacity);
				app=new Applicant("?",applicant,"?","??????",phone);
				bt=new BusyTime(date,time);
				od=new Order(rm,app,bt);
				odl.getOd().add(od);
			}
		}
		catch(SQLException e)
		{
			System.err.println("executeSelect : "+e.getMessage());
		}
		return odl;
	}

	public void closeStmt()
	{
		try
		{
			stmt.close();
		}
		catch (SQLException e)
		{
			System.out.println("closeStmt:"+e.getMessage());
		}

	}
	//关闭数据库连接
	public void closeConn()
	{
		try 
		{
			con.close();
		}
		catch(SQLException ex)
		{
			System.err.println("aq.closeCon : "+ex.getMessage());
		}
	}
	public static String toGBK(String str)
	{
		try
		{
			if(str==null)   
			str="";
			else
			str=new String(str.getBytes("ISO-8859-1"),"GBK");  
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
		return str;
	}
}