www.pudn.com > vote.rar > DBBean.java

/* 
 * DBBean.java 
 * 
 * Created on 2008Äê6ÔÂ4ÈÕ, ÉÏÎç9:23 
 * 
 * To change this template, choose Tools | Template Manager 
 * and open the template in the editor. 
 */ 
 
package mybean; 
 
import com.sun.crypto.provider.RSACipher; 
import java.sql.*; 
 
/** 
 * 
 * @author Administrator 
 */ 
public class DBBean { 
    private Connection conn; 
    private Statement stmt;     
     
    /** Creates a new instance of DBBean */ 
    public DBBean() { 
        try{ 
            //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");    
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
        } 
        catch(Exception e){ 
            e.printStackTrace(); 
        }         
    } 
     
     
    public ResultSet executeQuery(String sql){ 
        ResultSet rs=null; 
        try{ 
            //conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=vote;User=vote;Password=vote"); 
            conn=DriverManager.getConnection("jdbc:odbc:vote"); 
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
            rs=stmt.executeQuery(sql); 
        } 
        catch(Exception e){ 
            e.printStackTrace(); 
        } 
        return rs; 
    } 
     
     
    public int executeUpdate(String sql){ 
        int result=0; 
        try{ 
            //conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=vote;User=vote;Password=vote"); 
            conn=DriverManager.getConnection("jdbc:odbc:vote"); 
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
            result=stmt.executeUpdate(sql); 
        } 
        catch(Exception e){ 
            e.printStackTrace(); 
        } 
        return result; 
    } 
     
     
     
    public void close(){ 
        try{ 
            stmt.close(); 
            conn.close(); 
        } 
        catch(Exception e){ 
            e.printStackTrace(); 
        } 
    } 
     
     
     
     
}