📄 prise_action.jsp
字号:
<%@ 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+" ":empname;
int status = rs.getInt("status")+1;
k++;
%>
parent.document.all.p3.innerHTML+="(<%=status<10?"0"+status:status%>).<%=empcode%> <%=empname%> <%=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 + -