基于javaweb+mysql的jsp+servlet晚会抽奖系统(java+jdbc+servlet+ajax+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet晚会抽奖系统(java+jdbc+servlet+ajax+mysql)
一、项目运行 环境配置：
Jdk1.8 + Tomcat8.5 + mysql + Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）
项目技术：
Jdbc+ Servlert + html+ css + JavaScript + JQuery + Ajax +等等
public class qiangda implements Serializable{
private int qiangda_id;
private int group_id;
private String ip;
private Long qiangda_time;
public int getQiangda_id() {
return qiangda_id;
}
public void setQiangda_id(int qiangda_id) {
this.qiangda_id = qiangda_id;
}
public int getGroup_id() {
return group_id;
}
public void setGroup_id(int group_id) {
this.group_id = group_id;
}
public String getIp() {
return ip;
}
public void setIp(String ip) {
this.ip = ip;
}
public Long getQiangda_time() {
return qiangda_time;
}
public void setQiangda_time(Long qiangda_time) {
this.qiangda_time = qiangda_time;
}
}
int result[] = new vder().getRandomFromArray(a, 36);
for (int i = 0; i < result.length; i++) {
System.out.println(result[i]);
}
int huodong_id = 0;
int group_id = 0;
for (int i = 1; i <= result.length; i++) {
if (i <= 12) {// 第一次活动
huodong_id = 1;
if (i <= 3) {
group_id = 1;
} else if (i <= 6) {
group_id = 2;
} else if (i <= 9) {
group_id = 3;
} else {
group_id = 4;
}
} else if (i <= 24) {// 第二次活动
huodong_id = 2;
if (i <= 15) {
group_id = 1;
} else if (i <= 18) {
group_id = 2;
} else if (i <= 21) {
group_id = 3;
} else {
group_id = 4;
}
} else if (i <= 36) {// 第三次活动
huodong_id = 3;
if (i <= 27) {
group_id = 1;
} else if (i <= 30) {
group_id = 2;
} else if (i <= 33) {
group_id = 3;
} else {
group_id = 4;
String sqlString = "delete from lucky_dog";
DBManager dbManager = new DBManager();
try {
if (dbManager.deleteSQL(sqlString)) {
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 delete_fenzu() {
String sqlString = "delete from huodong";
DBManager dbManager = new DBManager();
try {
if (dbManager.deleteSQL(sqlString)) {
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 fenzu_view() {
int huodong_id = Integer.valueOf(ServletActionContext.getRequest()
.getParameter("huodong_id"));
System.out.println(huodong_id);
String sql = "select * from huodong where huodong_id=" + huodong_id;
DBManager dbManager = new DBManager();
ResultSet resultSet = dbManager.executeQuery(sql);
List<huodong> huodongList = new ArrayList<>();
huodong huodong = null;
try {
while (resultSet.next()) {
huodong = new huodong();
huodong.setGroup_id(resultSet.getInt("group_id"));
huodong.setHuodong_id(resultSet.getInt("huodong_id"));
huodong.setId(resultSet.getInt("id"));
huodong.setNum(resultSet.getInt("num"));
huodongList.add(huodong);
}
JSONArray jsonArray = JSONArray.fromObject(huodongList);
System.out.println(jsonArray);
}
public static void main(String[] args) {
// TODO Auto-generated method stub
qiangda qiangda = new qiangda ();
qiangda.setGroup_id(1);
qiangda.setIp("127.0.0.1");
qiangda.setQiangda_id(12);
qiangda.setQiangda_time((Long.getLong("1245792323546")));
JSONArray jsonArray = JSONArray.fromObject(qiangda);
System.out.println(jsonArray);
}
}
public class huodongAction {
public void delete_choujiang() {
String sqlString = "delete from lucky_dog";
DBManager dbManager = new DBManager();
try {
if (dbManager.deleteSQL(sqlString)) {
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 delete_fenzu() {
String sqlString = "delete from huodong";
DBManager dbManager = new DBManager();
try {
if (dbManager.deleteSQL(sqlString)) {
String s = "{\"name\":\"提示\",\"age\":\"已删除全部分组数据，请重新分组！！！\"}";
ServletActionContext.getResponse()
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, String parameter3, String parameter4) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.setString(3, parameter3);
prst.setString(4, parameter4);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, int parameter2, String parameter3, String parameter4) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setInt(2, parameter2);
prst.setString(3, parameter3);
prst.setString(4, parameter4);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, int parameter3, String parameter4, String parameter5) {
try {
public class qiangda_group implements Serializable{
private int group_id;
private Date create_time;
private int started;
private int is_end;
public int getStarted() {
return started;
}
public void setStarted(int started) {
this.started = started;
}
public int getIs_end() {
return is_end;
}
public void setIs_end(int is_end) {
this.is_end = is_end;
}
public int getGroup_id() {
return group_id;
}
public void setGroup_id(int group_id) {
this.group_id = group_id;
}
public Date getCreate_time() {
return create_time;
}
public void setCreate_time(Date create_time) {
this.create_time = create_time;
}
}
public class huodong {
ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
ServletActionContext.getResponse().getWriter().print(jsonArray);
/*
[
{"qiangda_id":15,"group_id":56,"qiangda_time":1386253774144,"ip":"0:0:0:0:0:0:0:1"}
,
{"qiangda_id":16,"group_id":56,"qiangda_time":1386253977924,"ip":"192.168.43.176"}
,
{"qiangda_id":17,"group_id":56,"qiangda_time":1386253988012,"ip":"192.168.24.70"}
]
*
* {\"name\":\"提示\",\"age\":\"已提交抢答申请，请静候抢答结果！！！\"}
* */
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
dbManager.closeConnection();
}
}
public static void main(String[] args) {
// TODO Auto-generated method stub
qiangda qiangda = new qiangda ();
qiangda.setGroup_id(1);
qiangda.setIp("127.0.0.1");
qiangda.setQiangda_id(12);
qiangda.setQiangda_time((Long.getLong("1245792323546")));
JSONArray jsonArray = JSONArray.fromObject(qiangda);
System.out.println(jsonArray);
}
}
ServletActionContext.getResponse().setCharacterEncoding("UTF-8");
ServletActionContext.getResponse().getWriter().print(s);
} catch (Exception e) {
// TODO: handle exception
}
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;
public boolean executeUpdate(String sql, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.setString(3, parameter3);
prst.setString(4, parameter4);
prst.setString(5, parameter5);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public void closeConnection() {
if (prst != null) {
try {
prst.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
dbManager.closeConnection();
String sql = "update txyl_user set password = '123456' where username = 'umgsai'";
dbManager.executeUpdate(sql);
//dbManager.closeConnection();
*/
for (int i = 1000; i < 30000; i++) {
String sqlString = "insert into txyl_user (username,password) values('20091121" + i + "','12345')";
//dbManager.
dbManager.insertSQL(sqlString);
//System.out.println("insert into txyl_user(username,password) values('201091121"+i+"','12345');");
}
dbManager.closeConnection();
}
}
public class qiangdaAction {
public void start_qinagda() {
DBManager dbManager = new DBManager();
// 设置之前所有的抢答结束
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, int parameter2, String parameter3, String parameter4) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setInt(2, parameter2);
prst.setString(3, parameter3);
prst.setString(4, parameter4);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, int parameter3, String parameter4, String parameter5) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.setInt(3, parameter3);
prst.setString(4, parameter4);
prst.setString(5, parameter5);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
function callback(){
if (xmlHttp.readyState == 4 && xmlHttp.status == 200) {
var str = xmlHttp.responseText;
//alert(str);
var obj = eval("(" + str + ")");
Dialog.alert(obj.name + " : " + obj.age);
}
}
function callback1(){
if (xmlHttp.readyState == 4 && xmlHttp.status == 200) {
var str = xmlHttp.responseText;
//alert(str);
var obj = eval("(" + str + ")");
//alert(obj[0].qiangda_id);
// alert(obj.length);
var result ="";
for(var i=1;i<=obj.length;i++){
result = result + "<br/>" + "第" + i + "名:" + obj[i-1].ip ;//+ " "+ obj[i-1].qiangda_time;
// alert(obj[i].ip);
}
//alert(result);
document.getElementById("text").innerHTML = result;
//document.getElementById("result")innerHTML = result;
}
}
</script>
</head>
<body align="center">
<input type="image" src="images/kaishiqiangda.jpg" onclick="doIt()" />
<br/>
<a href="#" onclick="view_latest_result();return false;">查看最新一轮抢答结果</a>
<br/>
<span id="text"></span>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="refresh" content="0;url=qiangda.jsp">
}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 qiangda implements Serializable{
private int qiangda_id;
private int group_id;
private String ip;
private Long qiangda_time;
public int getQiangda_id() {
return qiangda_id;
}
public void setQiangda_id(int qiangda_id) {
this.qiangda_id = qiangda_id;
}
}
return true;
}
public void closeConnection() {
if (prst != null) {
try {
prst.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
DBManager dbManager = new DBManager();
/* ResultSet rs=dbManager.executeQuery("Select * from txyl_user where username = ? and password = ?", "umgsai","123456");
try {
if(rs.next()){
System.out.println(rs.getString("password"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
dbManager.closeConnection();
String sql = "update txyl_user set password = '123456' where username = 'umgsai'";
dbManager.executeUpdate(sql);
//dbManager.closeConnection();
*/
for (int i = 1000; i < 30000; i++) {
String sqlString = "insert into txyl_user (username,password) values('20091121" + i + "','12345')";
//dbManager.
dbManager.insertSQL(sqlString);
//System.out.println("insert into txyl_user(username,password) values('201091121"+i+"','12345');");
}
dbManager.closeConnection();
}
}
prst = getConnnection().prepareStatement(sql);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, String parameter3) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.setString(3, parameter3);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, int parameter3) {
try {
prst = getConnnection().prepareStatement(sql);
}
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);
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, int parameter3, String parameter4, String parameter5) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.setInt(3, parameter3);
prst.setString(4, parameter4);
prst.setString(5, parameter5);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5) {
try {
prst = getConnnection().prepareStatement(sql);
prst.setString(1, parameter1);
prst.setString(2, parameter2);
prst.setString(3, parameter3);
prst.setString(4, parameter4);
prst.setString(5, parameter5);
prst.execute();
} catch (SQLException e) {
e.printStackTrace();
return false;
}
return true;
}
public boolean executeUpdate(String sql, String parameter1) {
try {
return group_id;
}
public void setGroup_id(int group_id) {
this.group_id = group_id;
}
public Date getCreate_time() {
return create_time;
}
public void setCreate_time(Date create_time) {
this.create_time = create_time;
}
}
public class huodong {
private int id;
private int huodong_id;
private int group_id;
private int num;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getHuodong_id() {
return huodong_id;
}
public void setHuodong_id(int huodong_id) {
this.huodong_id = huodong_id;
}
public int getGroup_id() {
return group_id;
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
