📄 insert_exe.jsp
字号:
<%/*
用途:上载课程excel报表
程序员:guoyehong
完成时间:
修改情况：
修改时间： 修改原因： 修改人：
*/ %>
<%@ page contentType="text/html;charset=gb2312" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="批量添加课程信息";
String PrivME="00605";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<%@ 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 major_id=request.getParameter("major_id");
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,course_id,stu_id,sql;
int af;
cell_value = "";
for (i=2 ;i<Rows ;i++)
{
lnx=0;
cells=sheet.getCell(0,i);
course_id=(cells.getContents()).trim();
String sqlstr="insert into lrn_course_info(major_id,id,course_name,credit,course_time,standard_fee,text_book,ref_book,note) values ('"+major_id+"'";
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_course_info where id='"+course_id+"'";
countorder=work.countselect(sql);
//out.print(sql);
if(countorder>0)
{
out.print("课程"+course_id+"编号有冲突;课程没有添加成功！<br>");
//out.print(course_id);
}
else
{
if(work.executeUpdate(sqlstr)==1)
{
ln++;
}
else
{
out.print("第"+i+"行数据插入失败");
}
}
out.print("<br>");
}
out.print("共"+ln+"条数据插入成功");
out.print("<center><a href='course_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 + -