lab6.java

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

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

public class Lab6
{
	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";
		int num = 0;
		if(stmt.execute(sql)){
		  rs = stmt.getResultSet();
		}else{
		  num = stmt.getUpdateCount();
		}
		 
		//5.处理结果集
		StringBuffer sb = new StringBuffer();
		while(rs.next()){
		  sb.append("id="+rs.getInt(1)+"  ");
		  sb.append("name="+rs.getString(2)+"\n");
		}
		System.out.print(sb.toString());
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
		//6.关闭数据库相关对象
	    try{
		  con.close();
		}catch(Exception e1){
		  e1.printStackTrace();
		}
	  }
	}
}