|
楼主 |
发表于 2017-9-12 21:14:11
|
显示全部楼层
全部动作代码如下供各位学习参考:
package hxzc;
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;
import com.justep.baas.data.Table;
import java.sql.Statement;
import com.justep.baas.data.Transform;
import java.sql.ResultSet;
public class Jvyggh {
public static JSONObject dlyz(JSONObject params, ActionContext context) throws SQLException, NamingException {
String tableName = "yggh"; //获得调用动作时传入的参数
String cs=params.getString("imsi");
Table table = null;
String sql = "SELECT yggh,ygxm,zhjb FROM "+ tableName ;
Connection conn = context.getConnection("khgl"); //获得数据库连接
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
String zhjb=null;
while (rs.next())
{
zhjb=rs.getString("zhjb");
}
System.out.println(zhjb);
try
{
table = DataUtils.queryData(conn, sql, null, null, null, null);//从数据库查询数据
String sqlTotal = "SELECT COUNT(*) FROM "+ tableName;
Object total = DataUtils.getValueBySQL(conn, sqlTotal, null);
table.setTotal(Integer.parseInt(total.toString()));
System.out.println(sql);
return Transform.tableToJson(table); //将table 序列化后返回前端
}
finally
{
conn.close(); //关闭数据库连接
}
}
} |
|