这篇文章主要介绍“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进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
