⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 prise_action.jsp.bak

📁 java随机抽奖
💻 BAK
字号:
🔍 
<%@ page language="java"  contentType="text/html;charset=GBK" 
    import="java.sql.*,java.io.File"
%>
<%
          String strPathFile = application.getRealPath(request.getRequestURI());
          String strDirPath = new File(application.getRealPath(request.getRequestURI())).getParent();
          System.out.println("strDirPath1="+strDirPath);
		  strDirPath = strDirPath.substring(0,strDirPath.lastIndexOf(File.separator))+File.separator;

		  System.out.println("strDirPat2h="+strDirPath);

          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
          java.sql.Connection conn = DriverManager
					.getConnection("jdbc:odbc:;"
							+ "DRIVER=Driver do Microsoft Access (*.mdb);"
							+ "UID=;" + "UserCommitSync=Yes;" + "Threads=3;"
							+ "SafeTransactions=0;" + "PageTimeout=5;"
							+ "MaxScanRows=8;" + "MaxBufferSize=2048;"
							+ "FIL=MS Access;" + "DriverId=25;"
							+ "DBQ="+strDirPath+"emp.mdb");
			// //
            Statement stmt = conn.createStatement();
			if(request.getParameter("action")!=null && request.getParameter("action").equals("pro")){
				String actSql = "UPDATE sheet1 SET status="+request.getParameter("priseID") +" WHERE empcode = '"+request.getParameter("empcode")+"'";
				System.out.println("actSql="+actSql);
				stmt.execute(actSql);
			}
            if(request.getParameter("action")!=null && request.getParameter("action").equals("Init")){
				String actSql = "UPDATE sheet1 SET status=-1";
				stmt.execute(actSql);
			}
			String sql = "select * from sheet1 WHERE status=-1";
			ResultSet rs = null;
			rs = stmt.executeQuery(sql);
%>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>
<SCRIPT LANGUAGE="JavaScript">
var arry = new Array();
<%
  while (rs.next()) {
    String empcode = rs.getString("empcode");
	String empname = rs.getString("empname");
%>
arry[arry.length]="<%=empcode%>_<%=empname%>";
<%
  }
%>

function getArry(){
	return arry;
}

function removeMember(pro_member){
	var newArry = new Array();
	for(var i = 0;i<arry.length;i++){
       if(pro_member!=arry[i]){
		   newArry[newArry.length] =arry[i];
	   }       
	}
    arry = newArry;
}

<%
  sql = "select count(*) as index from sheet1 WHERE status<>-1";
  rs = null;
  rs = stmt.executeQuery(sql);
  String index = "";
  if(rs.next()){
      index = rs.getString("index");
  }
%>
function action(pro_member,priseID){
	window.location="prise_action.jsp?action=pro&empcode="+pro_member.substring(0,pro_member.indexOf("_"))+"&priseID=<%=index%>";
}

function Init(){
	window.location="prise_action.jsp?action=Init";
}
</SCRIPT>
<BODY>
<SCRIPT LANGUAGE="JavaScript">
parent.document.all.p3.innerHTML="中奖名单:<BR>";
<%
  sql = "select * from sheet1 WHERE status<>-1 order by status";
  rs = null;
  rs = stmt.executeQuery(sql);

%>
<%
  int k = 0;
  while (rs.next()) {
    String empcode = rs.getString("empcode");
	String empname = rs.getString("empname");
	empname = empname.length()==2?empname+"&nbsp;&nbsp;":empname;
	int status = rs.getInt("status")+1;
	k++;
%>
   parent.document.all.p3.innerHTML+="(<%=status<10?"0"+status:status%>).<%=empcode%>&nbsp;<%=empname%>&nbsp;&nbsp;<%=k%4==0?"<br>":""%>";
<%
  }
%>


parent.pro_index=<%=Integer.parseInt(index)+1%>;
</SCRIPT>
<%
   rs.close();
   stmt.close();
   conn.close();
%>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -