注册页面
用户注册邮箱: | |
用户名: | |
性别: | 男 女 |
密码: | |
确认密码: | |
目标页面
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="register.operation.*" %>
你添加记录操作的结果:
Java
package register.operation;
import java.sql.*;
public class AddCustomer
{ String email="",
name="",
sex="",
password="";
String addMessage="";
public AddCustomer()
{ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(Exception e){ }
}
public void setEmail(String e)
{ email=e.trim();
}
public void setName(String n)
{ name=n.trim();
try{ byte bb[]=name.getBytes("ISO-8859-1");
name=new String(bb,"gb2312");
}
catch(Exception e){}
}
public void setSex(String s)
{ sex=s.trim();
}
public void setPassword(String p)
{ password=p.trim();
}
public String getAddMessage()
{ String insertCondition="INSERT customer VALUES( '"+email+
"', '"+name+"','"+sex+"',"+password+")";
String str="";
Connection con;
Statement sql;
try {
con=DriverManager.getConnection("jdbc:odbc:e_shop","Administrator","225196");
sql=con.createStatement();
if(email.length()>0)
{ int m=sql.executeUpdate(insertCondition);
if(m!=0)
{ str="注册成功";
}
else
{ str="注册失败";
}
}
else
{ str="必须要有邮箱地址";
}
con.close();
}
catch(SQLException e)
{ str="邮箱地址已注册"+e;
}
return str;
}
}