selans.java

主要是一个中央电视台节目点播程序,完成了一些简单的功能

package com.cctv1.spe.domain;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.cctv1.spe.conn.Alljdbc;
import com.cctv1.spe.dao.Answernote;

public class SelAns {
	
	
	private Connection conn = null;
	
	private PreparedStatement pre = null;
	
	private ResultSet rs = null;

	public List<Answernote> Allans(int number){
		
		Alljdbc jdbc = new Alljdbc();
		
		conn = jdbc.Getlink();
		
		List<Answernote> list = new ArrayList<Answernote>();
		
		String sql = "select * from T_0712187_ANSWERNOTE where target = ?";
		
		try {
			
			pre = conn.prepareStatement(sql);
			
			pre.setInt(1, number);
			
			rs = pre.executeQuery();
			
			while(rs.next())
			{
				Answernote an = new Answernote();
				an.setAnswerid(rs.getInt(1));
				an.setContent(rs.getString(2));
				an.setPerson(rs.getString(3));
				an.setTarget(rs.getInt(4));
				list.add(an);
				
			}
			
		} catch (SQLException e) {
			
			
			e.printStackTrace();
		}
		try {
			rs.close();
			pre.close();
			conn.close();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			
			rs = null;
			pre = null;
			conn = null;
			jdbc = null;
			
			
		}
		
		return list;
	}

}