lab4.java

JDBC的一些代码,希望对大家有点帮助~~

package com.tarena.jdbclab;
import java.sql.*;

public class Lab4
{
	public static void main(String[] args){
	  String driverName = 
		  "oracle.jdbc.driver.OracleDriver";
	  String url = 
		"jdbc:oracle:thin:@192.168.0.20:1521:tarena";
	  String username = "openlab";
	  String pwd = "open123";
	  Connection con = null;
	  try{
	    //1.加载驱动
		//Class.forName(driverName);
		//Driver d = 
		//	new oracle.jdbc.driver.OracleDriver();
        //DriverManager.registerDriver(d);

		//2.连接数据库
        con = DriverManager.getConnection(
			url,username,pwd);
		System.out.println("con->"+con);
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
	    try{
		  con.close();
		}catch(Exception e1){
		  e1.printStackTrace();
		}
	  }
	}
}