Hi,
I try to connect to my database, but it keeps giving me NullPointerException on "stmt". I am wondering what's wrong with my code? Thanks.
/*== database constants ==*/
String dbhost = "localhost";
String dbname = "mysql";
String dbuser = "***";
String dbpass = "***";
Connection db = null;
Statement stmt = null;
ResultSet rs = null;
String dbdriver = "org.gjt.mm.mysql.Driver";
/*== setup database driver and connect ==*/
try{
Class.forName(dbdriver).newInstance();
}catch (Exception ex){}
String conurl = "jdbc:mysql://localhost:3336
atabase01";
try{
db = DriverManager.getConnection(conurl, dbname, dbpass);
}catch (SQLException ex){}
/*== create sql query and execute ==*/
String sql = " SELECT id, name FROM sample ";
try {
stmt = db.createStatement();
rs = stmt.executeQuery(sql);