- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Date;
- /**
- * 用JDBC连接Oracle并读取数据的例子。
- *
- * @author JAVA世纪网(java2000.net, laozizhu.com)
- */
- public class jdbc {
- String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
- String theUser = "scott";
- String thePw = "tiger";
- Connection c = null;
- Statement conn;
- ResultSet rs = null;
- public jdbc() {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
- c = DriverManager.getConnection(dbUrl, theUser, thePw);
- conn = c.createStatement();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public boolean executeUpdate(String sql) {
- try {
- conn.executeUpdate(sql);
- return true;
- } catch (SQLException e) {
- e.printStackTrace();
- return false;
- }
- }
- public ResultSet executeQuery(String sql) {
- rs = null;
- try {
- rs = conn.executeQuery(sql);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return rs;
- }
- public void close() {
- try {
- conn.close();
- c.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static void main(String[] args) {
- ResultSet rs;
- jdbc conn = new jdbc();
- rs = conn.executeQuery("select * from test");
- try {
- while (rs.next()) {
- System.out.println(rs.getString("id"));
- System.out.println(rs.getString("name"));
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
JDBC连接Oracle并读取数据的例子
最新推荐文章于 2021-04-14 20:26:06 发布