資源簡介
這個是使用java語言 poi導入excel到數據庫中,同時使用了xml對excel的每個單元格數據進行了非空驗證。經測試,導入數據庫成功。
代碼片段和文件信息
package?com.karen.database;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?com.karen.test2.User;
public?class?Dao?{
private?DBUtil?dbutil?=?new?DBUtil();
/**
?*?保存一個用戶
?*/
@SuppressWarnings(“finally“)
public?synchronized?boolean?saveUser(User?user)?{
Connection?conn?=?null;
PreparedStatement?ps?=?null;
boolean?isInserted?=?false;
conn?=?dbutil.getConn();
try?{
ps?=?conn.prepareStatement(“insert?into?user?values(???????)“);
ps.setString(1?user.getStatus());
ps.setString(2?user.getPort()+““);
ps.setString(3?user.getIp());
ps.setString(4?user.getPassword());
ps.setString(5user.getUsername());
ps.setString(6?user.getNo());
ps.setB
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-07-19?18:36??xm
?????文件?????????644??2012-07-19?10:13??xm
?????文件?????????384??2012-07-11?14:25??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????文件?????????629??2012-07-11?14:25??xm
?????目錄???????????0??2012-07-19?18:38??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????目錄???????????0??2012-07-19?18:38??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????文件????????2096??2012-07-19?13:31??xm
?????文件????????1247??2012-07-19?15:11??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????文件????????2603??2012-07-19?18:25??xm
?????文件?????????765??2012-07-19?10:13??xm
?????文件???????11506??2012-07-19?15:51??xm
?????文件????????5890??2012-07-19?11:22??xm
?????文件????????1773??2012-07-19?10:44??xm
?????文件???????17408??2012-07-19?15:08??xm
?????文件????????1115??2012-07-19?13:16??xm
?????目錄???????????0??2012-07-19?18:37??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????目錄???????????0??2012-07-19?18:38??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????文件????????1395??2012-07-19?13:31??xm
?????文件?????????705??2012-07-19?15:11??xm
?????目錄???????????0??2012-07-19?18:36??xm
?????文件????????3436??2012-07-19?18:25??xm
?????文件?????????504??2012-07-19?09:32??xm
?????文件???????10721??2012-07-19?15:51??xm
?????文件????????7186??2012-07-19?11:22??xm
?????文件????????1171??2012-07-19?10:44??xm
............此處省略2個文件信息
- 上一篇:jsp+servlet批量刪除
- 下一篇:安卓鍵值測試軟件--KeyTest.apk
評論
共有 條評論