dispose.java

sql+struts+jsp 提供考试的一般需求

package examanpai;
import java.text.SimpleDateFormat;
import javax.sql.DataSource;
import java.util.ArrayList;
import java.sql.*;
import java.util.Calendar;

public class dispose {
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;
    public dispose(DataSource ds){
        try{
            conn=ds.getConnection();
        }catch(Exception e){}
    }

    public ResultSet queryInfo(String sql){
        try{
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs=stmt.executeQuery(sql);
        }catch(Exception e){}
        return rs;
    }

    public ArrayList ResourceList(String sql){
        ArrayList arr=new ArrayList();
        try{
            stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs=stmt.executeQuery(sql);
            while(rs.next()){
                examapActionForm apform = new examapActionForm();
                apform.setId(rs.getString(1));
                apform.setFilename(rs.getString(2));
                apform.setUrl(rs.getString(3));
                arr.add(apform);
            }
        }catch(Exception e){}
        return arr;
    }

    public String getTime(){
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd E");
        String time=sdf.format(Calendar.getInstance().getTime());
        return time;
    }

}