package dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class DatabaseExample {

	public String readAbc(Connection conn, String tableName) throws SQLException{
		int resultNum = 1;
		Statement statement = conn.createStatement();
		ResultSet resultSet = statement.executeQuery("SELECT no, name, point FROM " + tableName);
		String result = "";
		
		while(resultSet.next()){
			int x = resultSet.getInt("no");
			String s = resultSet.getString("name");
			float f = resultSet.getFloat("point");
			result += "result rows(" + resultNum++ + "): " + x + ", " +  s + ", " + f + "\n";
		}
		return result;
	}
}