这个是修改的页面代码[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");
}
%>
酷腾电子商城后台管理
function mycheck(){ if (form1.username.value==""){ alert("请输入用户名称!");form1.username.focus();return; } if (form1.Truename.value==""){ alert("请输入真实姓名!");form1.Truename.focus();return; } if (form1.city.value==""){ alert("请输入城市!");form1.city.focus();return; } if (form1.address.value==""){ alert("您输入的地址!");form1.address.focus();return; } if (form1.postcode.value==""){ alert("请输入邮政编码!");form1.postcode.focus();return; } if (form1.CardNO.value==""){ alert("请输入证件号码!");form1.CardNO.focus();return; } if (form1.CardType.value==""){ alert("请输入证件类型!");form1.CardType.focus();return; } if (form1.Tel.value==""){ alert("请输入电话!");form1.Tel.focus();return; } if (form1.Email.value==""){ alert("请输入Email!");form1.Email.focus();return; } if (form1.Amount.value==""){ alert("请输入消费额!");form1.Amount.focus();return; } form1.submit(); }
|
<%
}else{
out.println("alert('您的操作有误!');window.location.href='index.jsp';");
}%>[/code]
这个是封装类[code="java"]package commerce;
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]