lab2.java

还是关于jdbc的

package com.tarena.jdbc.lab;
import java.sql.*;

public class Lab2
{
	public static void main(String[] args){
	  Connection con = null;
	  Statement stmt = null;
	  try{
	    //1.加载驱动
		String driverName = 
			"oracle.jdbc.driver.OracleDriver";
		Class.forName(driverName);
		//2.建立数据库连接
		String url = "jdbc:oracle:thin:@192.168.0.20"+
			   ":1521:tarena";
		String username = "openlab";
		String pwd = "open123";
		con = DriverManager.getConnection(
			url,username,pwd);
		//3.获取Statement对象
		stmt = con.createStatement();
		System.out.println("stmt->"+stmt);
		
		String sql ="drop table t_test";
		try{
		  stmt.executeUpdate(sql);
		}catch(Exception e1){
		  System.out.println("表t_test不存在！");
		}

		sql= "create table t_test("+
			"id number(12) primary key,"+
			"name varchar(30) not null)";
        stmt.executeUpdate(sql);

		sql = "insert into t_test values("+
			"1,'Jack')";
		stmt.executeUpdate(sql);

	  }catch(Exception e){
	     e.printStackTrace();
	  }finally{
	     try{
		   stmt.close();
		 }catch(Exception e1){
		   e1.printStackTrace();
		 }
		 try{
		   con.close();
		 }catch(Exception e1){
		   e1.printStackTrace();
		 }
	  }
	}
}