dbbean.java

新闻管理系统

package newsset;

import java.sql.*;
public class DBBean
{
        private String driverstr = "oracle.jdbc.driver.OracleDriver";
        private String connstr = "jdbc:oracle:thin:@localhost:1521:ora";
        private Connection conn = null;
        private Statement stmt = null;
        //创建构造方法，负责加载驱动程序
        public DBBean()
        {
                try {
                        Class.forName(driverstr);
                }
                catch(ClassNotFoundException ex) {
                        System.out.println("数据库驱动程序加载错误");
                }
        }
        public void setDriverStr(String dstr)
        {
                driverstr=dstr;
        }
        public void setConnStr(String cstr)
        {
                connstr=cstr;
        }
        //查询数据
        public ResultSet executeQuery(String sql)
        {
                ResultSet rs = null;
                try {
                    conn = DriverManager.getConnection(connstr,"scott","tiger");
                    stmt = conn.createStatement();
                    rs = stmt.executeQuery(sql);
                }
                catch(SQLException ex) {
                        System.out.println("sql语法错误");
                }
                return rs;
        }
       //更新数据
        public int executeUpdate(String sql)
        {
                int result=0;
                try{
                        conn = DriverManager.getConnection(connstr,"scott","tiger");
                        stmt = conn.createStatement();
                        result = stmt.executeUpdate(sql);
                }
                catch(SQLException ex){
                        System.out.println("sql语法错误");
                }
                return result;
        }
       //关闭释放资源
        public void close()
        {
                try{
                        stmt.close();
                        conn.close();
                }
                catch(SQLException ex){
                        System.out.println("释放资源错误");
                }
        }
}