oraclebean.java~3~

来自「java方面的很好的运行环境,这是一个通票系统.」· JAVA~3~ 代码 · 共 28 行

package votesystem;

import java.sql.*;

public class OracleBean {
    private String driver = "oracle.jdbc.driver.OracleDriver";
    private String url = "jdbc:oracle:thin:@172.17.92.102:1521:ora";
    private Connection conn;
    private Statement stmt;
    private ResultSet rs;

    public OracleBean() {
        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(url, "scott", "tiger");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
    public ResultSet query(String sql)
    {
        stmt=conn.createStatement();
        rs=stmt.executeQuery();
    }
}