JDBC连接数据库

package com.johnny;

import java.sql.*;


public class JDBCTest {
    String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
    String theUser = "user_name";
    String thePw = "user_pw";
    Connection c = null;
    Statement conn;
    ResultSet rs = null;

    public JDBCTest() {
        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;
        JDBCTest conn = new JDBCTest();
        rs = conn.executeQuery("select * from ser_area ");

        try {
            while (rs.next()) {
                System.out.println(rs.getString("AREAID"));
                System.out.println(rs.getString("AREANAME"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

输出结果为：

0
0-未知地区
0779
0779-北海地区
0770
0770-防城地区
0777
0777-钦州地区
0780
0780-崇左地区
0774
0774-梧州地区
0781
0781-来宾地区
0782
0782-贵港地区
0783
0783-贺州地区
0776
0776-百色地区
0772
0772-柳州地区
0775
0775-玉林地区
0773
0773-桂林地区
0778
0778-河池地区
0771
0771-南宁地区