op_news.java

用jsp实现的在线教学系统

package grad.util.news;
import java.util.*;
import java.sql.*;
import grad.util.DataBase;

public class op_news {
  public op_news() {
  }
public ArrayList getAllNews()
  {
  Connection conn=null;
  Statement st=null;
  ResultSet rs=null;

  String sql ="select top 50 * from t_news order by date desc " ;

  ArrayList al=new ArrayList();
  try{
    DataBase ds = new DataBase();
    conn = ds.conn;
    st = conn.createStatement();
    rs = st.executeQuery(sql);
    while (rs.next()) {
      news ni=new news();
       ni.setid(rs.getInt(1));
       ni.settitle(rs.getString(2));
       ni.setdetail(rs.getString(3));
       ni.setdate(rs.getString(4));
       al.add(ni);

    }
    return al;
  }catch(Exception e){System.out.println(e.getMessage());return null;}

  }
  public news getOneNoticeById(String id)
  {
    Connection conn=null;
   Statement st=null;
   ResultSet rs=null;
   news ni=new news();
   String sql ="select * from t_news where id='"+id+"'" ;


   try{
     DataBase ds = new DataBase();
     conn = ds.conn;
     st = conn.createStatement();
     rs = st.executeQuery(sql);
     if (rs.next()) {
        ni.setid(rs.getInt(1));
        ni.settitle(rs.getString(2));
        ni.setdetail(rs.getString(3));
        ni.setdate(rs.getString(4));
     }
     return ni;
   }catch(Exception e){System.out.println(e.getMessage());return null;}

  }
  public void addNotice(news ni)
    {
      Connection conn = null;
      Statement st = null;
      String sql =
          "insert into t_news(title,detail,date)values(" +
          " '" +grad.util.DataFormate.toGb(ni.gettitle()) + "'," +
          " '" + grad.util.DataFormate.toGb(ni.getdetail()) + "'," +
          " getdate() )";

      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;
      }
    }
    public void delNotice(String id)
     {
       Connection conn = null;
       Statement st = null;
       String sql =
           "delete from t_news 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;
       }
     }

}