I generally use MySQL along with my Java applications, and re-use a Singleton class I created a while back to connect to the database. It contains insert and query methods, but apart from that, it’s pretty basic. Just thought it might be useful for someone if I post it up here.
import com.mysql.jdbc.Connection; import java.sql.*; import java.sql.DriverManager; /** * @desc A singleton database access class for MySQL * @author Ramindu */ public final class MysqlConnect { public Connection conn; private Statement statement; public static MysqlConnect db; private MysqlConnect() { String url= "jdbc:mysql://localhost:3306/"; String dbName = "database_name"; String driver = "com.mysql.jdbc.Driver"; String userName = "username"; String password = "password"; try { Class.forName(driver).newInstance(); this.conn = (Connection)DriverManager.getConnection(url+dbName,userName,password); } catch (Exception sqle) { sqle.printStackTrace(); } } /** * * @return MysqlConnect Database connection object */ public static synchronized MysqlConnect getDbCon() { if ( db == null ) { db = new MysqlConnect(); } return db; } /** * * @param query String The query to be executed * @return a ResultSet object containing the results or null if not available * @throws SQLException */ public ResultSet query(String query) throws SQLException{ statement = db.conn.createStatement(); ResultSet res = statement.executeQuery(query); return res; } /** * @desc Method to insert data to a table * @param insertQuery String The Insert query * @return boolean * @throws SQLException */ public int insert(String insertQuery) throws SQLException { statement = db.conn.createStatement(); int result = statement.executeUpdate(insertQuery); return result; } }
Cheers!