81,092
社区成员
发帖
与我相关
我的任务
分享
<dwr>
<allow>
<create creator="new" javascript="DBManager">
<param name="class" value="DB.DBManager"/>
</create>
<convert converter="object" match="DB.DBManager"/>
<convert converter="map" match="java.util.Map"/>
<convert converter="array" match="[Z"/>
<convert converter="file" match="[B"/>
<convert converter="array" match="[S"/>
<convert converter="array" match="[I"/>
<convert converter="array" match="[J"/>
<convert converter="array" match="[F"/>
<convert converter="array" match="[D"/>
<convert converter="array" match="[C"/>
<convert converter="array" match="[L*"/>
</allow>
<signatures>
<![CDATA[
import java.util.ArrayList;
import java.util.HashMap ;
import java.lang.Integer;
import java.lang.String;
import DB.DBManager;
DBManager.executeSql(String,HashMap<Integer, Object>);
]]>
</signatures>
</dwr>
function doLoad(){
var sql="select studentcode,studentname,linkTel,bankcardcode from studentbase where uniformcode = ?";
var prams={1:"12345"};
var result;
DBManager.executeSql(sql,prams,{
callback:function(retValue){result=retValue;},async:false
});
form1.ucode.value=result[0]["STUDENTODE"];
form1.uname.value=result[0]["STUDENTNAME"];
form1.tel.value=result[0]["LINKTEL"];
form1.carcode.value=result[0]["BANKCARDCODE"];
}
public ArrayList<HashMap<Object, Object>> executeSql(String strSql,
HashMap<Integer, Object> prams) throws Exception {
getConnection();
// getConnection(_DRIVER,_URL,_USER_NA,_PASSWORD);
pstmt = con.prepareStatement(strSql);
setParamet(pstmt, prams);
logger.info("###############::执行SQL语句操作(查询数据):" + strSql);
rs = pstmt.executeQuery();
if (null != rs) {
return convertResultSetToArrayList(rs);
}
return null;
}