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();
}
}