|
本帖最后由 ghj386 于 2015-9-4 23:02 编辑
1:\apache-tomcat\webapps\baas\META-INF 目录下context.xml中 有关sql部分语句 member为MS sqlserver下的用户数据库:
<Resource name="jdbc/member" type="javax.sql.DataSource"
maxActive="100" maxIdle="30"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://192.168.139.83:1433/member" username="*****" password="*****" />
2:BAAS目录中:MemberServlet.java 文件中的相关语句
private static final String DATASOURCE_MEMBER = "jdbc/member";
public void service(ServletRequest request, ServletResponse response) throws ServletException {
try {
String action = request.getParameter("action");
if ("queryFood".equals(action)) {
queryFood(request, response);
} else if ("queryUser".equals(action)) {
queryUser(request, response);
} else if ("queryOrder".equals(action)) {
queryOrder(request, response);
} else if ("queryStory".equals(action)) {
queryStory(request, response);
} else if ("save".equals(action)) {
save(request, response);
} else if ("queryGoods".equals(action)) {
save(request, response);
}
} catch (Exception e) {
e.printStackTrace();
throw new ServletException(e);
}
}
private static void queryGoods(ServletRequest request, ServletResponse response) throws SQLException, IOException, NamingException {
// 参数序列化
JSONObject params = (JSONObject) JSONObject.parse(request.getParameter("params"));
// 获取参数
Object columns = params.get("columns");
Integer limit = params.getInteger("limit");
Integer offset = params.getInteger("offset");
String sql = "SELECT GoodsID,GoodsCode,GoodsClassID,Name,NameCode,Unit,Price from goods where 1=1 order by GoodsID Asc";
Table table = null;
Connection conn = Util.getConnection(DATASOURCE_MEMBER);
try {
table = Util.queryData(conn, sql, null, columns, offset, limit);
} finally {
conn.close();
}
// 输出返回结果
Util.writeTableToResponse(response, table);
}
3:index.w文件中相关语句:
<div component="$UI/system/components/justep/data/data" autoLoad="true" xid="Goods" idColumn="GoodsID"><column label="GoodsID" name="GoodsID" type="Integer" xid="default54"></column>
<column label="GoodsCode" name="GoodsCode" type="String" xid="default55"></column>
<column label="GoodsClassID" name="GoodsClassID" type="Integer" xid="default56"></column>
<column label="Name" name="Name" type="String" xid="default57"></column>
<column label="NameCode" name="NameCode" type="String" xid="default58"></column>
<column label="Unit" name="Unit" type="String" xid="default59"></column>
<column label="Price" name="Price" type="Float" xid="default60"></column></div>
<div class="x-panel-content" xid="content1">
<div component="$UI/system/components/justep/contents/contents" class="x-contents x-full"
active="0" xid="contents" slidable="false" swipe="true">
<div class="x-contents-content" xid="GoodsContent">
<div component="$UI/system/components/justep/list/list" class="x-list" xid="list3" data="Goods" style="margin:5px;">
<ul class="x-list-template" xid="listTemplateUl5">
<li xid="li5" class="x-flex takeout-list-row">
<div component="$UI/system/components/justep/row/row" class="x-row x-row-center" xid="row14">
<div class="x-col" xid="col32">
<div component="$UI/system/components/justep/row/row" class="x-row" xid="row19">
<div class="x-col" xid="col25">
<div component="$UI/system/components/justep/output/output" class="x-output" xid="output23" style="font-weight:bold;font-size:large;width:110px;" bind-value=' $model.foodData.val("fName") + $model.foodData.val("fType")' bind-ref="ref('Name')"></div></div>
<div class="x-col" xid="col39">
<div component="$UI/system/components/justep/output/output" class="x-output" xid="output12" style="width:334px;" bind-ref="ref('NameCode')"></div></div> </div>
<div component="$UI/system/components/justep/row/row" class="x-row" xid="row26">
<div class="x-col" xid="col38">
<div component="$UI/system/components/justep/output/output" class="x-output" xid="output14" bind-ref="ref('Unit')" style="margin-top: 3px;"></div></div> </div>
<div component="$UI/system/components/justep/row/row" class="x-row" xid="row18">
<div class="x-col" xid="col37">
<div component="$UI/system/components/justep/output/output" class="x-output" xid="output13" style="color:#FF0000;font-weight:bold;margin-left:5px;" bind-ref="ref('Price')"></div></div>
</div> </div> </div> </li> </ul> </div> </div>
4:index.js中相关语句
Model.prototype.GoodsCustomRefresh = function(event){
var data = event.source;
var params = {
"columns" : Baas.getDataColumns(data),
};
var success = function(resultData) {
var append = event.options && event.options.append;
data.loadData(resultData, append);
};
Baas.sendRequest({
"url" : "/member",
"action" : "queryGoods",
"params" : params,
"success" : success
});
};
运行结果截图:
sql后台同样数据语句结果:
|
-
-
同样sql语句在后台操作结果
|