jdbc连接oracle数据库

来源：互联网发布：网络黑白txt下载编辑：程序博客网时间：2024/06/07 03:33
oracle驱动文件包: ojdbc.jar下载
package connect_oracle;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Connect {    private Connection cn;    private Statement statement;    private ResultSet resultSet;    public void getConnection(String url,String user,String password){        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            System.out.println("开始连接...");            cn = DriverManager.getConnection(url, user, password);            System.out.println("连接成功");        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }    public ResultSet query(String sql){        try {            statement = cn.createStatement();            resultSet = statement.executeQuery(sql);        } catch (SQLException e) {            e.printStackTrace();        }        return resultSet;    }    public void close(){        try {            resultSet.close();            statement.close();            cn.close();        } catch (SQLException e) {            e.printStackTrace();        }    }    public static void main(String[] args) {        Connect connect = new  Connect();        String url = "jdbc:oracle:thin:@localhost:1521:hatech";        String user = "scott";        String password = "*****";        connect.getConnection(url,user,password);        String sql = "select * from test t where t.id=2";        ResultSet rs = connect.query(sql);        try {            while(rs.next()){                System.out.println(rs.getString("name"));            }        } catch (SQLException e) {            e.printStackTrace();        }        connect.close();    }}
0 0