这篇文章主要介绍“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";} @Overridepublic Object getModel() {// TODO Auto-generated method stubif (admin == null) {admin = new admin();}return admin;}}
抽奖控制层一二三等奖设置
public class choujiangAction implements ModelDriven {private luck_dog luck_dog = null; @Overridepublic Object getModel() {// TODO Auto-generated method stubif (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 exceptione.printStackTrace();} finally {dbManager.closeConnection(); } } }
抢答控制层
public class choujiangAction implements ModelDriven {private luck_dog luck_dog = null; @Overridepublic Object getModel() {// TODO Auto-generated method stubif (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 exceptione.printStackTrace();} finally {dbManager.closeConnection(); } } }
到此,关于“Java晚会抽奖系统如何实现”的学习就结束了,希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习,快去试试吧!若想继续学习更多相关知识,请继续关注编程网网站,小编会继续努力为大家带来更多实用的文章!