基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

基于Android的二手交易平台, 含服务器端源码以及相关数据库脚本

public class LookDaoImpl extends BaseDaoImpl<Look> implements LookDao {
@Override
protected String getPKName() {
return "lookid";
}

@Override
public PageModel<Look> findByPager(String condition, String string,
int pageSize, int pageNo) {
PageModel<Look> pm = new PageModel<Look>(pageSize, pageNo);
String sql2 = "";
if (condition.equals("username")) {
sql2 = "SELECT * FROM " getTableName()
" where  username = ?  ORDER BY " getPKName()
" DESC ";/*limit ?,?*/
} else {
sql2 = "SELECT * FROM " getTableName() 
" where  category = ?  ORDER BY " getPKName()
" DESC ";/* limit ?,?*/
}
Object[] paramValues = { string/*, (pageNo - 1) * pageSize, pageSize*/ };
Connection conn = null;
try {
conn = DbHelper.getConn();
long count = total();
if (count > 0) {
pm.setRecordCount(count);
pm.setData(qr.query(conn, sql2, beanListHandler, paramValues));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DbHelper.close(conn);
}
return pm;
}

@Override
public void delete(String username, int shopid) {
Connection conn = null;
if(!username.equals("") && username != null){
String sql = "DELETE FROM " getTableName() " WHERE username=?";
try {
conn = DbHelper.getConn();
qr.update(conn, sql, username);
} catch (SQLException e) {
e.printStackTrace();
} finally{
DbHelper.close(conn);
}
}else {
String sql = "DELETE FROM " getTableName() " WHERE lookid=?";
try {
conn = DbHelper.getConn();
qr.update(conn, sql,shopid);
} catch (SQLException e) {
e.printStackTrace();
} finally{
DbHelper.close(conn);
}
}

}


}