資源簡介
java+jsp+servlet+mvc寫的簡易的倉庫管理系統(tǒng),大神勿看,eclipse編寫,服務器是tomcat7.0,jdk是1.7

代碼片段和文件信息
package?com.hzyc.jdbc;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.HashMap;
public?class?JDBC?{
private?Connection?conn?=?null;
private?Statement?stmt?=?null;
private?ResultSet?rs?=?null;
//連接
public?void?getConnection(){
try?{
//加載驅動
Class.forName(“com.mysql.jdbc.Driver“);
//獲取連接
conn?=?DriverManager.getConnection(“jdbc:mysql://localhost:3308/warehouse“?“root“?“mysql“);
stmt?=?conn.createStatement();
System.out.println(“連接成功“);
}?catch?(Exception?e)?{
//?TODO:?handle?exception
e.printStackTrace();
//System.out.println(“連接失敗“);
}
}
//更新數據庫
public?int?update(String?sql){
int?result?=?-1;//0.1.2.3.44.55.56.....
try?{
//連接方法
getConnection();
result?=?stmt.executeUpdate(sql);
//break:終止整個循環(huán)。
//return:返回,終止整個方法體。
return?result;
}?catch?(Exception?e)?{
e.printStackTrace();
}?finally{
close();
}
return?result;
}
//查詢數據庫
public?ArrayList>?query(String?sql){
ArrayList>?rsList?=?new?ArrayList>();
try?{
getConnection();
rs?=?stmt.executeQuery(sql);
//得到結果集結構對象(為了得到字段名)
ResultSetmetaData?rsmd?=?rs.getmetaData();
while(rs.next()){
HashMap?rsMap?=?new?HashMap();
//每一條記錄只需要一個map即可,map內有5個鍵值對
for(int?i?=?1;i?<=?rsmd.getColumnCount();i++){
//System.out.println(rsmd.getColumnName(i));
String?columnName?=?rsmd.getColumnName(i);
//根據字段名取得字段值
String?columnValue?=?rs.getString(columnName);
//將遍歷得到的鍵值對存儲到map中
rsMap.put(columnName?columnValue);
}
//當五對鍵值對都存儲到map中之后,存儲到list中。
rsList.add(rsMap);
}
return?rsList;
}?catch?(Exception?e)?{
e.printStackTrace();
}?finally{
close();
}
return?null;
}
//釋放資源
public?void?close(){
try?{
if(rs?!=?null){
rs.close();
}
if(stmt?!=?null){
stmt.close();
}
if(conn?!=?null){
conn.close();
}
System.out.println(“資源關閉“);
}?catch?(Exception?e)?{
e.printStackTrace();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-20?15:15??design\
?????文件????????1155??2018-05-18?01:28??design\.classpath
?????文件????????1039??2018-05-17?20:03??design\.project
?????目錄???????????0??2018-05-20?15:15??design\.settings\
?????文件?????????567??2018-05-17?20:03??design\.settings\.jsdtscope
?????文件??????????73??2018-05-18?21:44??design\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2018-05-17?20:03??design\.settings\org.eclipse.jdt.core.prefs
?????文件?????????470??2018-05-17?20:03??design\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-05-17?20:03??design\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2018-05-17?20:03??design\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-05-17?20:03??design\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-20?15:15??design\build\
?????目錄???????????0??2018-05-24?15:16??design\build\classes\
?????目錄???????????0??2018-05-24?15:16??design\build\classes\com\
?????目錄???????????0??2018-05-24?15:16??design\build\classes\com\hzyc\
?????目錄???????????0??2018-05-24?15:16??design\build\classes\com\hzyc\jdbc\
?????文件????????3368??2018-05-24?15:16??design\build\classes\com\hzyc\jdbc\JDBC.class
?????目錄???????????0??2018-05-24?15:16??design\build\classes\com\hzyc\models\
?????文件????????3093??2018-05-24?15:16??design\build\classes\com\hzyc\models\Department.class
?????文件????????4747??2018-05-24?15:16??design\build\classes\com\hzyc\models\Emp.class
?????文件???????11154??2018-05-24?15:16??design\build\classes\com\hzyc\models\Good.class
?????文件????????3045??2018-05-24?15:16??design\build\classes\com\hzyc\models\Kuncunmingxi.class
?????文件????????4282??2018-05-24?15:16??design\build\classes\com\hzyc\models\MoveStock.class
?????文件????????2842??2018-05-24?15:16??design\build\classes\com\hzyc\models\Operation.class
?????文件????????5541??2018-05-24?15:16??design\build\classes\com\hzyc\models\Stock.class
?????文件????????2324??2018-05-24?15:16??design\build\classes\com\hzyc\models\Unit.class
?????文件????????3976??2018-05-24?15:16??design\build\classes\com\hzyc\models\Warehouse.class
?????目錄???????????0??2018-05-24?15:19??design\build\classes\com\hzyc\servlet\
?????文件????????2528??2018-05-24?15:16??design\build\classes\com\hzyc\servlet\AddDep.class
?????文件????????2048??2018-05-24?15:16??design\build\classes\com\hzyc\servlet\Addemp.class
?????文件????????3117??2018-05-24?18:50??design\build\classes\com\hzyc\servlet\AddgoodServlet.class
............此處省略163個文件信息
- 上一篇:圖書商城系統(tǒng)
- 下一篇:7z解壓縮java代碼+工具
評論
共有 條評論