func.java

主要是描述的同学录系统

package com.page;
import com.user.*;
import com.page.*;
import java.sql.*;
import java.util.*;

public class Func {
	Conn c;
	Connection con;

	Statement stmt;

	ResultSet rs;	

	public List selectAll() {
		String sql="select * from test";	
		List list=new ArrayList();
		try {
			c=new Conn();
			con=c.getConn();
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			while(rs.next())
			{
				Vo vo=new Vo();
				vo.setId(rs.getString(1));
				vo.setName(rs.getString(2));
				list.add(vo);
			}
			rs.close();
			stmt.close();
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	
	public int countAll() {
		String sql="select count(*) from test";	
		int i=0;
		try {
			c=new Conn();
			con=c.getConn();
			stmt=con.createStatement();
			rs=stmt.executeQuery(sql);
			if(rs.next())
			{
				i=rs.getInt(1);
			}
			rs.close();
			stmt.close();
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return i;
	}
}