一、引用jquery.js 示例:
<SCRIPT type="text/javascript" src="js/jquery.js"></SCRIPT>
二、jsp下拉列表框值得获取
//下拉框值获取
function SelectValue(){
alert("selectvalue");
$.post("newsAction_getLx.action",function(data){
var types=eval(data);
for(var i=0;i<types.length;i++){
$("#selectlx").append("<option value="+types[i].id+">"+types[i].type+"</option>")
}
});
}
三、action类
/**
* 获取类型id、name
* @return
*/
public String getLx(){
try {
ServletActionContext.getRequest().setCharacterEncoding("utf-8");//防止乱码出现
ServletActionContext.getResponse().setCharacterEncoding("utf-8");
} catch (UnsupportedEncodingException e1) {
e1.printStackTrace();
}
String depts=newDao.getLx();
try {
ServletActionContext.getResponse().getWriter().write(depts);
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
四、service类
/**
* 获取类型id、name
* @return
*/
public String getLx(){
Connection conn=Tool.getConnection();
PreparedStatement preStat = null ;
ResultSet rs = null ;
String types="[";
String sql="select id,type from MH_NEWS_TYPE";
try {
preStat=conn.prepareStatement(sql);
rs=preStat.executeQuery();
while(rs.next()){
types+="{'id':'"+rs.getString(1)+"','type':'"+rs.getString(2)+"'},";
}
} catch (SQLException e) {
e.printStackTrace();
} finally{
Tool.release(rs , preStat , conn);
}
return types.substring(0,types.length()-1)+"]";
}