java bean更新数据库类_jsp+javabean中的更新数据库表的操作问题

Xinxicaozuo.java中的更新部分：//我把更新操作封装在bean里面，where后面的id该怎么从JSP页面中获取？publicintupdate(beans.XinxiBeana){try{con=getConnection();Stringsql="updat...

Xinxicaozuo.java中的更新部分：

//我把更新操作封装在bean里面，where后面的id该怎么从JSP页面中获取？

public int update(beans.XinxiBean a){

try{

con = getConnection();

String sql="update xinxi set username=?,class1=?,biaoti=?,leixing=?,price=?,pinpai=?,memo=?,img=?,lianxiren=?,email=?,dizhi=?,phone=?,fbsj=?,company=?,job=?,skill=?,pay=? where id=?";

pstat = con.prepareStatement(sql);

pstat.setString(1,a.getUsername());

pstat.setString(2,a.getClass1());

pstat.setString(3,a.getBiaoti());

pstat.setString(4,a.getLeixing());

pstat.setString(5,a.getPrice());

pstat.setString(6,a.getPinpai());

pstat.setString(7,a.getMemo());

pstat.setString(8,a.getImg());

pstat.setString(9,a.getLianxiren());

pstat.setString(10,a.getEmail());

pstat.setString(11,a.getDizhi());

pstat.setString(12,a.getPhone());

pstat.setTimestamp(13,a.getFbsj());

pstat.setString(14,a.getCompany());

pstat.setString(15,a.getJob());

pstat.setString(16,a.getSkill());

pstat.setString(17,a.getPay());

eu=pstat.executeUpdate();

}catch(Exception ex){

ex.printStackTrace();

}

Xinxibean.java(封装表中的字段)：

package beans;

import java.sql.Timestamp;

public class XinxiBean {

private int id;

private String username ;

private String class1 ;

...

public String getPay(){

return this.pay ;

}

}

JSP页面：

xxcz.update(xx);

%>

Xinxicaozuo.java中的update方法中的SQL语句where id=?中的id怎样在jsp页面中获取并传递

展开