package mybean;
import java.io.*;
import jxl.*;
import jxl.read.biff.BiffException;
import jxl.write.*;
import jxl.Sheet;
import java.*;
import java.io.File;
import java.sql.*;
import jxl.Cell;
import jxl.Workbook;
public class excelinput {
public static void main (String file){
boolean flag=false,boo=false;
PreparedStatement ps = null;
jxl.Workbook rwb = null;
try{
//String file1=request.getParameter("file");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=agendas";
String user="sa";
String password="sqd";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
try {
InputStream is = new FileInputStream("excel.xls");
rwb = Workbook.getWorkbook(is);
Sheet rs = rwb.getSheet(0);
int rsColumns = rs.getColumns();
int rsRows = rs.getRows();
String t1 = "", t2 = "", t3 = "", t4 = "", t5 = "", t6 = "", t7 = "";
long t0 = 0;
int i = 0;
for (i = 1; i < rsRows; i++) {
for (int j = 0; j < rsColumns; j++) {
Cell cell = rs.getCell(j, i);
if (j == 0) {
String str = cell.getContents();
if (str.equals("") || str == null){
boo = true;
break;
}else{
t0 = Long.parseLong(str);
}
}
if (j == 1) {
t1 = cell.getContents();
}
if (j == 2) {
t2 = cell.getContents();
}
if (j == 3) {
t3 = cell.getContents();
}
if (j == 4) {
t4 = cell.getContents();
}
if (j == 5) {
t5 = cell.getContents();
}
if (j == 6) {
t6 = cell.getContents();
}
if (j == 7) {
t7 = cell.getContents();
}
}
if (boo){
break;
}
ps = conn
.prepareStatement("insert into table1(gh,xm,xb,nl,sfzh,byxx,sgrq) values (?,?,?,?,?,?,?)"); ps.setLong(1, t0);
ps.setString(2, t1);
ps.setString(3, t2);
ps.setString(4, t3);
ps.setString(5, t4);
ps.setString(6, t5);
ps.setString(7, t6);
int isAdd = ps.executeUpdate();
if (isAdd > 0) {
flag = true;
}
} } catch (Exception ee) {
ee.printStackTrace();
} finally {
rwb.close();
}
}
catch(Exception e)
{e.printStackTrace();}
}
return flag;
}
import java.io.*;
import jxl.*;
import jxl.read.biff.BiffException;
import jxl.write.*;
import jxl.Sheet;
import java.*;
import java.io.File;
import java.sql.*;
import jxl.Cell;
import jxl.Workbook;
public class excelinput {
public static void main (String file){
boolean flag=false,boo=false;
PreparedStatement ps = null;
jxl.Workbook rwb = null;
try{
//String file1=request.getParameter("file");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=agendas";
String user="sa";
String password="sqd";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
try {
InputStream is = new FileInputStream("excel.xls");
rwb = Workbook.getWorkbook(is);
Sheet rs = rwb.getSheet(0);
int rsColumns = rs.getColumns();
int rsRows = rs.getRows();
String t1 = "", t2 = "", t3 = "", t4 = "", t5 = "", t6 = "", t7 = "";
long t0 = 0;
int i = 0;
for (i = 1; i < rsRows; i++) {
for (int j = 0; j < rsColumns; j++) {
Cell cell = rs.getCell(j, i);
if (j == 0) {
String str = cell.getContents();
if (str.equals("") || str == null){
boo = true;
break;
}else{
t0 = Long.parseLong(str);
}
}
if (j == 1) {
t1 = cell.getContents();
}
if (j == 2) {
t2 = cell.getContents();
}
if (j == 3) {
t3 = cell.getContents();
}
if (j == 4) {
t4 = cell.getContents();
}
if (j == 5) {
t5 = cell.getContents();
}
if (j == 6) {
t6 = cell.getContents();
}
if (j == 7) {
t7 = cell.getContents();
}
}
if (boo){
break;
}
ps = conn
.prepareStatement("insert into table1(gh,xm,xb,nl,sfzh,byxx,sgrq) values (?,?,?,?,?,?,?)"); ps.setLong(1, t0);
ps.setString(2, t1);
ps.setString(3, t2);
ps.setString(4, t3);
ps.setString(5, t4);
ps.setString(6, t5);
ps.setString(7, t6);
int isAdd = ps.executeUpdate();
if (isAdd > 0) {
flag = true;
}
} } catch (Exception ee) {
ee.printStackTrace();
} finally {
rwb.close();
}
}
catch(Exception e)
{e.printStackTrace();}
}
return flag;
}
解决方案 »
- 达人来,有数据库经验和java经验进来看下,谢谢了
- fckeditor设置上传的绝对路径?
- 使用struct action 返回页面后 css,js 失效
- TOMCAT5.5+SQL2000连接池数据源问题
- 初学者最简单的问题,到底该如何连接mysql数据库,我已经尝试了几天了,查了好多资料,可还是不行。
- 100分解惑
- 应聘中被问的一些问题,谁能帮助我?
- 恳求一个使用frame的JSP例子程序
- Struts2关于struts.xml的配置问题,我又404了,新人求大神指教,感激不尽!
- 几种输出流输出图片的大小不同
- JS-求大神给个思路,或者实现代码
- ssi框架做的小demo。在做查询的时候出了这个问题。查询了语句是我自己写的
严重: Error loading WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
----------> Parent Classloader:
org.apache.catalina.loader.StandardClassLoader@f42ad0
org.apache.struts.action.ActionServlet
java.lang.ClassNotFoundException: org.apache.struts.action.ActionServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1083)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4042)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2013-4-23 9:11:35 org.apache.catalina.core.StandardContext loadOnStartup
严重: Servlet /OurProjectForOA threw load() exception
java.lang.ClassNotFoundException: org.apache.struts.action.ActionServlet
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1083)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4042)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2013-4-23 9:11:35 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2013-4-23 9:11:36 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2013-4-23 9:11:36 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/343 config=null
2013-4-23 9:11:36 org.apache.catalina.startup.Catalina start
信息: Server startup in 45137 ms
刚学jsp半月,啥都不会呢