discussdao.java

jdo开发实例,一个功能全面的oa系统

package com.gzrealmap.oa.action;

import java.sql.*;
import java.util.*;

import com.gzrealmap.lib.jdbc.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class discussDAO {
  JDBCUtil sql;

  public discussDAO() {
    sql = JDBCUtil.getInstance();
  }

  public void adddiscuss(discussForm fm) {
    try {
      sql.connect();
      Connection conn = sql.getConnection();
      PreparedStatement stm = conn.prepareStatement("insert into inndiscuss (inncontentid,inncontent,inndate,inman,indesc ) values(?,?,?,?,?)");
      stm.setString(1, fm.getInncontentid());
      stm.setString(2, fm.getInncontent());
      stm.setString(3, fm.getInman());
      stm.setString(4, fm.getInndate());
      stm.setString(5, fm.getIndesc());
      stm.execute();
      conn.close();
      stm.close();
      sql.disconnect();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public void deldiscuss(String ID) {

    try {
      sql.commit();
      String sql1 = "delete from inndiscuss  where  id =" + ID;
      sql.execute(sql1);
      sql.disconnect();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public void updatediscuss(String ID, discussForm fm) throws SQLException,
      Exception {
    try {
      String sqls = "";
      sql.connect();
      Connection conn = sql.getConnection();
      //String inncontentid = fm.getInncontentid();
      String inncontentid = fm.getInncontentid();
      String Inncontent = fm.getInncontent();
      String inman = fm.getInman();
      String inndate = fm.getInndate();
      String indesc = fm.getIndesc();

      sqls = "update innernews set inncontentid=?,Inncontent=?,inman=?,inndate=?,indesc=? where id=" + ID;
      PreparedStatement ps = conn.prepareStatement(sqls);
      ps.setString(1, inncontentid);
      ps.setString(2, Inncontent);
      ps.setString(3, inman);
      ps.setString(4, inndate);
      ps.setString(5, indesc);

      ps.execute();
      sql.disconnect();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  public Collection querydiscuss() {
    return null;
  }

}