oraclebean.java

java方面的很好的运行环境,这是一个通票系统.

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)
    {
        try {
            stmt = conn.createStatement();
            rs=stmt.executeQuery(sql);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       return rs;
    }
    public void update(String sql)
    {
        try {
            stmt = conn.createStatement();
            stmt.executeUpdate(sql);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}