package jp.ac.kcska.questionsystem.katsuta;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import jp.ac.kcska.questionsystem.Mst_questionVo;

public class getQuestion {

	public ArrayList<Mst_questionVo> getQuestion() {
		ArrayList<Mst_questionVo>list=new ArrayList<Mst_questionVo>();
		try {
			Connection connect = DriverManager.getConnection(
					"jdbc:mysql://localhost/questionsystem", "root", "mysql");
			String sql1 = "select * from mst_question";
			Statement stmt = connect.createStatement();
			ResultSet rs = stmt.executeQuery(sql1);

			while(rs.next()){
				int id=rs.getInt("id");
				int categoryid=rs.getInt("categoryid");
				int fieldid=rs.getInt("fieldid");
				String sentence=rs.getString("sentence");
				int imageid=rs.getInt("imageid");
				int examid=rs.getInt("examid");

				Mst_questionVo question=new Mst_questionVo();
				question.setId(id);
				question.setCategoryid(categoryid);
				question.setFieldid(fieldid);
				question.setSentence(sentence);
				question.setImageid(imageid);
				question.setExamid(examid);

				list.add(question);
			}




		} catch (SQLException e) {
			// TODO 自動生成された catch ブロ�?��
			e.printStackTrace();
		}
		return list;
	}
}