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()+"http://' 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) {

// TOCEkIDDO: 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_dogList = new ArrayList();

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();

} finalCEkIDly {

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_dogList = new ArrayList();

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();

}

}

}

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。