java连接oracle数据库

package grp.salary.person;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Test {

	public static void main(String[]args) throws Exception {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		String url="jdbc:oracle:thin:@127.0.0.1:1521/orcl";
		String uname ="test";
		String pwd = "a";
		Connection con = DriverManager.getConnection(url,uname,pwd);
		System.out.println(con.getClass().getName());
		
		Statement stmt = con.createStatement();
		//1.插入
		String insertSql = "insert into T_table (id,agency_name) values('主键id','咕咕鸡3')";
		stmt.execute(insertSql);
		//2.查询
		String sql = "select agency_name from T_table";
		ResultSet rs = stmt.executeQuery(sql);
		while(rs.next()) {
			System.out.println("机构名称:"+rs.getObject("agency_name"));
		}
		
		//3.删除
		String deleteSql = "delete from T_table where agency_name = '咕咕鸡3'";
		stmt.execute(deleteSql);
		
		//4.更新
		String updateSql = "update T_table set agency_name = '咕咕鸡99' where agency_name = '咕咕鸡'";
		stmt.execute(updateSql);

		//更新date类型的时间字段
				//获取当前系统的日期
		Date date = new Date();
		//日期标准格式
		SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		String nowDate = sdf.format(date);
        

    	String updateChange = "update t_table set oper_state = '1',oper_user = 'aa',oper_time = to_date('"+nowDate+"','yyyy-MM-dd HH24:mi:ss') where original_id = '7342739312896'";

        con.close();
		stmt.close();
		rs.close();
		
	}
    //获取当前时间
	public static Timestamp getCurrentDatetime() {
		Date date = new Date();
		Timestamp time = new Timestamp(date.getTime());
		return time;
	}

}