Here is a simple example to select a row from a database and to display that information.
/*== database constants ==*/
string dbhost = “localhost”;
string dbname = “directory”;
string dbuser = “webuser”;
string dbpass = “–password–”;
string dbdriver = “org.gjt.mm.mysql.Driver”;
/*== setup database driver and connect ==*/
Class.forName(DBDRIVER).newInstance();
string conurl = “jdbc:mysql://”+dbhost+”/”+dbname;
Connection db = DriverManager.getConnection(conurl,dbuser,dbpass);
/*== create sql query and execute ==*/
string sql = ” SELECT firstname,lastname FROM users “;
Statement stmnt = db.createStatement();
ResultSet rs = stmnt.executeQuery(sql);
/*== display results ==*/
while (rs.next())
{
out.println(”Name: “+rs.getString(”firstname”)+ ” ” + rs.getString(”lastname”) +”\n”);
}
