| |
 | <script src="http://online4.265.com/cn/lx/17379_663.php" type="text/javascript"></script> <script src="http://online4.265.com/cn/12/9843_11553.php" type="text/javascript"></script>   | 收藏本页
联系我们
广告合作 |
|
| |
| 首页 | |
|
| |
| src="http://js4.all4ad.net/dell/dell_760x90.asp?id=236" frameborder="0" width="760" scrolling="no" height="90"> |
Excel导入数据库工具包 |
|---|
| | http://Tech.acnow.net 2005-7-24 21:26:00 JR | | | 设计目的
使用该工具包，能够将MS Excel表格数据导入到具有相应结构的关系型数据库表格。通过扩展接口能对Excel表格的每一列或行的数据进行操作，剔除坏数据，修复或者替换特定单元的数据，从而实现了Excel数据自由导入具有外键关联或引用的表格。该工具包在导入数据的同时还能生成结构简单的Xml数据文件。
类结构
使用说明
扩展接口com.uncnet.dbexcel.Flopper，实现相应的方法
方法：String conversionOp(
Connection connection,
String arg,
int index,
Document doc,
Element table,
Element row)
throws Exception;
描述：对Excel列的单元进行数据转换并操作数据库表格。
参数：Connection connection,数据库连接；
String arg,Excel列单元的数据；
int index,Excel表格列序号，从1开始；
Document doc,UNC Xml的Document元素；
Element table,UNC Xml的元素；
Element row,UNC Xml的元素。
返回：经过从Excel Xml到UNC Xml转换的数据。
代码示例：
/**
* @see com.uncnet.dbexcel.Flopper#conversionOp(Connection, String, int, Document, Element, Element)
*/
public String conversionOp(
Connection connection,
String arg,
int index,
Document doc,
Element table,
Element row) {
String text = null;
if (arg == null)
arg = "";
try {
if (connection == null)
return "No Connection";
stmt = connection.createStatement();
if (col_num++ % COLUMNS == 0)
ps_in = new String[COLUMNS + 1];
本新闻共
6页,当前在第
1页
1
2
3
4
5
6
|
上一篇：DBTaglib的使用 下一篇：使用高效的日志工具—Log4J
| 【 <script type="text/javascript">
</script> 发送给好友】 【论坛】 【 <script type="text/javascript">
</script> 添加到收藏夹】 【大 中 小】 【打印】 【关闭】 |
| src="http://js4.all4ad.net/dell/dell_468x60.asp?id=236" frameborder="0" width="468" scrolling="no" height="60">
|
| |
 | 最新文章 | |
|
| | 推荐文章 | |
|
|
<script src="http://tech.acnow.net/Click.asp?NewsID=0652001285959307" type="text/javascript"></script> 0
<script type="text/javascript"> document.getElementById('AddFav').style.pixelTop = document.body.clientHeight-86; document.getElementById('AddFav').style.pixelLeft = document.body.clientWidth-86; </script>
<script type="text/javascript"> var arrBaiduCproConfig=new Array(); arrBaiduCproConfig['uid'] = 121090; arrBaiduCproConfig['n'] = '1239435_3065_cpr'; arrBaiduCproConfig['tm'] = '20'; arrBaiduCproConfig['cm'] = '68'; arrBaiduCproConfig['um'] = '34'; arrBaiduCproConfig['w'] = '760'; arrBaiduCproConfig['h'] = '100'; arrBaiduCproConfig['wn'] = '4'; arrBaiduCproConfig['hn'] = '1'; arrBaiduCproConfig['ta'] = 'right'; arrBaiduCproConfig['tl'] = 'bottom'; arrBaiduCproConfig['bu'] = '0'; arrBaiduCproConfig['bd'] = '#21aade'; arrBaiduCproConfig['bg'] = '#ffffff'; arrBaiduCproConfig['tt'] = '#0000ff'; arrBaiduCproConfig['ct'] = '#000000'; arrBaiduCproConfig['url'] = '#666666'; arrBaiduCproConfig['bdl'] = '#21aade'; arrBaiduCproConfig['rad'] = '0'; </script> <script src="http://cpro.baidu.com/cpro/ui/ui.js" type="text/javascript"> </script> <script type="text/javascript">
</script> marginwidth="0" marginheight="0" src="http://cpro.baidu.com/cpro/ui/uijs.php?&uid=121090&n=1239435_3065_cpr&tm=20&cm=68&um=34&rsi0=760&rsi1=100&wn=4&hn=1&rssl0=right&rssl1=bottom&rsi2=0&rss0=%2321aade&rss1=%23ffffff&rss2=%230000ff&rss3=%23000000&rss4=%23666666&rss5=%2321aade&rad=0&word=http%3A%2F%2Ftech.acnow.net%2FHtml%2FProgram%2FJAVA%2F3lib%2F2005-7%2F24%2F012859949.shtml " frameborder="0" width="760" scrolling="no" height="100" allowtransparency="allowtransparency">
Copyright ©2002 - 2006
AcNow.Net，All Rights Reserved
<script language="javascript" src="http://js.users.51.la/392199.js" type="text/javascript"></script>
<script type="text/javascript">var a392199tf="51la";var a392199pu="";var a392199pf="51la";var a392199su=window.location;var a392199sf=document.referrer;var a392199of="";var a392199op="";var a392199ops=1;var a392199ot=1;var a392199d=new Date();var a392199color="";if (navigator.appName=="Netscape"){a392199color=screen.pixelDepth;} else {a392199color=screen.colorDepth;}</script> <script type="text/javascript">a392199tf=top.document.referrer;</script> <script type="text/javascript">a392199pu =window.parent.location;</script> <script type="text/javascript">a392199pf=window.parent.document.referrer;</script> <script type="text/javascript">a392199ops=document.cookie.match(new RegExp("(^| )AJSTAT_ok_pages=([^;]*)(;|$)"));a392199ops=(a392199ops==null)?1: (parseInt(unescape((a392199ops)[2]))+1);var a392199oe =new Date();a392199oe.setTime(a392199oe.getTime()+60*60*1000);document.cookie="AJSTAT_ok_pages="+a392199ops+ ";expires="+a392199oe.toGMTString();a392199ot=document.cookie.match(new RegExp("(^| )AJSTAT_ok_times=([^;]*)(;|$)"));if(a392199ot==null){a392199ot=1;}else{a392199ot=parseInt(unescape((a392199ot)[2])); a392199ot=(a392199ops==1)?(a392199ot+1):(a392199ot);}a392199oe.setTime(a392199oe.getTime()+365*24*60*60*1000);document.cookie="AJSTAT_ok_times="+a392199ot+";expires="+a392199oe.toGMTString();</script> <script type="text/javascript">a392199of=a392199sf;if(a392199pf!=="51la"){a392199of=a392199pf;}if(a392199tf!=="51la"){a392199of=a392199tf;}a392199op=a392199pu;try{lainframe}catch(e){a392199op=a392199su;}document.write('
');</script>
1990
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
