oracle连接监控java,java 连接oracle数据库方法

package TestDemo;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.Time;

public class Test_Oracle_0519 {

private static String user = "daily";

private static String passwd = "mdasil";

private static String diver = "oracle.jdbc.OracleDriver";

private static String url = "jdbc:oracle:thin:@127.0.0.1:8000:daily";

static Connection connection = null;

Statement stmt = null;

ResultSet rs = null;

public void SelectData(){

try {

try {

Class.forName(diver);

connection = DriverManager.getConnection(url,user,passwd);

System.out.println("连接成功");

stmt = connection.createStatement();

String sql = "Call drop_table_all('201406')";

rs = stmt.executeQuery(sql);

System.out.println(a);

/* while (rs.next()){

Time ci = rs.getTime("sysdate");

System.out.println(ci);

} */

//System.out.println(rs);

} catch (ClassNotFoundException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

public static void main (String []args){

Test_Oracle_0519 ts = new Test_Oracle_0519();

ts.SelectData();

}

}