oraclebean.java

javamail 自动翻译邮件

package Common;
import java.util.*;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class OracleBean {
    private String strUrl = "jdbc:mysql://localhost/trans?useUnicode=true&amp;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();
        }
	}
}