JAVA调用ORACLE和MYSQL返回结果集

注意:此文档是本人由学习资料而成,用于测试JAVA调用ORACLE和MYSQL返回结果集的情况.

import java.sql.*;
import java.io.*;
//import oracle.jdbc.driver.*;

public class JDBCDemo {
//private String driver = "oracle.jdbc.driver.OracleDriver";
//private String url = "jdbc:oracle:thin:@192.168.1.213:1521:luke";
private String driver = "com.mysql.jdbc.Driver";
private String url = "jdbc:mysql://192.168.1.213:3306/luke";
private Connection conn = null;
public JDBCDemo()
throws ClassNotFoundException, SQLException {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, "luke", "luke");
}
catch (SQLException ex) {
System.out.println("Failed to establish a connection to: " + url);
throw ex;
}
}

private void execute(int n)
throws SQLException {
String query = "{call proc_shop_num(?,?,?) }";
System.out.println("Query: " + query + "n");
CallableStatement stmt = conn.prepareCall(query);

stmt.setInt(1,n);
stmt.setInt(2,3);
//stmt.registerOutParameter(1, OracleTypes.CURSOR);

//stmt.execute();
ResultSet rs = stmt.executeQuery();
//ResultSet rs = (ResultSet)stmt.getObject(1);
System.out.println(stmt.getInt(1));
while (rs.next()) {
System.out.println(rs.getString(2));
}

rs.close();
stmt.close();
}

private void cleanup() throws SQLException {

if (conn != null)
conn.close();
}
public static void main(String[] args) throws Exception {

JDBCDemo t = new JDBCDemo();
try {
t.execute(Integer.parseInt(args[0]));
t.cleanup();
}

catch (SQLException ex) {
System.out.println("Demo failed: " + ex.getMessage());
}

}
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/50509/viewspace-174255/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/50509/viewspace-174255/