51,397
社区成员




<select id="myqrcodelist" parameterType="int" resultType="java.util.Map">
SELECT q.QRpic,p.address,p.productCode,p.productName,p.productId
,f.companyName,f.mobilePhone,p.Qrdate
FROM ap_products p
LEFT JOIN ap_qrrecords q
ON p.productId=q.productId
LEFT JOIN ap_farmermember f
ON p.memberId=f.f_memberId
WHERE p.productId=#{productid}
</select>
/**
* 农户我的生成码
* @param memberid
* @return
*/
public List<Map<String, Object>> shengchengma(int memberid);
/**
* 农户我的生成码
* @param memberid
* @return
*/
public List<Map<String, Object>> shengchengma(int memberid){
return productDao.shengchengma(memberid);
}
/**
* 农户我的生成码
*
* @param response
* @param memberId
* @param orderDirection
* @param q
* @param c
*/
@RequestMapping("/myGeneratedCode")
public void myGeneratedCode(HttpServletResponse response, ProductsEntity p, Integer memberId) {
System.out.println("农户我的生成码");
JSONObject json = new JSONObject();
try {
Map<String, Object> paramters = new HashMap<String, Object>();
paramters.put("memberId", memberId);
List<Map<String, Object>> obj = productService.shengchengma(memberId);
if (obj != null) {
json.put("code", "0");
json.put("msg", "SUCESS");
json.put("obj", obj);
} else {
json.put("code", "200");
json.put("msg", "没有农户我的生成码");
}
} catch (Exception e) {
json = exception(json, e);
}
getPrint(response, json.toString());
}
"Qrdate":{"nanos":0,"time":1471841646000,"minutes":54,"seconds":6,"hours":12,"month":7,"year":116,"timezoneOffset":-480,"day":1,"date":22}
/**
*
* @author hmq 二维码记录表
*/
public class QRrecordsEntity implements Serializable {
private Integer QRId;// 主键ID
private Integer productId;// 产品ID
private String QRcode;// 二维码信息串
private String QRpic;// 二维码图片
private Integer sequenceNo;// 顺序号
private Integer status;// 是否启用1:已删除0:正常
private Integer operationId;//
private Date Qrdate;//二维码生成时间
<select id="myqrcodelist" parameterType="int" resultType="java.util.Map">
SELECT q.QRpic,p.address,p.productCode,p.productName,p.productId
,f.companyName,f.mobilePhone,date_format(p.Qrdate, '%Y-%m-%d') as Qrdate
FROM ap_products p
LEFT JOIN ap_qrrecords q
ON p.productId=q.productId
LEFT JOIN ap_farmermember f
ON p.memberId=f.f_memberId
WHERE p.productId=#{productid}
</select>
mysql日期和字符相互转换方法
date_format(date,'%Y-%m-%d') -------------->oracle中的to_char();
str_to_date(date,'%Y-%m-%d') -------------->oracle中的to_date();
百度过,可是他没说明白,我的变量,我的字段放在哪,这个方法怎么用也没说