- package lee;
- import oracle.jdbc.*;
- import oracle.jdbc.pool.OracleDataSource;
- import java.sql.*;
- public class BookQuerySql{
- private String bqs;
- public BookQuerySql(String booksql) {
- this.bqs = booksql;
- }
- OracleDataSource ods = null;
- Connection conn = null;
- Statement stmt = null;
- ResultSet rset = null;
- public void bookConnect() throws SQLException {
- ods = new OracleDataSource();
- ods.setURL("jdbc:oracle:thin:@localhost:1521:orcl");
- ods.setUser("scott");
- ods.setPassword("tiger");
- conn = ods.getConnection();
- }
- public ResultSet bookresult() throws SQLException {
- stmt = conn.createStatement();
- rset = stmt.executeQuery(bqs);
- return rset;
- }
- public void bookClosed() throws SQLException {
- if (rset != null)
- rset.close();
- if (stmt != null)
- stmt.close();
- if (conn != null)
- conn.close();
- }
- }
用的时候是这样
- package lee;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import lee.BookQuerySql;
- public class BookService {
- BookQuerySql mysql=new BookQuerySql("select * from emp");
- private String[] books=new String[20];
- private int i=0;
- public void getValue() throws SQLException{
- mysql.bookConnect();
- ResultSet myresult=mysql.bookresult();
- while (myresult.next ()){
- System.out.println(myresult.getString (1));
- books[i]=myresult.getString(1);
- i++;
- }
- mysql.bookClosed();
- }
- public String[] getLeeBooks()
- {
- return books;
- }
- }