|
public static void main(String[] args) throws Exception { // some configuration parameters String dbDriverClassName = "com.mysql.jdbc.Driver"; String dbUrl = "jdbc:mysql://localhost:3306/mydatabase"; String dbUid = "guest"; String dbPwd = "guestpassword"; // get a connection Class.forName(dbDriverClassName); Connection conn = DriverManager.getConnection(dbUrl, dbUid, dbPwd); // use yaorma to get the database data String sqlString = "select * from message_table order by row_id"; Data data = Database.query(sqlString, conn); // use the data for(int i=0;i<data.size();i++) { System.out.print(data.get(i).getString("rowId") + "\t"); System.out.print(data.get(i).getString("message")); } // done System.out.println("Done!"); }
|