import oracle.jdbc.*;
import java.sql.*;
import java.io.*;


import java.sql.PreparedStatement;//1：批處理 2：在創建時，可以先向數據庫發出一條帶參數的SQL，讓數據庫預先編譯好
									//3；只能針對所有更新操作
public class Test
{
	public static void main(String args[])
	{
		try
		{
			DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
			
			//瘦客戶端連接
			//Connection con=DriverManager.getConnection("jdbc:oracle:thin:@:1521:JW","scott","tiger");
			
			//胖客戶端連接
			Connection con=DriverManager.getConnection("jdbc:oracle:oci8:@LANLI","scott","tiger");
			byte b[]=new byte[1024];
			System.out.println("請輸入一個雇員編號？");
			System.in.read(b);
			String s=new String(b);
			s=s.trim();
				
			CallableStatement cs =con.prepareCall("begin ?:=my.a(?,?); end;");
			
			cs.registerOutParameter(1,java.sql.Types.DOUBLE);
			cs.setInt(2,Integer.parseInt(s));
			cs.registerOutParameter(3,java.sql.Types.VARCHAR);
			cs.execute();
			
			double d=cs.getDouble(1);
			String name=cs.getString(3);
			
			System.out.println("編號為"+s+"雇員的工資為\t"+d+"\t姓名為："+name);
				
			cs.close();
			
			con.close();
			
		}catch(Exception e){System.out.println(e.getMessage());}
	}
}