import java.sql.*;
import java.io.*;
public class TestJdbc {
	public static void main(String[] args) {
		Connection conn=null;
		Statement stmt=null;
		ResultSet rs=null;//結(jié)果集
		String dbdriver ="oracle.jdbc.driver.OracleDriver";
		try{
			
	       Class.forName("oracle.jdbc.driver.OracleDriver");//加載驅(qū)動(dòng)
		}
		catch (Exception e)//捕捉異常
		{
			System.err.println("Error! " + e.getMessage());
			System.err.println("Please install JDBC-ODBC Driver first.");
			return;
		}
        System.out.println("dbdriver succeed");           
//  *********************************************************************************************
        String strUser = "scx";
		String strPass = "bnm123" ;
	    String   url ="jdbc:oracle:thin:@127.0.0.1:1521:XE";//連接串
	        try{

	               conn = DriverManager.getConnection(url, strUser, strPass); //啟動(dòng)連接
	        	 System.out.println("connect succeed");
	        	 
	           stmt=conn.createStatement();//
	           
	          rs = stmt.executeQuery ("select * from student");//查詢數(shù)據(jù)庫(kù)列表
	           while (rs.next())//遍歷
	           
	           {
	        	   System.out.println(rs.getString("sno")+rs.getString("sname"));
	           }

	         }catch(Exception e){  e.printStackTrace(); }
	         
	         //***************************************************************************************     
	         
	         try
	         {
	 			stmt.executeUpdate("insert into student values('004','SCX')");//增加
	 		  }
	 		catch(SQLException e){ System.err.println("executeInsert:"+e.getMessage()); }
		     System.out.println("insert succeed");
//	*********************************************************************************************     
		     try
	         {
	 			stmt.executeUpdate("update student set sname='master' where sno='001'");//更新
	 		  }
	 		catch(SQLException e){ System.err.println("executeUpdate:"+e.getMessage()); }
		     System.out.println("update succeed");
		     
//	***********************************************************************************************     
		     try
	         {
	 			stmt.executeUpdate("delete from student where sno='002'");//刪除
	 		  }
	 		catch(SQLException e){ System.err.println("executeDelete:"+e.getMessage()); }
		     System.out.println("delete succeed");
				
//	**********************************************************************************************			
		     try
		     { 
			     rs = stmt.executeQuery ("select * from student");//查詢
			     while (rs.next())
		         {
		      	   System.out.println(rs.getString("sno")+rs.getString("sname"));
		         }
			     
			     rs.close();
			     conn.close();

	         }catch(Exception e){  e.printStackTrace(); }
	}
}