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_choiceVo;

public class getChoice {

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

			while(rs.next()){
				int id=rs.getInt("id");
				String detail=rs.getString("detail");
				int questionid=rs.getInt("questionid");
				byte answerflag=rs.getByte("answerflag");

				Mst_choiceVo question=new Mst_choiceVo();
				question.setId(id);
				question.setDetail(detail);
				question.setQuestionid(questionid);
				question.setAnswerflag(answerflag);

				list.add(question);
			}




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

	}
}