📄 insert_exe.jsp
字号:
<%/*
用途:上载教师excel报表
程序员:guoyehong
完成时间:2004-8-25 11:22
修改情况：
修改时间： 修改原因： 修改人：
*/ %>
<%@ page contentType="text/html;charset=gb2312" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="批量添加教师信息";
String PrivME="00205";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>
<%@page import="java.io.*,java.sql.*"%>
<%@page import="java.text.*"%>
<%@page import="java.util.*"%>
<%//@page import="xlrd.*"%>
<%@page import="jxl.*"%>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>
<html>
<body>
<%
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 i,j,ln;
int lnall=0;
int lnx;
int countorder=0;
int del=0;
ln=0;
Cell cell,cellp,cells;
String cell_value,teacher_id,stu_id,sql,teach_level,sqlstr,password,cellp_value;
cell_value = "";
cellp_value="";
int af;
for (i=2 ;i<Rows ;i++)
{
lnx=0;
cells=sheet.getCell(0,i);
teacher_id=(cells.getContents()).trim();
cellp=sheet.getCell(13,i);
cellp_value=cellp.getContents();
if (cellp_value!="")
{
teach_level=cellp_value.trim();
}
else{
teach_level=cellp_value;
}
password=teacher_id;
if ((!teach_level.equals(""))||(teach_level!=null)||(!teach_level.equals("null")))
{
sqlstr="insert into lrn_teacher_info(password,id,name,email,phone,address,zip_code,work_place,position,title,gender,teach_time,work_kind,note,teach_level) values ('"+password+"'";
}else{
Columns=Columns-1;
sqlstr="insert into lrn_teacher_info(password,id,name,email,phone,address,zip_code,work_place,position,title,gender,teach_time,work_kind,note) values ('"+password+"'";
}
for(j=0;j<Columns;j++)
{
cell=sheet.getCell(j,i);
cell_value=cell.getContents();
if(cell_value!="")
{
cell_value=(cell.getContents()).trim();
sqlstr=sqlstr+",'"+cell_value+"'";
}
else
{
sqlstr=sqlstr+",''";
}
}
sqlstr=sqlstr+")";
//out.print(sqlstr);
sql="select id from lrn_teacher_info where id='"+teacher_id+"'";
countorder=work.countselect(sql);
//out.print(sql);
if(countorder>0)
{
out.print("教师"+teacher_id+"编号有冲突;教师没有添加成功！<br>");
//out.print(teacher_id);
}
else
{
if(work.executeUpdate(sqlstr)==1)
{
ln++;
}
else
{
out.print("第"+i+"行数据插入失败");
}
}
out.print("<br>");
}
out.print("共"+ln+"条数据插入成功");
out.print("<center><a href='teacher_main.jsp'>[返回]</a>");
}
catch(Exception e){
%>
<script language=javascript>
alert("你将上载的文件没找到！<%=scr%>");
history.back();
</script>
<%
}
finally
{
work.close(null);
}
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -