MsAccess.java

package gafetes;
import java.sql.*;

public class MsAccess{

    Connection conn;
    Statement stmt;
    PreparedStatement pStmt;  
    CallableStatement spStmt;
	
    String error="";	
    int intError = 0 ;

	
    public static final int NULL = 0;
    public static final int OK = 23;
    public static final int GENERAL_ERROR = -1;
	
	
		
    public MsAccess()	{

    }
    
    public   java.sql.Connection getConnection( )  
     {     

        String driver="1";
                String url="1"; String user="1"; String passwd="1";
        
        try {
            
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            // set this to a MS Access DB you have on your machine
            String filename = "c:/facturasjava/facturas.mdb";
            String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
            database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end
            
             conn = DriverManager.getConnection( database ,"",""); 
             
            //Class.forName( driver );
            //conn = java.sql.DriverManager.getConnection( url ,user,passwd );
                //conn = DriverManager.getConnection( url, user, passwd );
    			//showMessage(" Conexion exitosa ");      		
       }catch ( ClassNotFoundException ex ) {
               // showMessage("Cannot find the database driver classes.");
       }catch( java.sql.SQLException ex ) {
               //showMessage("Error al conectarse dentro de catch");
		//		tratarExcepcionSQL( ex );
       }  
        return conn;
    }	

        
    public Statement getStatement(){
     
        if( stmt == null )   {
            if( getConnection() == null )   {                
                //setError( ConnectionFactory.getError());				
								
            }            
            try {
                stmt    =   conn.createStatement();
            }catch( SQLException ex ){
                tratarExcepcionSQL( ex );                
            }
        }
        return stmt;    
    }
	

    public PreparedStatement getPreparedStatement( String sqlString ){
            if( getConnection() == null )   {                
                //setError( ConnectionFactory.getError());				                
                pStmt = null;
                //return pStmt;
            }else            
            {
	            try {
    	            pStmt    =   conn.prepareStatement( sqlString );
	            }
	            catch( SQLException ex ){
	                tratarExcepcionSQL( ex );
	            }
        	}        
	        return pStmt;            
    }


	
	 public CallableStatement getCallableStatement( String sqlString ){
            if( getConnection() == null )   {
                //setError( ConnectionFactory.getError());				                
                pStmt = null;
                //return pStmt;
            }else            
            {
	            try {
    	            spStmt    =   conn.prepareCall( sqlString );
	            }
	            catch( SQLException ex ){
	                tratarExcepcionSQL( ex );
	            }
        	}        
	        return spStmt;            
    }


    public ResultSet executeQuery( String sqlString )   {     
        ResultSet rs	= null ;
        if( getConnection() == null )   {	            
                rs = null;
                return rs;
        }
        try   {
            stmt    =   conn.createStatement();
            rs		=	stmt.executeQuery( sqlString );
            //System.out.println( sqlString );		
        }
        catch( SQLException ex )   {
            tratarExcepcionSQL( ex );
        }
        return rs;
    }

    public int executeUpdate( String sqlString )   {     
    int returnValue = -1 ;

    if( getConnection() == null )   {
            setError(" Error al conectarse ");
            return GENERAL_ERROR;
    }
    try {
        stmt    =   conn.createStatement();
        stmt.executeUpdate( sqlString );                    
        returnValue =  OK;        
    }
    catch( SQLException ex ){
        tratarExcepcionSQL( ex );
        returnValue = GENERAL_ERROR;
    }


    //System.out.println(sqlString);
    return returnValue;


}

    public void showMessage( String message )	{
            //System.out.println( message );
    }

    public void close()
    {
    System.out.println("Closing DB connection");
    try
        {
            if ( stmt != null)
                    {
                            stmt.close();
                }

            if ( conn != null )
                    {
                    conn.close();
            }
        }

    catch (SQLException e)
            {
            tratarExcepcionSQL( e );
    }
}

    public static void tratarError( int ierror) {

            switch( ierror ) {

                    case 1216:


                    case 1217:

                    break ;

                    case 1062:
                        //javax.swing.JOptionPane.showMessageDialog(andrea.Application.getparentFrame(),"El registro ya existe");				
                    break;

                    case 3621:
                        //javax.swing.JOptionPane.showMessageDialog(andrea.Application.getparentFrame(),"El campo es demasiado largo");
                    break;

            }

    }

	
    public  static void tratarExcepcionSQL( java.sql.SQLException ex )
    {    	
    	do  
    	{   		
            System.out.println(ex.getMessage());
            tratarError(ex.getErrorCode());                
            ex = ex.getNextException();
    	}while( ex  != null );
    }        
    
    public  String getError()   {
        return error;
    }


    public   void setError( String errorString )   {
        error="";
        error = errorString ;
    }

}