testjdbc.java

java程序与oracle数据库的连接实例

import java.sql.*;
import java.io.*;
public class TestJdbc {
	public static void main(String[] args) {
		Connection conn=null;
		Statement stmt=null;
		ResultSet rs=null;//结果集
		String dbdriver ="oracle.jdbc.driver.OracleDriver";
		try{
			
	       Class.forName("oracle.jdbc.driver.OracleDriver");//加载驱动
		}
		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); //启动连接
	        	 System.out.println("connect succeed");
	        	 
	           stmt=conn.createStatement();//
	           
	          rs = stmt.executeQuery ("select * from student");//查询数据库列表
	           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(); }
	}
}