package 测试包;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Oracle存储过程 {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet res=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) { e.printStackTrace();
}
String url="jdbc:oracle:thin:@127.0.0.1:1521:Oraclename";
String user="system";
String password="GUO6";
try {
conn= DriverManager.getConnection(url,user,password);
System.out.println("已经成功连接数据库!!!");
stmt=conn.createStateme(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
res=stmt.executeQuery("select * from newtable1"); while(res.next())
{
System.out.println(res.getString(1)+" "+res.getString(2)+res.getString(3));
}
conn.close();//关闭连接数据库
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
以上的完整代码,结果只查出表的第一条记录,不过表是有10条记录的