資源簡介
本人親自調(diào)測通過,可以使用
jsp 實(shí)現(xiàn)excel 數(shù)據(jù)上傳至服務(wù)器 然后上傳至數(shù)據(jù)庫
另外實(shí)現(xiàn)了 數(shù)據(jù)庫數(shù)據(jù) 導(dǎo)出至excel 功能
希望對(duì)初學(xué)者有幫助

代碼片段和文件信息
package?com.zd.bean.sql;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.sql.*;
public?class?Condb?{
????????Connection?conn?=?null;??
????????ResultSet?rs=null;???
public??Condb()
{
?try?{
?System.out.println(Config.CONNECTION_DRIVER);
?Class.forName(Config.CONNECTION_DRIVER);
?}catch?(Exception?e)?{
e.printStackTrace();
}
?
}
???????public?ResultSet?executeQuery(String?sql)
????{
???????try{
?conn?=?DriverManager.getConnection(Config.CONNECTION_URL
Config.CONNECTION_USER?Config.CONNECTION_PWD);
Statement?stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}catch(SQLException?er){
System.err.println(er.getMessage());
}
return?rs;
????}
???????
public?void?close(){
try{
if(conn!=null)
conn.close();
}catch(Exception?e){
System.out.print(e);
}try{
if(rs!=null)
rs.close();
}catch(Exception?e){
System.out.println(e);
}
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-04-06?18:44??xxgk\
?????文件?????????791??2014-03-25?16:18??xxgk\.classpath
?????文件?????????285??2014-04-06?18:36??xxgk\.myme
?????文件????????1747??2014-03-25?18:13??xxgk\.project
?????目錄???????????0??2014-04-06?18:44??xxgk\.settings\
?????文件?????????500??2014-03-25?16:14??xxgk\.settings\.jsdtscope
?????文件?????????113??2014-04-02?10:37??xxgk\.settings\org.eclipse.core.resources.prefs
?????文件?????????395??2014-03-25?16:14??xxgk\.settings\org.eclipse.jdt.core.prefs
?????文件?????????450??2014-03-25?16:14??xxgk\.settings\org.eclipse.wst.common.component
?????文件?????????252??2014-03-25?16:14??xxgk\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2014-03-25?16:14??xxgk\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-03-25?16:14??xxgk\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-04-06?18:47??xxgk\WebRoot\
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\me
?????文件??????????36??2014-03-25?16:14??xxgk\WebRoot\me
?????文件?????????903??2014-04-01?15:09??xxgk\WebRoot\MyJsp.jsp
?????文件????????1062??2014-04-01?20:05??xxgk\WebRoot\MyJsp1.jsp
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\WEB-INF\
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\WEB-INF\classes\com\zd\
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\
?????目錄???????????0??2014-04-06?18:44??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\
?????文件????????1896??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\Condb.class
?????文件????????2239??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\Condbc.class
?????文件????????1371??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\Config.class
?????文件????????1762??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\Conpro6.class
?????文件????????1617??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\DBConnection.class
?????文件????????1775??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\Deletedb.class
?????文件????????2550??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\ExcelUtil.class
?????文件????????2249??2014-04-02?22:04??xxgk\WebRoot\WEB-INF\classes\com\zd\bean\sql\JdbcBean.class
............此處省略63個(gè)文件信息
評(píng)論
共有 條評(píng)論