lab3.java

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

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

public class Lab3
{
	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;
	  Statement stmt = null;
	  ResultSet rs = null;
	  try{
	    //1.加载驱动
		Class.forName(driverName);
		//2.连接数据库
        con = DriverManager.getConnection(
			url,username,pwd);
		//3.获取stmt对象
		stmt = con.createStatement();
		//System.out.println("stmt->"+stmt);
		//4.操作数据库(sql)
		String sql ="select * from t_sd0808";
		rs = stmt.executeQuery(sql);
		//5.处理结果集
		System.out.println("rs->"+rs);
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
		//6.关闭数据库相关对象
	    try{
		  con.close();
		}catch(Exception e1){
		  e1.printStackTrace();
		}
	  }
	}
}