dbtest.java

jsp+Struts1.2+Hibernate3.1+mysql

package bbs.db;

import java.sql.ResultSet;
import java.sql.SQLException;

import bbs.struts.bean.MessageBean;

public class DBTest {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws SQLException {
		DB db = new DB ();
	
		String sql = "select * from user" ;
		ResultSet rs = db.query(sql) ;
		while (rs.next())
		{
			String username = rs.getString("username");
			String password = rs.getString("password");
			String email = rs.getString("email");
			System.out.println(username+password+email);
		}
		MessageBean guestBookModel = new MessageBean () ;
		guestBookModel.getMessages();
		
	}

}