91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 1.32MB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發(fā)布日期: 2023-08-16
  • 語言: Java
  • 標簽: java??jsp??servlet??mvc??

資源簡介

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.xml
?????文件??????????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個文件信息

評論

共有 條評論