lab2.java

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

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

public class Lab2
{
	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;
	  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 ="drop table t_sd0808";
		try{
		  stmt.executeUpdate(sql);
        }catch(Exception e1){
		  System.out.println("t_sd0808 不存在!");
		}
        sql = "create table t_sd0808("+
			"id number(12) primary key,"+
			"name varchar(30) not null)";
		stmt.executeUpdate(sql);

        sql = "insert into t_sd0808 values("+
			  "1,'Jack')";
		stmt.executeUpdate(sql);
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
	    try{
		  con.close();
		}catch(Exception e1){
		  e1.printStackTrace();
		}
	  }
	}
}