📄 user_addbatchexe.jsp
字号:
<%
/*---------------------------------------------
功能描述:执行批量添加学生
编写时间:2003-08-20
编写人:侯雄飞
email:houxf@whaty.com
修改情况记录
修改时间： 修改内容： 修改人：
-----------------------------------------------*/
%>
<%@ page language="java" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<%@ page import="jxl.*"%>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="批量添加学生";
String PrivME="00105";
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>
<html>
<body>
<%
String major_id = request.getParameter("major_id");
String site_id = request.getParameter("site_id");
String grade_id = request.getParameter("grade_id");
String edu_type_id = request.getParameter("edu_type_id");
String sql = "";
String scr = (String) session.getValue("scr");
String T_filename = (String) session.getValue("T_filename");
try
{
Workbook w = Workbook.getWorkbook(new File(scr + T_filename));
Sheet sheet = w.getSheet(0);
int columns = sheet.getColumns();
int rows = sheet.getRows();
int count = 0;
Cell cell;
String cell_value = "";
for (int i = 2 ;i < rows ;i ++)
{
sql = "insert into lrn_user_info(id,site,major_id,grade_id,edu_type_id,reg_no,name,id_card,gender,birthday,email,zzmm,folk,hometown,address,zip_address,phone) values(to_char(s_lrn_user_info_id.nextval),'" + site_id + "','" + major_id + "','" + grade_id + "','" + edu_type_id + "'";
for(int j = 0;j < columns;j ++)
{
cell = sheet.getCell(j, i);
if(cell_value != null)
{
cell_value=(cell.getContents()).trim();
sql = sql + ",'" + cell_value + "'";
}
else
{
sql = sql + ",''";
}
}
sql = sql + ")";
//out.print(sql);
if(work.executeUpdate(sql) == 1)
{
count ++;
}
else
{
//out.print(sql);
int m=i+1;
out.print("第" + m + "行数据插入失败<br>");
}
}
out.print("共" + count + "条数据插入成功");
out.print("<center><a href='user_manage.jsp'>[返回]</a></center>");
w.close();
}
catch(Exception e){
%>
<script language=javascript>
alert("你将上载的文件没找到！<%=scr%>");
history.back();
</script>
<%
}
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -