tblackimpl.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.pim.black;
import java.util.*;
import java.sql.*;
/**
 * <p>类名: TblackImpl</p>
 * <p>功能: black</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2006-01-09
 * @修改纪录
 */
public class TblackImpl
{
     public TblackImpl()
     {
          super();
     }
     private long blackid;
     private String mdn;
     private java.sql.Timestamp createdate;
     private long corporationid;
     private long staffid;
     private int statusid;
     public void setBlackid(long blackid)
     {
          this.blackid = blackid;
     }
     public long getBlackid()
     {
          return blackid;
     }
     public void setMdn(String mdn)
     {
          this.mdn = mdn;
     }
     public String getMdn()
     {
          return mdn;
     }
     public void setCreatedate(java.sql.Timestamp createdate)
     {
          this.createdate = createdate;
     }
     public java.sql.Timestamp getCreatedate()
     {
          return createdate;
     }
     public void setCorporationid(long corporationid)
     {
          this.corporationid = corporationid;
     }
     public long getCorporationid()
     {
          return corporationid;
     }
     public void setStaffid(long staffid)
     {
          this.staffid = staffid;
     }
     public long getStaffid()
     {
          return staffid;
     }
     public void setStatusid(int statusid)
     {
          this.statusid = statusid;
     }
     public int getStatusid()
     {
          return statusid;
     }
     /**
      * 创建数据，需要初始化类
      */
     public void create(Connection con,long blackid) throws SQLException
     {
          PreparedStatement stmt=null;
          ResultSet rs=null;
          String sql="";
          try{
               sql="select blackid,mdn,createdate,corporationid,staffid,statusid from tblack where blackid=?";
               stmt=con.prepareStatement(sql);
               stmt.setLong(1,blackid);
               rs=stmt.executeQuery();
               if(rs.next()){
                    this.blackid = rs.getLong("blackid");
                    mdn = rs.getString("mdn");
                    createdate = rs.getTimestamp("createdate");
                    corporationid = rs.getLong("corporationid");
                    staffid = rs.getLong("staffid");
                    statusid = rs.getInt("statusid");
               }
               stmt.close();
          }
          finally{
               if(stmt!=null) stmt.close();
          }
     }
     /**
      * 插入数据，无需要初始化类
      */
     public static int insert(Connection con,long blackid,String mdn,java.sql.Timestamp createdate,long corporationid,long staffid,int statusid) throws SQLException
     {
          PreparedStatement stmt=null;
          String sql="";
          int cnt=0;
          try
          {
               sql="insert into tblack "+
                   "(blackid,mdn,createdate,corporationid,staffid,statusid) "+
                   "values (?,?,?,?,?,?)";
               stmt=con.prepareStatement(sql);
               stmt.setLong(1, blackid);
               stmt.setString(2, mdn);
               stmt.setTimestamp(3, createdate);
               stmt.setLong(4, corporationid);
               stmt.setLong(5, staffid);
               stmt.setInt(6, statusid);
               cnt=stmt.executeUpdate();
               stmt.close();
          }
          finally
          {
               if(stmt!=null) stmt=null;
          }
          return cnt;
     }
     /**
      * 插入数据，需要初始化类，并将设置类的域
      */
     public int insert(Connection con) throws SQLException
     {
          PreparedStatement stmt=null;
          String sql="";
          int cnt=0;
          try
          {
               sql="insert into tblack "+
                   "(blackid,mdn,createdate,corporationid,staffid,statusid) "+
                   "values (?,?,?,?,?,?)";
               stmt=con.prepareStatement(sql);
               stmt.setLong(1, blackid);
               stmt.setString(2, mdn);
               stmt.setTimestamp(3, createdate);
               stmt.setLong(4, corporationid);
               stmt.setLong(5, staffid);
               stmt.setInt(6, statusid);
               cnt=stmt.executeUpdate();
               stmt.close();
          }
          finally
          {
               if(stmt!=null) stmt=null;
          }
          return cnt;
     }
     /**
      * 更新数据，无需要初始化类
      */
     public static int update(Connection con,long blackid,String mdn,java.sql.Timestamp createdate,long corporationid,long staffid,int statusid) throws SQLException
     {
          PreparedStatement stmt=null;
          String sql="";
          int cnt=0;
          try
          {
               sql="update tblack set mdn=?,createdate=?,corporationid=?,staffid=?,statusid=? where blackid=?";
               stmt=con.prepareStatement(sql);
               stmt.setString(1, mdn);
               stmt.setTimestamp(2, createdate);
               stmt.setLong(3, corporationid);
               stmt.setLong(4, staffid);
               stmt.setInt(5, statusid);
               stmt.setLong(6, blackid);
               cnt=stmt.executeUpdate();
               stmt.close();
          }
          finally
          {
               if(stmt!=null) stmt=null;
          }
          return cnt;
     }
     /**
      * 更新数据，需要初始化类，并将设置类的域
      */
     public int update(Connection con) throws SQLException
     {
          PreparedStatement stmt=null;
          String sql="";
          int cnt=0;
          try
          {
               sql="update tblack set mdn=?,createdate=?,corporationid=?,staffid=?,statusid=? where blackid=?";
               stmt=con.prepareStatement(sql);
               stmt.setString(1, mdn);
               stmt.setTimestamp(2, createdate);
               stmt.setLong(3, corporationid);
               stmt.setLong(4, staffid);
               stmt.setInt(5, statusid);
               stmt.setLong(6, blackid);
               cnt=stmt.executeUpdate();
               stmt.close();
          }
          finally
          {
               if(stmt!=null) stmt=null;
          }
          return cnt;
     }
     /**
      * 删除一条数据
      */
     public static int delete(Connection con,long blackid) throws SQLException
     {
          PreparedStatement stmt=null;
          String sql="";
          int cnt=0;
          try{
               sql="delete from tblack where blackid=?";
               stmt=con.prepareStatement(sql);
               stmt.setLong(1,blackid);
               cnt=stmt.executeUpdate();
               stmt.close();
          }
          finally{
               if(stmt!=null) stmt.close();
          }
          return cnt;
     }
     /**
      * 删除多条数据
      */
     public static int delete(Connection con, String blackid[]) throws SQLException
     {
          PreparedStatement stmt=null;
          String sql="";
          int cnt=0;
          int i=0;
          try{
               sql="delete from tblack where blackid in (";
               for (i=0;i<blackid.length;i++ ) {
                    if(i==0) sql=sql+blackid[i];
                    else sql=sql+","+blackid[i];
               }
               sql=sql+")";
               stmt = con.prepareStatement(sql);
               cnt=stmt.executeUpdate();
               stmt.close();
          }
          finally{
               if(stmt!=null) stmt.close();
          }
          return cnt;
     }
}