www.pudn.com > ClientManager.rar > UserGzbwDaoImpl.java

package com.dao; 
 
import java.util.List; 
import com.domain.UserGzbwForm; 
import com.tool.JDBConnection; 
import java.util.ArrayList; 
import com.tool.SQLCode; 
import java.sql.ResultSet; 
import java.sql.*; 
 
/** 
 * 
Title: 
 
 * 
 * 
Description: 
 
 * 
 * 
Copyright: Copyright (c) 2005
 
 * 
 * 
Company: 
 
 * 
 * @author not attributable 
 * @version 1.0 
 */ 
//工作备忘 
public class UserGzbwDaoImpl 
    implements UserGzbwDao { 
//  private JDBConnection connection = new JDBConnection(); 
  //查询工作备忘记录 
  public List userGzbwselect(UserGzbwForm form) { 
    List list = new ArrayList(); 
    UserGzbwForm gzbw = null; 
    String sql = SQLCode.getSQLCode("sql.userGzbw.select"); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_manager()); 
    Connection conn=null; 
    Statement stmt=null; 
    ResultSet rs = null; 
    try { 
      rs = JDBConnection.executeQuery(conn,stmt,sql); 
      while (rs.next()) { 
        gzbw = new UserGzbwForm(); 
        gzbw.setGzbw_id(rs.getString(1)); 
        gzbw.setGzbw_bt(rs.getString(2)); 
        gzbw.setGzbw_nr(rs.getString(3)); 
        gzbw.setGzbw_jsrq(rs.getString(4)); 
        gzbw.setGzbw_bz(rs.getString(5)); 
        gzbw.setGzbw_manager(rs.getString(6)); 
        gzbw.setId(Integer.valueOf(rs.getString(7))); 
        list.add(gzbw); 
      } 
    } 
    catch (SQLException ex) { 
    	ex.printStackTrace(); 
    }finally{ 
    	JDBConnection.close(rs,stmt,conn); 
    } 
     
    return list; 
  } 
 
//帐号的唯一性 
  public int countID() { 
    int iCount = 0; 
    String sql = SQLCode.getSQLCode("sql.userGzbw.countID"); 
    Connection conn=null; 
    Statement stmt=null; 
    ResultSet rs = null; 
    try { 
      rs = JDBConnection.executeQuery(conn,stmt,sql); 
      while (rs.next()) { 
        iCount = rs.getInt("t"); 
      } 
    } 
    catch (SQLException ex) { 
    	ex.printStackTrace(); 
    } finally{ 
    	JDBConnection.close(rs,stmt,conn); 
    } 
     
    return iCount + 1; 
  } 
 
  //插入操作 
  public void userGzbwInsert(UserGzbwForm form) { 
    String sql = SQLCode.getSQLCode("sql.userGzbw.insert"); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_id()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_bt()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_nr()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_jsrq()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_bz()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_manager()); 
    JDBConnection.executeUpdate(sql); 
     
  } 
 
  //删除操作 
  public void userGzbwDelete(UserGzbwForm form) { 
    String sql = SQLCode.getSQLCode("sql.userGzbw.delete"); 
    sql = JDBConnection.editSqlCode(sql, form.getId()); 
    JDBConnection.executeUpdate(sql); 
     
  } 
 
//单独查询 
  public UserGzbwForm userGzbwSelectOne(UserGzbwForm form) { 
    UserGzbwForm gzbw = null; 
    String sql = SQLCode.getSQLCode("sql.userGzbw.selectOne"); 
    sql = JDBConnection.editSqlCode(sql, form.getId()); 
    Connection conn=null; 
    Statement stmt=null; 
    ResultSet rs = null; 
    try { 
       rs = JDBConnection.executeQuery(conn,stmt,sql); 
      while (rs.next()) { 
        gzbw = new UserGzbwForm(); 
        gzbw.setGzbw_id(rs.getString(1)); 
        gzbw.setGzbw_bt(rs.getString(2)); 
        gzbw.setGzbw_nr(rs.getString(3)); 
        gzbw.setGzbw_jsrq(rs.getString(4)); 
        gzbw.setGzbw_bz(rs.getString(5)); 
        gzbw.setGzbw_manager(rs.getString(6)); 
        gzbw.setId(Integer.valueOf(rs.getString(7))); 
      } 
    } 
    catch (SQLException ex) { 
    	ex.printStackTrace(); 
    } 
     
    return gzbw; 
  } 
 
//修改操作 
  public void userGzbwUpdate(UserGzbwForm form) { 
    String sql = SQLCode.getSQLCode("sql.userGzbw.update"); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_bt()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_nr()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_bz()); 
    sql = JDBConnection.editSqlCode(sql, form.getGzbw_jsrq()); 
    sql = JDBConnection.editSqlCode(sql, form.getId()); 
    JDBConnection.executeUpdate(sql); 
     
 
  } 
}