package grad.util.course;import java.util.*;import java.sql.*;import grad.util.DataBase;import grad.util.course.resourse;import java.io.*;public class op_resourse {  public op_resourse() {  }  /**   * 查詢指定課程編號(hào)的所有可下載課程資源 type=2   * @param sourseid－課程編號(hào)   * @return   */public ArrayList getAllResourseByCourse(String sourseid)  {   Connection conn=null;   Statement st=null;   ResultSet rs=null;   String sql ="select * from t_resource where course_id='"+sourseid+"' and type=2";   ArrayList al=new ArrayList();   try{     DataBase ds = new DataBase();     conn = ds.conn;     st = conn.createStatement();     rs = st.executeQuery(sql);     while (rs.next()) {       resourse cs=new resourse();        cs.setid(rs.getInt(1));        cs.settitle(rs.getString(2));        cs.setcourse_id(rs.getString(3));        cs.setlink(rs.getString(4));        cs.setsdate(rs.getString(5));        cs.setext(rs.getString(6));        cs.setfilesize(rs.getString(7));        al.add(cs);     }     return al;   }catch(Exception e){System.out.println(e.getMessage());return null;}  }  /**   * 按擴(kuò)展名和課程編號(hào)，查詢課程資源，方便學(xué)生界面按ppt,word等分類展示   * @param sourseid   * @param ext   * @return   */  public ArrayList getAllResourseByCourseAndExt(String sourseid,String ext)    {     Connection conn=null;     Statement st=null;     ResultSet rs=null;     String sql ="select * from t_resource where course_id='"+sourseid+"' and ext='"+ext+"'";     ArrayList al=new ArrayList();     try{       DataBase ds = new DataBase();       conn = ds.conn;       st = conn.createStatement();       rs = st.executeQuery(sql);       while (rs.next()) {         resourse cs=new resourse();          cs.setid(rs.getInt(1));          cs.settitle(rs.getString(2));          cs.setcourse_id(rs.getString(3));          cs.setlink(rs.getString(4));          cs.setsdate(rs.getString(5));          cs.setext(rs.getString(6));          cs.setfilesize(rs.getString(7));          al.add(cs);       }       return al;     }catch(Exception e){System.out.println(e.getMessage());return null;}    }    /**     * 添加課程資源     * @param rs     */    public void addResourse(resourse rs)    {     Connection conn=null;     Statement st=null;     String sql="insert into t_resource(title,course_id,link,date,ext,filesize,type)values("+                " '"+rs.gettitle()+"',"+                " '"+rs.getcourse_id()+"',"+                " '"+rs.getlink()+"',"+                " getdate(),"+                " '"+rs.getext()+"',"+                " '"+rs.getfilesize()+"',"+                " '"+rs.getpower()+"')";            System.out.println(sql);     try{       DataBase ds = new DataBase();       conn = ds.conn;       st = conn.createStatement();       st.executeUpdate(sql);     }catch(Exception e){System.out.println(e.getMessage());return ;}    }    /**     * 刪除課程資源     * @param id     */    public void delResourse(String id)    {    Connection conn=null;    Statement st=null;    String sql="delete from t_resource where id='"+id+"'";           System.out.println(sql);    try{      DataBase ds = new DataBase();      conn = ds.conn;      st = conn.createStatement();      st.executeUpdate(sql);    }catch(Exception e){System.out.println(e.getMessage());return ;}    }    /**     * 取出資源編號(hào)最大值。資源上傳后是按這個(gè)編號(hào)加擴(kuò)展名萊存儲(chǔ)的     * 前臺(tái)瀏覽和下載都是按編號(hào)+擴(kuò)展名去尋找資源的     * @return     */    public int getMaxId()      {      Connection conn=null;      Statement st=null;      ResultSet rs=null;      int id=0;      String sql="select max(id) from t_resource ";             System.out.println(sql);      try{        DataBase ds = new DataBase();        conn = ds.conn;        st = conn.createStatement();        rs = st.executeQuery(sql);      while (rs.next()) {         id=rs.getInt(1);      }          return id+1;      }catch(Exception e){System.out.println(e.getMessage());return 0;}      }}