mysqlusereditpdao.java

来自「雷霆论坛是用J2EE技术开发的功能强大、扩展性强、易于定制」· Java 代码 · 共 37 行

package lightningboard.dao.mysql;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import lightningboard.db.DBConnectionManager;
import lightningboard.db.DBAccess;
import lightningboard.ActionException;
import lightningboard.dao.UserEditPDAO;

public class MysqlUserEditPDAO implements UserEditPDAO {
  private DBConnectionManager dbcm = DBConnectionManager.getInstance();
  public void execute(int u_id,int u_avatar_id,String u_password
                      ,String u_email,String u_address,String u_sign
                      ,String u_lastip)
      throws ActionException{
    Connection connection=null;
    try {
      connection=dbcm.getConnection();
      DBAccess dba=new DBAccess(connection);
      String sql="UPDATE lb_user SET u_avatar_id="+u_avatar_id
                +",u_password='"+u_password+"',u_email='"+u_email
                +"',u_address='"+u_address+"',u_sign='"+u_sign
                +"'"+",u_lastip='"+u_lastip+"'";
      sql+=" WHERE u_id="+ u_id;
      dba.runSql(sql);
    } catch (Exception ex) {
      throw new ActionException(ex);
    }finally{
      try {
        dbcm.freeConnection(connection);
      } catch (SQLException ex) {
        //
      }
    }
  }
}