Java晚会抽奖系统如何实现(java,开发技术)

一、项目运行

环境配置：

Jdk1.8 + Tomcat8.5 + mysql + Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）

项目技术：

Jdbc+ Servlert + html+ css + JavaScript + JQuery + Ajax +等等

二、效果图

三、核心代码

管理员登陆控制层

publicclassadminActionimplementsModelDriven{ adminadmin=null; publicStringlogin(){ DBManagerdbManager=newDBManager(); Stringsql="select*fromadminwhereusername='"+admin.getUsername()+"'andpassword='"+admin.getPassword()+"'"; ResultSetresultSet=dbManager.executeQuery(sql); try{ if(resultSet.next()){ System.out.println("登陆成功"); ActionContext.getContext().getSession().put("admin",admin); return"success"; }else{ ActionContext.getContext().getSession().put("message","登录失败"); return"failed"; } }catch(Exceptione){ e.printStackTrace(); ActionContext.getContext().getSession().put("message","登录失败"); //TODO:handleexception }finally{ dbManager.closeConnection(); } return"failed"; } @Override publicObjectgetModel(){ //TODOAuto-generatedmethodstub if(admin==null){ admin=newadmin(); } returnadmin; }}

抽奖控制层一二三等奖设置

publicclasschoujiangActionimplementsModelDriven{ privateluck_dogluck_dog=null; @Override publicObjectgetModel(){ //TODOAuto-generatedmethodstub if(luck_dog==null){ luck_dog=newluck_dog(); } returnluck_dog; } publicvoidchoujiang(){ System.out.println(luck_dog.getLuck_num()); DBManagerdbManager=newDBManager(); Stringsql="select*fromlucky_dogwhereluck_num=" +luck_dog.getLuck_num(); ResultSetresultSet=dbManager.executeQuery(sql); try{ if(resultSet.next()){ System.out.println("这个号码已经中过奖！！！"); Strings="{\"name\":\"提示\",\"age\":\"alreadyexisterror\"}"; ServletActionContext.getResponse() .setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; }else{ inttotal=0; intluck_group=0; sql="selectcount(*)astotalCountfromlucky_dog"; resultSet=dbManager.executeQuery(sql); if(resultSet.next()){ total=resultSet.getInt("totalCount"); }//得到抽奖表中的记录数 if(total<8){ luck_group=3;//三等奖8个 }elseif(total<13){ luck_group=2;//二等奖5个 }elseif(total<16){ luck_group=1;//一等奖3个 }else{ System.out.println("抽奖总数已满！！！"); Strings="{\"name\":\"提示\",\"age\":\"totaloverflowerror\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; } sql="insertintolucky_dog(luck_num,luck_group)values(" +luck_dog.getLuck_num()+","+luck_group+")"; booleanresult=dbManager.insertSQL(sql); if(result){ Strings="{\"name\":\"提示\",\"age\":\"success\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); System.out.println("抽奖数据已经写入数据库"); }else{ System.out.println("抽奖数据写入失败"); } } }catch(Exceptione){ //TODO:handleexception }finally{ dbManager.closeConnection(); } } publicvoidview_result(){ System.out.println("view_resultview_resultview_result"); DBManagerdbManager=newDBManager(); Stringsql="select*fromlucky_dog"; luck_dogluck_dog=null; ResultSetresultSet=dbManager.executeQuery(sql); List<luck_dog>luck_dogList=newArrayList<luck_dog>(); try{ while(resultSet.next()){ luck_dog=newluck_dog(); luck_dog.setId(resultSet.getInt("id")); luck_dog.setLuck_group(resultSet.getInt("luck_group")); luck_dog.setLuck_num(resultSet.getInt("luck_num")); luck_dogList.add(luck_dog); } JSONArrayjsonArray=JSONArray.fromObject(luck_dogList); System.out.println(jsonArray); //Strings="{\"name\":\"提示\",\"age\":\"已提交抢答申请，请静候抢答结果！！！\"}"; ServletActionContext.getResponse().setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(jsonArray); }catch(Exceptione){ //TODO:handleexception e.printStackTrace(); }finally{ dbManager.closeConnection(); } }}

抢答控制层

publicclasschoujiangActionimplementsModelDriven{ privateluck_dogluck_dog=null; @Override publicObjectgetModel(){ //TODOAuto-generatedmethodstub if(luck_dog==null){ luck_dog=newluck_dog(); } returnluck_dog; } publicvoidchoujiang(){ System.out.println(luck_dog.getLuck_num()); DBManagerdbManager=newDBManager(); Stringsql="select*fromlucky_dogwhereluck_num=" +luck_dog.getLuck_num(); ResultSetresultSet=dbManager.executeQuery(sql); try{ if(resultSet.next()){ System.out.println("这个号码已经中过奖！！！"); Strings="{\"name\":\"提示\",\"age\":\"alreadyexisterror\"}"; ServletActionContext.getResponse() .setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; }else{ inttotal=0; intluck_group=0; sql="selectcount(*)astotalCountfromlucky_dog"; resultSet=dbManager.executeQuery(sql); if(resultSet.next()){ total=resultSet.getInt("totalCount"); }//得到抽奖表中的记录数 if(total<8){ luck_group=3;//三等奖8个 }elseif(total<13){ luck_group=2;//二等奖5个 }elseif(total<16){ luck_group=1;//一等奖3个 }else{ System.out.println("抽奖总数已满！！！"); Strings="{\"name\":\"提示\",\"age\":\"totaloverflowerror\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; } sql="insertintolucky_dog(luck_num,luck_group)values(" +luck_dog.getLuck_num()+","+luck_group+")"; booleanresult=dbManager.insertSQL(sql); if(result){ Strings="{\"name\":\"提示\",\"age\":\"success\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); System.out.println("抽奖数据已经写入数据库"); }else{ System.out.println("抽奖数据写入失败"); } } }catch(Exceptione){ //TODO:handleexception }finally{ dbManager.closeConnection(); } } publicvoidview_result(){ System.out.println("view_resultview_resultview_result"); DBManagerdbManager=newDBManager(); Stringsql="select*fromlucky_dog"; luck_dogluck_dog=null; ResultSetresultSet=dbManager.executeQuery(sql); List<luck_dog>luck_dogList=newArrayList<luck_dog>(); try{ while(resultSet.next()){ luck_dog=newluck_dog(); luck_dog.setId(resultSet.getInt("id")); luck_dog.setLuck_group(resultSet.getInt("luck_group")); luck_dog.setLuck_num(resultSet.getInt("luck_num")); luck_dogList.add(luck_dog); } JSONArrayjsonArray=JSONArray.fromObject(luck_dogList); System.out.println(jsonArray); //Strings="{\"name\":\"提示\",\"age\":\"已提交抢答申请，请静候抢答结果！！！\"}"; ServletActionContext.getResponse().setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(jsonArray); }catch(Exceptione){ //TODO:handleexception e.printStackTrace(); }finally{ dbManager.closeConnection(); } }}