Skip to main content
Made database connection class for my project that using mysql jdbc. I'm putting the code here incase anyone may find it usefull. Or you can download it from http://vc-digital.com/ConnectionDB.java

/*
* Created on March 25, 2005
*
*/
package sim;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.sql.*;
import java.util.Scanner;
import java.lang.String;

/**
* This source code is license under GPL
* Still working on password encryption
* You may use it, hack it and do what ever you want but please put my name as a credit if you

* are using this code for your application...
* If you find this code usefull for you please donate to the poor and homeless in your
* hood... giving to others will make you a better person. Trust me...
* Author o3ng. Contact me for any suggestion or question at avenpace@gmail.com
*
*/
class ConnectionDB {
private String [] cfg, cfgx;
private String read;
private Connection connection, connect;
private ResultSet rs;


public ConnectionDB() {
driverReg();
}
private String readConf() {
File fl = new File("db.conf");
try {
BufferedReader in = new BufferedReader(new FileReader(fl));
//String read;
read = in.readLine();

} catch (FileNotFoundException ee){
System.err.println("Can't find config file db.conf");
} catch (IOException oi){

}
return (read);
}
public ResultSet xecuteQuery(String query) {
String conRead = readConf();
System.out.println(conRead);
String delim = ":";
Scanner cfgFullx = new Scanner(conRead);
cfgFullx.useDelimiter(delim);
cfgx = new String[4];
int i = 0;
while (cfgFullx.hasNext()){
cfgx[i] = cfgFullx.next();
i++;
}
try {
Connection connection = DriverManager.getConnection("jdbc:mysql://" + cfgx[0] +"/" + cfgx[1] + "?user=" + cfgx[2] + "&password=" + cfgx[3]);
Statement statemen = connection.createStatement();
ResultSet rst = statemen.executeQuery(query);
setResult(rst);
//statemen.close();
//connection.close();

} catch (SQLException e) {
System.out.println("Connection error to the database");
}
getResult();
return this.rs;

}

public void updateQuery(String query) {
String conRead = readConf();
System.out.println(conRead);
String delim = ":";
Scanner cfgFull = new Scanner(conRead);
cfgFull.useDelimiter(delim);
cfg = new String[4];
int i = 0;
while (cfgFull.hasNext()){
cfg[i] = cfgFull.next();
//System.out.println(cfg[i]);
i++;
}
try {
Connection connect = DriverManager.getConnection("jdbc:mysql://" + cfg[0] +"/" + cfg[1] + "?user=" + cfg[2] + "&password=" + cfg[3]);
System.out.println(query);
Statement statement = connect.createStatement();
statement.executeUpdate(query);
statement.close();
connect.close();

} catch (SQLException e) {
System.out.println("Connection error to the database");
}
}


public void setResult(ResultSet frs){
this.rs = frs;
}

public ResultSet getResult(){
return this.rs;
}

public void driverReg(){
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("Register driver");
} catch (Exception e){
System.err.println("Can't find jdbc driver");
System.exit(1);
}
}

}

The db hostname, db name, user and password store in external file called db.conf
The content of the db.conf file is "dbhostname:dbname:dbuser:dbpassword"
You can use this class by construct an ConnectionDB class object, for example

ConnectionDB conn = new ConnectionDB();
queryUp = "INSERT INTO simtable SET sesi='test'";
conn.updateQuery(queryUp);

Comments

Popular posts from this blog

java MessageDigest

If you use MessageDigest in java to encrypt string, you wont get hash like other language does. So you need to convert the result so that you can compare the hash result with other output that produce by diff language. Found the function on the java net forum private static String baToHexString(byte byteValues[]) { byte singleChar = 0; if (byteValues == null || byteValues.length String entries[] = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f" }; StringBuffer out = new StringBuffer(byteValues.length * 2); for (int i = 0; i singleChar = (byte) (byteValues[i] & 0xF0); singleChar = (byte) (singleChar >>> 4); // shift the bits down singleChar = (byte...

hacking sierra wireless aircard 555 on suse 10

Since there's a lot of changes from pcmcia-cs to pcmciautils, pcmcia operation suppose to be easier because it now work with hotplug. That mean when the card got inserted to the laptop, linux will just recognize it in a zap. But that's just doesn't work for sierra aircard 555 while you using suse 10. To make your aircard 555 work on suse 10, you need to fiddle around a bit with linux kernel. Owww and you will need you kernel source because we need to recompile the serial_cs module! First, make sure when you insert the card to pcmcia slot and the pcmciautils recognize your card type "pccardctl info" then you should get following output on your shell ong@saintlucifer:~> pccardctl status Socket 0: command 'status' not yet handled by pccardctl o3ng@saintlucifer:~> pccardctl info PRODID_1="Sierra Wireless" PRODID_2="AirCard 555" PRODID_3="A555" PRODID_4="Rev 1" MANFID=0192,a555 FUNCID=6 Then you need to get Aircard ...

CapitalizeWords.java

I need to make my string sentence to be capitalize on each first character of word, So far haven't find such function that I can use. So made this simple class, incase someone need it. It's GPL so free to use it and modify it. import java.util.Scanner; import java.util.ArrayList; import java.util.Iterator; import java.lang.StringBuilder; /** * * @author avenpace * I'm using singleton here so, hope you know what that means ;) * license under the GPL so free to use, modify and hack whatever you want * lemme know if this programme benefit you if you had the time */ public class CapitalizeWords { private static CapitalizeWords capinstance; private CapitalizeWords() { } /** * The method will capitalizing every first character on each word on the String sentence * This method take two parameter, * @param source source sentence string that you want to capitalize on the first character if each word. * @param allword this argument...