import java.sql.*;
public class JdbcTest
{
	public static void main(String[] args)
	{
		String url="jdbc:odbc:Mydatasource";
		Connection con=null;
		Statement sm=null;
		ResultSet rs=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		try
		{
			con=DriverManager.getConnection(url);// 實(shí)際上，我們可以將這個(gè)程序?qū)懗筛话愕男问剑床辉诔绦蛑泄潭ㄓ媚囊环N驅(qū)動(dòng)程序，
//不固定uRL、用戶名和口令，而是把它們作為參數(shù)，在程序執(zhí)行曲時(shí)候由用戶輸入see Page96
			sm=con.createStatement();
			//sm.executeUpdate("INSERT INTO Test " + "VALUES (001,'mary')");//It's strange that there must be a blank after the table name!
			sm.executeUpdate("insert into 操作員 " + "values('005','xiangxiang',' ','005',' ',' ')");
			rs=sm.executeQuery("SELECT* FROM 操作員 WHERE 狀態(tài) LIKE '在職'");
			while(rs.next()) 
			{
			   String opID=rs.getString(1);
			   String opName=rs.getString(2);
			   System.out.println("操作員ID:"+opID);
			   System.out.println("操作員姓名:"+opName);
			}

		}catch(SQLException ex)
		{
			ex.printStackTrace();
		}
		finally
		{
			try
			{
				rs.close();
				sm.close();
				con.close();
			}catch(SQLException ex)
				{
					ex.printStackTrace();
				}
		}
	}
}