/*
 * Created on Apr 27, 2005
 *
 * Copyright Neal Katz
 */
package test;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * @author Neal Katz
 * 
 */
public class TestOne {
	String sql = "SELECT class_assignment_id, grade.student_id student_id, "
			+ "student.student_code student_code, honorific.name honorific,"
			+ "  person.first_name first_name, person.last_name last_name,"
			+ " curriculum.curriculum_id curriculum_id, "
			+ "grade_source.description description, year_code,"
			+ " semester.semester_id semester_id, section_number,"
			+ " class_unit.class_unit_id class_unit_id, "
			+ "semester.name semester_tname,"
			+ " semester.name_eng semester_ename, semester.AENm semester_AENm,"
			+ " semester.ATNm semester_ATNm, subject.subject_code subject_code,"
			+ " subject.name subject_tname, subject.name_eng subject_ename,"
			+ " subject.LectCrds subject_LectCrds,"
			+ " subject.NLectCrds subject_NLectCrds, "
			+ "subject.LectCost subject_LectCost,"
			+ " subject.NLectCost subject_NLectCost,"
			+ " subject.computerLabCredit computerLabCredit, subject.computerLabCost computerLabCost, major.FTName major_FTName, major.FEName major_FEName, faculty.FTName faculty_FTName, faculty.FEName faculty_FEName  FROM  student       INNER JOIN person ON (student.person_id = person.person_id)    "
			+ "INNER JOIN honorific ON (person.honorific_id = honorific.honorific_id)    INNER JOIN curriculum ON (student.curriculum_id = curriculum.curriculum_id)    INNER JOIN major ON (curriculum.major_id = major.major_id)    INNER JOIN faculty ON (curriculum.faculty_id = faculty.faculty_id)    "
			+ "INNER JOIN grade ON (student.student_id = grade.student_id)    INNER JOIN subject ON (grade.subject_code = subject.subject_code)    INNER JOIN class_unit ON (grade.class_unit_id = class_unit.class_unit_id)    INNER JOIN semester ON (class_unit.semester_id = semester.semester_id)    "
			+ "INNER JOIN grade_source ON (grade.grade_source_id = grade_source.grade_source_id) "
			+ "WHERE (  (  ( grade.student_id =  4770983  ) "
			+ "AND ( year_code =  2004  ) "
			+ "AND ( semester.semester_id =  101  )  ) ) "
			+ "ORDER BY class_assignment_id";

	public static void main(String[] args) {
		TestOne a = new TestOne();
		try {
			a.mysqlTest();
		} catch (Exception e) {
			e.printStackTrace();
			System.err.print(e);
		}
	}
	private void mysqlTest() throws Exception {
		String dbname = "stpneal2";
		DriverManager.setLogWriter(new PrintWriter(System.out));
		Class.forName("com.mysql.jdbc.Driver");
		Connection db = DriverManager.getConnection("jdbc:mysql:///" + dbname
				+ "?requireSSL=false&useUnicode=true&characterEncoding=UTF-8",
				"root", "neal1");
//		FileOutputStream fo = new FileOutputStream(
//				new File("c:\\thai_java.txt"));
//		PrintStream ps = new PrintStream(fo, true, "UTF-8");
		Statement st = db.createStatement();
		ResultSet rs = st.executeQuery(sql);
		System.out.println("got "+rs.getFetchSize()+" rows");  // returns 0 incorrectly
		int idx = 0;
		System.out.println("rs.first() = "+rs.first());   // return TRUE, correctly
		
		while (rs.next()) {    // will process 2 rows,   which is correct
			idx++;
			System.out.println("row "+idx);
			for(int j=1;j!= 10;j++) {
				System.out.println("   "+rs.getString(j));
			}
		}
		st.close();
	}
}