JayBird - Firebird JDBC link

Get the required JAR from http://www.firebirdsql.org/index.php?op=files&id=jaybird

/**

*

*/

package link.db.my;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Properties;

import org.apache.log4j.Logger;

/**

* @author E. Kaparulin

*/

public class JayBird {

        private Connection conn = null;

        private String Url = "jdbc:firebirdsql:127.0.0.1/3050:mydb";

        private String dbUserName = "user";

        private String dbUserPass = "password";

        private String dbCharSet = "ASCII";

        static final Logger logger = Logger.getLogger("org.firebirdsql");

        public JayBird() {

                System.setProperty("FBLog4j", "true");

                Properties props = new Properties();

                props.setProperty("user", dbUserName);

                props.setProperty("password", dbUserPass);

                props.setProperty("encoding", dbCharSet);

                try {

                        Class.forName("org.firebirdsql.jdbc.FBDriver");

                        try {

                                conn = DriverManager.getConnection(Url, props);

                        } catch (SQLException e) {

                                logger.fatal(e.getMessage());

                        }

                } catch (ClassNotFoundException e) {

                        logger.fatal(e.getMessage());

                }

        }

        private Connection getConnection(){

                return conn;

        }

        public int UpdateQuery(String Query) throws SQLException {

                int ret = -1;

                Connection sqlConn = getConnection();

                Statement Statement = sqlConn.createStatement();

                ret = Statement.executeUpdate(Query);

                Statement.close();

                return ret;

        }

        public ResultSet SelectQuery(String Query) throws SQLException {

                Connection sqlConn = getConnection();

                Statement Statement = sqlConn.createStatement();

                ResultSet rs = Statement.executeQuery(Query);

                return rs;

        }

}