selsend.java

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

package com.cctv1.spe.domain;


import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.*;


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

public class SelSend {
	
	
	private Connection conn = null;
	private Statement stmt = null;
	private ResultSet rs = null;

	public List<Sendnote> Allsend(){
		
		Alljdbc jdbc = new Alljdbc();
		
		conn = jdbc.Getlink();
		
		List<Sendnote> list = new ArrayList<Sendnote>();
		
		String sql = "select * from T_0712187_SENDNOTE";
		
		try {
			stmt  = conn.createStatement();
			
			rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				
				Sendnote note = new Sendnote();
				
				note.setSendid(rs.getInt(1));
				
				note.setContent(rs.getString(2));
				
				note.setPerson(rs.getString(3));
				
				list.add(note);
				
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		try {
			rs.close();
			stmt.close();
			conn.close();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			rs = null;
			stmt = null;
			conn = null;
			jdbc = null;
		}
		
		return list;
	}

}