-
大小: 1.64MB文件類(lèi)型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-08-31
- 語(yǔ)言: Java
- 標(biāo)簽: MVC??高級(jí)查詢(xún)??mysql??
資源簡(jiǎn)介
可以參考】 使用封裝的思想,極盡抽取。專(zhuān)門(mén)的數(shù)據(jù)庫(kù)操作工具類(lèi)(加載注冊(cè)驅(qū)動(dòng)、獲取連接對(duì)象、獲取語(yǔ)句對(duì)象、執(zhí)行語(yǔ)句、釋放資源)、多條件查詢(xún)公共類(lèi)(獲取條件語(yǔ)句、獲取查詢(xún)請(qǐng)求參數(shù))、web基礎(chǔ)servlet+jsp 頁(yè)面跳轉(zhuǎn)

代碼片段和文件信息
package?com.sys.dao;
import?java.util.ArrayList;
import?java.util.List;
import?com.sys.entity.ProdeuctQueryObj;
import?com.sys.entity.Product;
import?com.sys.utils.JDBCUtils;
import?com.sys.utils.StringUtils;
public?class?ProductDao?{
//?創(chuàng)建一個(gè)JDBC
private?JDBCUtils?util?=?new?JDBCUtils();
public?ProductDao()?{
util.getConnection();
}
//?查找?多個(gè)人
public?List?queryAllproducts()?throws?Exception?{
String?sql?=?“SELECT?*?FROM?product“;
List?list?=?util.findMoreRefResult(sql?null?Product.class);
util.releaseConn();
return?list;
}
/**
?*?高級(jí)查詢(xún)
?*?
?*?@param?po
?*?@return
?*?@throws?Exception
?*/
public?List?querryAll(ProdeuctQueryObj?po)?throws?Exception?{
String?sql?=?“SELECT?*?FROM?product?“?+?po.getQuerySql();
Listject>?params?=?po.getParams();
List?list?=?util.findMoreRefResult(sql?params?Product.class);
util.releaseConn();
return?list;
}
/**
?*?通過(guò)ID查詢(xún)信息
?*?@param?id
?*?@return
?*?@throws?Exception
?*/
public?List?querryAll(Long?id)?throws?Exception{
String?sql?=?“SELECT?*?FROM?product?WHERE?dir_id?=??“;
Listject>?params?=?new?ArrayListject>();
params.add(id);
List?list?=?util.findMoreRefResult(sql?params?Product.class);
util.releaseConn();
return?list;
}
//?---------------------------------------------------------------------------
/**
?*?高級(jí)查詢(xún)?查詢(xún)多條件
?*?
?*?@param?name
?*?@param?pmin
?*?@param?pmax
?*?@return?查詢(xún)結(jié)果列表
?*?@throws?Exception
?*/
public?List?queryAllproducts(String?name?Double?pmin?Double?pmax)
throws?Exception?{
StringBuilder?sql?=?new?StringBuilder(“SELECT?*?FROM?product“);
Listject>?params?=?new?ArrayListject>();
Listject>?sqltemp?=?new?ArrayListject>();
if?(StringUtils.hasLength(name))?{
sqltemp.add(“productName?LIKE??“);
//?sql.append(“?AND?productName?LIKE??“);
params.add(“%“?+?name?+?“%“);
}
if?(pmin?!=?null)?{
sqltemp.add(“salePrice?>=??“);
//?sql.append(“?AND?salePrice?>=??“);
params.add(pmin);
}
if?(pmax?!=?null)?{
sqltemp.add(“salePrice?<=??“);
//?sql.append(“?AND?salePrice?<=??“);
params.add(pmax);
}
/*
?*?//方式一:?for(int?i=0;i ?*?sql.append(“?WHERE?“);?}else{?//非第一項(xiàng)?sql.append(“?AND?“);?}
?*?sql.append(sqltemp.get(i));?}
?*/
//?方式二:
if?(sqltemp.size()?>?0)?{
sql.append(“?WHERE?“);
sql.append(org.apache.commons.lang3.StringUtils.join(sqltemp
“?AND?“));
}
List?list?=?util.findMoreRefResult(sql.toString()?params
Product.class);
util.releaseConn();
return?list;
}
}
?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????文件????????841??2017-10-31?10:39??Querrymore\.classpath
?????文件????????303??2017-10-30?16:34??Querrymore\.myme
?????文件???????1753??2017-10-30?18:03??Querrymore\.project
?????文件????????500??2017-10-30?16:34??Querrymore\.settings\.jsdtscope
?????文件????????364??2017-10-30?16:33??Querrymore\.settings\org.eclipse.jdt.core.prefs
?????文件????????468??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.common.component
?????文件????????252??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2017-10-30?16:34??Querrymore\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????2844??2017-10-31?16:08??Querrymore\src\com\sys\dao\ProductDao.java
?????文件????????544??2017-10-31?16:39??Querrymore\src\com\sys\dao\ProductDirDao.java
?????文件????????887??2017-10-31?16:38??Querrymore\src\com\sys\entity\ProdectDir.java
?????文件???????1843??2017-10-31?18:29??Querrymore\src\com\sys\entity\ProdeuctQueryObj.java
?????文件???????2051??2017-10-30?17:58??Querrymore\src\com\sys\entity\Product.java
?????文件???????1109??2017-10-31?15:44??Querrymore\src\com\sys\entity\QueryObj.java
?????文件???????2903??2017-10-31?17:19??Querrymore\src\com\sys\servlet\ProductServlet.java
?????文件????????610??2017-10-31?15:54??Querrymore\src\com\sys\test\TestServlet.java
?????文件???????5723??2017-10-31?14:24??Querrymore\src\com\sys\utils\JDBCUtils.java
?????文件????????415??2017-10-31?14:22??Querrymore\src\com\sys\utils\StringUtils.java
?????文件????????829??2017-10-30?16:33??Querrymore\WebRoot\index.jsp
?????文件?????????36??2017-10-30?16:33??Querrymore\WebRoot\me
?????文件???????3282??2017-10-31?16:08??Querrymore\WebRoot\WEB-INF\classes\com\sys\dao\ProductDao.class
?????文件???????1059??2017-10-31?16:39??Querrymore\WebRoot\WEB-INF\classes\com\sys\dao\ProductDirDao.class
?????文件???????1521??2017-10-31?16:38??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\ProdectDir.class
?????文件???????2054??2017-10-31?18:29??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\ProdeuctQueryObj.class
?????文件???????2882??2017-10-31?10:39??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\Product.class
?????文件???????1530??2017-10-31?15:44??Querrymore\WebRoot\WEB-INF\classes\com\sys\entity\QueryObj.class
?????文件???????3362??2017-10-31?17:19??Querrymore\WebRoot\WEB-INF\classes\com\sys\servlet\ProductServlet.class
?????文件????????822??2017-10-31?15:54??Querrymore\WebRoot\WEB-INF\classes\com\sys\test\TestServlet.class
?????文件???????4999??2017-10-31?14:24??Querrymore\WebRoot\WEB-INF\classes\com\sys\utils\JDBCUtils.class
............此處省略35個(gè)文件信息
評(píng)論
共有 條評(píng)論