dbbean.java

这个是用jsp编写的投票系统代码

/*
 * 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();
        }
    }
    
    
    
    
}