您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
这篇文章主要介绍“Java晚会抽奖系统如何实现”,在日常操作中,相信很多人在Java晚会抽奖系统如何实现问题上存在疑惑,小编查阅了各式资料,整理出简单好用的操作方法,希望对大家解答”Java晚会抽奖系统如何实现”的疑惑有所帮助!接下来,请跟着小编一起来学习吧!
环境配置:
Jdk1.8 + Tomcat8.5 + mysql + Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)
项目技术:
Jdbc+ Servlert + html+ css + JavaScript + JQuery + Ajax +等等
public class adminAction implements ModelDriven{ admin admin = null; public String login() { DBManager dbManager = new DBManager(); String sql= "select * from admin where username = '"+admin.getUsername()+"' and password = '"+admin.getPassword()+"'"; ResultSet resultSet = 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 (Exception e) { e.printStackTrace(); ActionContext.getContext().getSession().put("message", "登录失败"); // TODO: handle exception }finally{ dbManager.closeConnection(); } return "failed"; } @Override public Object getModel() { // TODO Auto-generated method stub if (admin == null) { admin = new admin(); } return admin; } }
public class choujiangAction implements ModelDriven { private luck_dog luck_dog = null; @Override public Object getModel() { // TODO Auto-generated method stub if (luck_dog == null) { luck_dog = new luck_dog(); } return luck_dog; } public void choujiang() { System.out.println(luck_dog.getLuck_num()); DBManager dbManager = new DBManager(); String sql = "select * from lucky_dog where luck_num = " + luck_dog.getLuck_num(); ResultSet resultSet = dbManager.executeQuery(sql); try { if (resultSet.next()) { System.out.println("这个号码已经中过奖!!!"); String s = "{\"name\":\"提示\",\"age\":\"alreadyexisterror\"}"; ServletActionContext.getResponse() .setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; } else { int total = 0; int luck_group = 0; sql = "select count(*)as totalCount from lucky_dog"; resultSet = dbManager.executeQuery(sql); if (resultSet.next()) { total = resultSet.getInt("totalCount"); }// 得到抽奖表中的记录数 if (total < 8) { luck_group = 3;// 三等奖8个 } else if (total < 13) { luck_group = 2;// 二等奖5个 } else if (total < 16) { luck_group = 1;// 一等奖3个 } else { System.out.println("抽奖总数已满!!!"); String s = "{\"name\":\"提示\",\"age\":\"totaloverflowerror\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; } sql = "insert into lucky_dog (luck_num,luck_group)values(" + luck_dog.getLuck_num() + "," + luck_group + ")"; boolean result = dbManager.insertSQL(sql); if (result) { String s = "{\"name\":\"提示\",\"age\":\"success\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); System.out.println("抽奖数据已经写入数据库"); } else { System.out.println("抽奖数据写入失败"); } } } catch (Exception e) { // TODO: handle exception } finally { dbManager.closeConnection(); } } public void view_result() { System.out.println("view_resultview_resultview_result"); DBManager dbManager = new DBManager(); String sql = "select * from lucky_dog"; luck_dog luck_dog = null; ResultSet resultSet = dbManager.executeQuery(sql); List<luck_dog> luck_dogList = new ArrayList<luck_dog>(); try { while (resultSet.next()) { luck_dog = new luck_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); } JSONArray jsonArray = JSONArray.fromObject(luck_dogList); System.out.println(jsonArray); // String s = "{\"name\":\"提示\",\"age\":\"已提交抢答申请,请静候抢答结果!!!\"}"; ServletActionContext.getResponse().setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(jsonArray); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { dbManager.closeConnection(); } } }
public class choujiangAction implements ModelDriven { private luck_dog luck_dog = null; @Override public Object getModel() { // TODO Auto-generated method stub if (luck_dog == null) { luck_dog = new luck_dog(); } return luck_dog; } public void choujiang() { System.out.println(luck_dog.getLuck_num()); DBManager dbManager = new DBManager(); String sql = "select * from lucky_dog where luck_num = " + luck_dog.getLuck_num(); ResultSet resultSet = dbManager.executeQuery(sql); try { if (resultSet.next()) { System.out.println("这个号码已经中过奖!!!"); String s = "{\"name\":\"提示\",\"age\":\"alreadyexisterror\"}"; ServletActionContext.getResponse() .setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; } else { int total = 0; int luck_group = 0; sql = "select count(*)as totalCount from lucky_dog"; resultSet = dbManager.executeQuery(sql); if (resultSet.next()) { total = resultSet.getInt("totalCount"); }// 得到抽奖表中的记录数 if (total < 8) { luck_group = 3;// 三等奖8个 } else if (total < 13) { luck_group = 2;// 二等奖5个 } else if (total < 16) { luck_group = 1;// 一等奖3个 } else { System.out.println("抽奖总数已满!!!"); String s = "{\"name\":\"提示\",\"age\":\"totaloverflowerror\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); return; } sql = "insert into lucky_dog (luck_num,luck_group)values(" + luck_dog.getLuck_num() + "," + luck_group + ")"; boolean result = dbManager.insertSQL(sql); if (result) { String s = "{\"name\":\"提示\",\"age\":\"success\"}"; ServletActionContext.getResponse().setCharacterEncoding( "UTF-8"); ServletActionContext.getResponse().getWriter().print(s); System.out.println("抽奖数据已经写入数据库"); } else { System.out.println("抽奖数据写入失败"); } } } catch (Exception e) { // TODO: handle exception } finally { dbManager.closeConnection(); } } public void view_result() { System.out.println("view_resultview_resultview_result"); DBManager dbManager = new DBManager(); String sql = "select * from lucky_dog"; luck_dog luck_dog = null; ResultSet resultSet = dbManager.executeQuery(sql); List<luck_dog> luck_dogList = new ArrayList<luck_dog>(); try { while (resultSet.next()) { luck_dog = new luck_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); } JSONArray jsonArray = JSONArray.fromObject(luck_dogList); System.out.println(jsonArray); // String s = "{\"name\":\"提示\",\"age\":\"已提交抢答申请,请静候抢答结果!!!\"}"; ServletActionContext.getResponse().setCharacterEncoding("UTF-8"); ServletActionContext.getResponse().getWriter().print(jsonArray); } catch (Exception e) { // TODO: handle exception e.printStackTrace(); } finally { dbManager.closeConnection(); } } }
到此,关于“Java晚会抽奖系统如何实现”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注亿速云网站,小编会继续努力为大家带来更多实用的文章!
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。