一、项目运行
环境配置:
Jdk1.8 + Tomcat8.5 + mysql + Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)
项目技术:
Jdbc+ Servlert + html+ css + JavaScript + JQuery + Ajax +等等
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
// 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 qiangdaAction {
public void start_qinagda() {
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 + ")";
}
管理员登陆控制层:
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();
System.out.println(qiangda_group);
// 插入新纪录之前要查询是否已经抢答过了
String sql = "select * from qiangda where ip = '" + ip
+ "' and group_id =" + qiangda_group.getGroup_id();
resultSet = dbManager.executeQuery(sql);
if (resultSet.next()) {
System.out.println("本轮已经抢答过了!!!");
String s = "{\"name\":\"提示\",\"age\":\"本轮已经抢答过了!!!\"}";
ServletActionContext.getResponse().setCharacterEncoding(
"UTF-8");
ServletActionContext.getResponse().getWriter().print(s);
} else {
sql = "insert into qiangda (group_id,ip,qiangda_time)values ("
+ "' and group_id =" + qiangda_group.getGroup_id();
resultSet = dbManager.executeQuery(sql);
if (resultSet.next()) {
System.out.println("本轮已经抢答过了!!!");
String s = "{\"name\":\"提示\",\"age\":\"本轮已经抢答过了!!!\"}";
ServletActionContext.getResponse().setCharacterEncoding(
"UTF-8");
ServletActionContext.getResponse().getWriter().print(s);
} else {
sql = "insert into qiangda (group_id,ip,qiangda_time)values ("
+ qiangda_group.getGroup_id()
+ ",'"
+ ip
+ "','"
System.out.println("抢答成功!!!");
String s = "{\"name\":\"提示\",\"age\":\"已提交抢答申请,请静候抢答结果!!!\"}";
ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
ServletActionContext.getResponse().getWriter().print(s);
}
}
} catch (Exception e) {
// TODO: handle exception
} finally {
dbManager.closeConnection();
}
}
public void view_latest_result() {
public class qiangdaAction {
public void start_qinagda() {
DBManager dbManager = new DBManager();
// 设置之前所有的抢答结束
String sql = "update qiangda_group set is_end = 1 where 1=1";
System.out.println(dbManager.executeUpdate(sql));
sql = "insert into qiangda_group (create_time,started,is_end)values('"
+ DateUtil.GetTime() + "',1,0)";
//
System.out.println(sql);
dbManager.insertSQL(sql);
// System.out.println(dbManager.insertSQL(sql));
// long a = Calendar.getInstance().getTimeInMillis();
// System.err.println(a);
try {
String s = "{\"name\":\"提示\",\"age\":\"新一轮抢答开始!!!\"}";
ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
ServletActionContext.getResponse().getWriter().print(s);
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);
}
String sqlString = "select * from qiangda_group where is_end =0";
System.err.println(sqlString);
String ip = ServletActionContext.getRequest().getParameter("ip");
System.out.println(ip);
ResultSet resultSet = dbManager.executeQuery(sqlString);
qiangda_group qiangda_group = null;
try {
if (resultSet.next()) {
qiangda_group = new qiangda_group();
qiangda_group.setCreate_time(resultSet.getDate("create_time"));
qiangda_group.setGroup_id(resultSet.getInt("group_id"));
qiangda_group.setIs_end(resultSet.getInt("is_end"));
qiangda_group.setStarted(resultSet.getInt("started"));
System.out.println(qiangda_group);
// 插入新纪录之前要查询是否已经抢答过了
String sql = "select * from qiangda where ip = '" + ip
+ "' and group_id =" + qiangda_group.getGroup_id();
resultSet = dbManager.executeQuery(sql);
if (resultSet.next()) {
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";
}
sqlString = "select * from qiangda where group_id = "+max_id+" order by qiangda_time";
System.out.println(sqlString);
resultSet = dbManager.executeQuery(sqlString);
List<qiangda> qiangdaList = new ArrayList<qiangda>();
qiangda qiangda = null;
while (resultSet.next()) {
qiangda = new qiangda();
qiangda.setGroup_id(resultSet.getInt("group_id"));
qiangda.setIp(resultSet.getString("ip"));
qiangda.setQiangda_id(resultSet.getInt("qiangda_id"));
qiangda.setQiangda_time( Long.parseLong(resultSet.getString("qiangda_time")));
qiangdaList.add(qiangda);
}
JSONArray jsonArray = JSONArray.fromObject(qiangdaList);
ActionContext.getContext().getSession().put("qiangdaList", qiangdaList);
System.out.println(jsonArray);
//String s = "{\"name\":\"提示\",\"age\":\"已提交抢答申请,请静候抢答结果!!!\"}";
ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
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");