www.pudn.com > mailVersion.rar > OracleBean.java

package Common; 
import java.util.*; 
import java.sql.*; 
/** 
 * 
Title: 
 
 * 
 * 
Description: 
 
 * 
 * 
Copyright: Copyright (c) 2006
 
 * 
 * 
Company: 
 
 * 
 * @author not attributable 
 * @version 1.0 
 */ 
public class OracleBean { 
    private String strUrl = "jdbc:mysql://localhost/trans?useUnicode=true&characterEncoding=utf8"; 
    private String driver = "org.gjt.mm.mysql.Driver"; 
    private Connection con; 
    private Statement stmm; 
    private ResultSet rs; 
    public OracleBean() { 
        try{ 
            Class.forName(driver).newInstance(); 
            con=DriverManager.getConnection(strUrl,"root","root"); 
        }catch(Exception e){ 
            e.getStackTrace(); 
        } 
    } 
    public ResultSet query(String sql){ 
        try{ 
            stmm = con.createStatement(); 
            rs = stmm.executeQuery(sql); 
        }catch(Exception e){ 
            e.getStackTrace(); 
        } 
        return rs; 
    } 
	public ResultSet back(String sql){ 
        try{ 
            stmm = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); 
            rs = stmm.executeQuery(sql); 
        }catch(Exception e){ 
            e.getStackTrace(); 
        } 
        return rs; 
    } 
    public int Update(String sql){ 
		int iCount = 0; 
        try{ 
            stmm = con.createStatement(); 
            iCount = stmm.executeUpdate(sql);			 
            
        }catch(Exception e){ 
            e.getStackTrace(); 
        } 
		return iCount; 
    } 
	public void close(){ 
		try{ 
      if(con != null){ 
				con.commit(); 
				con.close(); 
			} 
            
        }catch(Exception e){ 
            e.getStackTrace(); 
        } 
	} 
}