studentbiz.java

来自「达内JAVA培训-WEB课程部分项目源代码」· Java 代码 · 共 54 行

package cn.com.tarena.web.servlet.day3.biz;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import cn.com.tarena.web.servlet.day3.pojo.Student;
import cn.com.tarena.web.servlet.day3.util.ConnectionFactory;

public class StudentBiz {
	public List findAll(){
		List studentList = new ArrayList();
		
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			conn = ConnectionFactory.getConnByJNDI();
			System.out.println("conn = " + conn);
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select USER_NAME,PASSWORD,PROVINCE,GENDER,HOBBIES from student");
			
			while(rs.next()){
				Student student = new Student();
				
				student.setUserName(rs.getString("USER_NAME"));
				student.setPassword(rs.getString("PASSWORD"));
				student.setProvince(rs.getString("PROVINCE"));
				student.setGender(rs.getString("GENDER"));
				student.setHobbies(rs.getString("HOBBIES"));
				
				studentList.add(student);
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			throw new RuntimeException("error when query students!",e);
		} finally {
			try{
				stmt.close();
				conn.close();				
			} catch (Exception e){
				throw new RuntimeException("error when query students!",e);
			}

		}
		
		return studentList;
	}
}