JDBC连接Oracle并读取数据的例子
来源:互联网 发布:2015海关编码数据库 编辑:程序博客网 时间:2024/05/18 23:27
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Date;
-
-
-
-
-
-
- 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();
- }
- }
- }