这个是修改的页面代码[code="java"]<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.wgh.DB.connDB"%>
<%@ page import="com.wgh.DB.chStr"%>
<%
connDB conn=new connDB();
chStr chStr=new chStr();
String PID="";
String username="";
String Truename="";
String city="";
String address="";
String postcode="";
String CardNO="";
String CardType="";
float Amount=0;
String Tel="";
String Email="";
PID=request.getParameter("ID");
if (PID!=null && PID!=""){
int ID=Integer.parseInt(PID);
ResultSet rs=conn.executeQuery("select * from tb_member where ID="+ID);
if(!rs.next()){
out.println("alert('您的操作有误!');window.location.href='membermanage.jsp';");
}else{
username=rs.getString("username");
Truename=rs.getString("Truename");
city=rs.getString("city");
address=rs.getString("address");
postcode=rs.getString("postcode");
CardNO=rs.getString("CardNO");
CardType=rs.getString("CardType");
Amount=rs.getFloat("Amount");
Tel=rs.getString("Tel");
Email=rs.getString("Email");
}
%>
|
public class member {
private Integer ID=Integer.getInteger("-1");
private String userName="";
private String trueName="";
private String passWord="";
private String city="";
private String address="";
private String postcode="";
private String cardNO="";
private String cardType="";
private String tel="";
private String email="";
public member(){ //必须的
}
public Integer getID(){
return ID;
}
public void setID(Integer ID){
this.ID=ID;
}
public String getUsername(){
return userName;
}
public void setUsername(String username){
this.userName=username;
}
public String getTruename(){
return trueName;
}
public void setTruename(String truename){
this.trueName =truename;
}
public String getPwd(){
return passWord;
}
public void setPwd(String pwd){
this.passWord =pwd;
}
public String getCity(){
return city;
}
public void setCity(String city){
this.city=city;
}
public String getAddress(){
return address;
}
public void setAddress(String address){
this.address=address;
}
public String getPostcode(){
return postcode;
}
public void setPostcode(String postcode){
this.postcode=postcode;
}
public String getCardno(){
return cardNO;
}
public void setCardno(String cardno){
this.cardNO=cardno;
}
public String getCardtype(){
return cardType;
}
public void setCardtype(String cardtype){
this.cardType=cardtype;
}
public String getTel(){
return tel;
}
public void setTel(String tel){
this.tel=tel;
}
public String getEmail(){
return email;
}
public void setEmail(String email){
this.email =email;
}
}
[/code]
这个是处理修改的代码[code="java"]<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>
<%@ page pageEncoding="gbk"%>
<%@ page import="com.wgh.dao.MemberDaoImpl"%>
/jsp:useBean
<%
Integer id=member.getID();
[color=red]System.out.println("会员id: "+id); //id为null?? [/color]ResultSet rs=conn.executeQuery("select * from tb_member where ID="+id);
//System.out.println("会员"+rs);
//System.out.println("会员"+rs.next());
if (!rs.next()){
out.println("alert('您的操作有误!');window.location.href='index.jsp';"); //不同一条记录?
}else{
int ret=0;
MemberDaoImpl up_member=new MemberDaoImpl();
ret=up_member.update(member);
if (ret!=0){
out.println("alert('会员信息修改成功!');window.location.href='index.jsp';");
}else{
out.println("alert('会员信息修改失败!');window.location.href='index.jsp';");
}
}
%>
[/code]
[code="java"]member_modify_deal.jsp 这个是处理 修改数据的代码
处理的数据 是修改页面 form传过来的
··如果逻辑是这样的话 加个隐藏input
你这个问题也没有说清楚呀。。如果后台报错,应该把后台的错误信息贴出来呀
[code="java"]
member 那就member有问题,你再debug看看 这个member对象···看看是不是null的。
[/code]
你在页面有这个吗?
[code="java"]
[code="java"]你这个功能时 用户修改资料?对吗?
取出数据,没有对ID赋值。。。。
PID=request.getParameter("ID"); 看看这个PID到底取得的时什么数据。
[/code]
修改页面的表单没有ID这个东西,在姓名下边加一行吧:
[code="java"]
不是 加在你的form里面
[/code]