/*******************************************************************\*                                                                   **			   LightningBoard			    **                                                                   **          http://sourceforge.net/projects/lightningboard/          **			                                            **	            Copyright (c) 2002 Xiaobo Liu	            **                                                                   ***********************************************************************                        LICENSE INFORMATION                        **                                                                   **  LightningBoard is free software; you can redistribute it and/or  **  modify it under the terms of the GNU General Public License as   **  published by the Free Software Foundation; either version 2 of   **  the License, or any later version.                               **                                                                   **  We don't charge anything for the use of LightningBoard, we only  **  require you to keep the copyright present on your site and in    **  the source files.                                                **                                                                   **  LightningBoard is distributed in the hope that it will be useful,**  but without any warranty; without even the implied warranty of   **  merchantability or fitness for a particular purpose. See the GNU **  General Public License for more details.                         **                                                                   *\*******************************************************************/package liuxiaobo.lb.dao;import java.sql.*;import liuxiaobo.db.*;import liuxiaobo.util.*;import liuxiaobo.lb.*;import liuxiaobo.lb.bean.*;public class RegisterDAO  {  private DBConnectionManager dbcm = DBConnectionManager.getInstance();  public int execute(String u_name,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="SELECT 1 from user WHERE u_name='"+u_name+"'";      ResultSet rs=dba.openSelect(sql);      if(rs.next()){        return 0;       }      rs.close();      dba.closeSelect();      CommonDAO idGen=new CommonDAO();      int u_id=idGen.getUserID(dba);      String u_regtime=DateTimeUtil.getDateTime();      sql="INSERT INTO user (u_id,u_name,u_password,u_email,u_regtime,u_post,u_address,u_sign,u_lasttime,u_lastip) VALUES ("         +u_id+",'"+ u_name+ "','"+ u_password+ "','"+ u_email+ "','"+ u_regtime         + "',0,'"+ u_address+ "','"+u_sign+ "','"+ u_regtime+"','"+u_lastip+"')";      dba.runSql(sql);      return u_id;    } catch (Exception ex) {      throw new ActionException(ex);    }finally{      try {        dbcm.freeConnection(connection);      } catch (SQLException ex) {        //      }    }  }}