import java.sql.*;
import javax.swing.JOptionPane;

/**
 *
 * @author Asif Khan
 */
public class myDbConnection {

        static final String JDBC_DRIVER = "org.apache.derby.jdbc.ClientDriver";
        static final String DATABASE_URL = "jdbc:derby://localhost:1527/cddb";
         static  Connection connection;
        static Statement statement;
        static StringBuffer results ;
        static  ResultSetMetaData metaData ;
        static ResultSet resultSet ;
        static StringBuffer results2 ;

    public  myDbConnection(){
             try {
                    Class.forName( JDBC_DRIVER );
                     connection = DriverManager.getConnection( DATABASE_URL );
                     statement = connection.createStatement();
             } catch ( SQLException sqlException ) {
                     JOptionPane.showMessageDialog( null, sqlException.getMessage(),
                   "Database Error", JOptionPane.ERROR_MESSAGE );
      }

      catch ( ClassNotFoundException classNotFound ) {
                 JOptionPane.showMessageDialog( null, classNotFound.getMessage(),
                    "Driver Not Found", JOptionPane.ERROR_MESSAGE );
      }

    }

    public static  ResultSet excuteQuery(String query){
             try {
                      resultSet =   statement.executeQuery(query);

              } catch ( SQLException sqlException ) {
                 JOptionPane.showMessageDialog( null, sqlException.getMessage(),
                    "Database Error", JOptionPane.ERROR_MESSAGE );
              }
                 return resultSet ;
    }

     public static void excuteUpdate(String query){
          try {
              statement.executeUpdate(query);
      } catch ( SQLException sqlException ) {
             JOptionPane.showMessageDialog( null, sqlException.getMessage(),
                "Database Error", JOptionPane.ERROR_MESSAGE );
      }


    }
}