[java] 영문+숫자 랜덤 생성, 쿠폰

 
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="javax.sql.*, java.sql.*, oracle.jdbc.pool.OracleDataSource,oracle.jdbc.OracleDriver, kr.co.louismobile.Paging, kr.co.louismobile.Cvt"%>
<%@ include file="../inc/common.jsp" %>
<%@ include file="../inc/dbconn_init.jsp" %>
<%@ include file="../inc/dbconn_mobile.jsp" %>
<%@ include file="../inc/dbconn_erp.jsp" %>
<%
 
for( int m = 0, n= 100; m<n; m++ ){
 
    //숫자 + 영문자 랜덤 10자리 문자 추출
    Random rnd = new Random();
    StringBuffer buf = new StringBuffer();
    
    for(int i = 0; i < 10; i++){
        if(rnd.nextBoolean()){
            buf.append((char)((int)(rnd.nextInt(26))+65));
        }else{
            buf.append((rnd.nextInt(10)));
        }
    
    }
    
    //DB 저장유무 확인,  있으면 다시 랜덤문자 추출 없다면 저장 (14% 쿠폰 : 1만개, 10%쿠폰 : 1만개)
    String query = "";
    stmt = con.createStatement();
        
    try{            
            
        query = " select count(*) COUNT from TBL_EVENT_COUPON  where COUPON_CODE = '" + buf + "'";    
        rs = stmt.executeQuery(query);
 
        //값이 있다면 다시검색
        rs.next();
        int count = rs.getInt( "COUNT" );
        
        if( count == 0 ) {
    
            //값이 없다면 DB에 저장    
            try{
            
                query = " insert into TBL_EVENT_COUPON1 ( COUPON_CODE, GUBUN ) values  ( '" + buf + "', '2' )" ;    
                stmt.executeQuery(query);
 
            }catch(SQLException e){
 
                out.print(e.toString());
            
            }
        
        }
        
    }catch(SQLException e){}
 
}
 
%>
 
<%@ include file="../inc/dbconn_end.jsp" %>