|
为了绕开数据库中base64来执行点击量+1,对案例的代码修改了一下,但是不成功(如果直接执行UPDATE guide SET click_count=click_count+1 WHERE goods_id=13是可以成功的),请指正,谢谢!
- package mfxxl;
- import java.sql.Connection;
- import java.sql.SQLException;
- import javax.naming.NamingException;
- import com.alibaba.fastjson.JSONObject;
- import com.justep.baas.action.ActionContext;
- import com.justep.baas.data.DataUtils;
- public class Click {
- public void clickPlus(JSONObject params, ActionContext context) throws
- SQLException, NamingException {
- String tableName = params.getString("tableName"); //获得调用动作时传入的参数
- String idName = params.getString("idName");
- Integer idNum = params.getInteger("idNum");
- String clickName = params.getString("clickName");
-
- Connection conn = context.getConnection("yxkj"); //获得数据库连接
- try {
- String sql = "UPDATE " + tableName + " SET " + clickName + "=" + clickName + "+1" + " WHERE " + idName + "=" + idNum;
- DataUtils.queryData(conn, sql, null, null, null, null);//从数据库查询数据
- } finally {
- conn.close(); //关闭数据库连接
- }
- }
- }
复制代码
|
|