81,092
社区成员
发帖
与我相关
我的任务
分享
import java.sql.*;
public class Register
{
String logname,realname,password,email,phone,address;
String message;
Connection con;
Statement sql;
ResultSet rs;
public static void main(String args[])
{
Register my=new Register();
my.logname="b";
my.realname="b";
my.password="b";
my.email="b";
my.phone="b";
my.address="b";
my.addItem();
System.out.println(my.message);
}
public Register()
{
//加载桥接器:
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
}
//设置属性值、获取属性值的方法:
public void setLogname(String name)
{
logname=name;
}
public String getLogname()
{
return logname;
}
public void setRealname(String name)
{
realname=name;
}
public String getRealname()
{
return realname;
}
public void setPassword(String pw)
{
password=pw;
}
public String getPassword()
{
return password;
}
public void setEmail(String em)
{
email=em;
}
public String getEmail()
{
return email;
}
public void setPhone(String ph)
{
phone=ph;
}
public String getPhone()
{
return phone;
}
public void setAddress(String ad)
{
address=ad;
}
public String getAddress()
{
return address;
}
public String getMessage()
{
return message;
}
//添加记录到数据库的user表:
public void addItem()
{
try
{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement();
String s="'"+logname+"'"+","+"'"+realname+"'"+","+"'"+password+"'"+","+"'"+
email+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
String condition="insert into user values"+"("+s+")";
sql.executeUpdate(condition);
message="注册成功了";
con.close();
}
catch(SQLException e)
{
message=e.getMessage();//+"你还没有注册,或该用户已经存在,请你更换一个名字";
}
}
}
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="my.Register"%>
<%!//处理字符串的方法:
public String codeString(String s)
{
String str=s;
try
{
byte b[]=str.getBytes("ISO-8859-1");
str=new String(b);
return str;
}
catch(Exception e)
{
return str;
}
}
%>
<html>
<body><font size=1>
<%@ include file="head.txt"%>
<font size=1>
<%String str=response.encodeURL("userRegister.jsp");%>
<p>输入您的信息,带*号项必须填写:
<form action="<%=str%>" method="post">
<br>登录名称<input type=text name="logname">*
<br>真实姓名<input type=text name="realname">*
<br>设置密码<input type=password name="password">*
<br>电子邮件<input type=text name="email">*
<br>联系电话<input type=text name="phone">*
<br>通信地址<input type=text name="address">*
<br><input type=submit name="g" value="提交">
</form>
<jsp:useBean id="login" class="my.Register" scope="request"></jsp:useBean>
<%//提交信息后,进行注册操作:
String logname="",realname="",password="",email="",phone="",address="";
if(!(session.isNew()))
{
logname=request.getParameter("logname");
if(logname==null)
{
logname="";
}
logname=codeString(logname);
realname=request.getParameter("realname");
if(realname==null)
{
realname="";
}
realname=codeString(realname);
password=request.getParameter("password");
if(password==null)
{
password="";
}
password=codeString(password);
email=request.getParameter("email");
if(email==null)
{
email="";
}
email=codeString(email);
phone=request.getParameter("phone");
if(phone==null)
{
phone="";
}
phone=codeString(phone);
address=request.getParameter("address");
if(address==null)
{
address="";
}
address=codeString(address);
}
%>
<%//为了以后处理汉字方便,我们采用了第1种方式初始化beans
if(!(logname.equals(""))&&!(address.equals(""))&&!(phone.equals(""))
&&!(realname.equals(""))&&!(password.equals("")))
{
%>
<jsp:setProperty name="login" property="logname" value="<%=logname%>"/>
<jsp:setProperty name="login" property="realname" value="<%=realname%>"/>
<jsp:setProperty name="login" property="password" value="<%=password%>"/>
<jsp:setProperty name="login" property="email" value="<%=email%>"/>
<jsp:setProperty name="login" property="phone" value="<%=phone%>"/>
<jsp:setProperty name="login" property="address" value="<%=address%>"/>
<jsp:getProperty name="login" property="address"/>
<%
login.addItem();
}
else
{
out.print("你还没有填写信息,或信息填写不完整");
}
%>
<%//返回注册信息
if(!(session.isNew()))
{
%>
<jsp:getProperty name="login" property="message"/>
<%
}
%>
</body>
</html>
package my;
import java.sql.*;
public class Register
{
String logname,realname,password,email,phone,address;
String message;
Connection con;
Statement sql;
ResultSet rs;
public Register()
{
//加载桥接器:
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
}
//设置属性值、获取属性值的方法:
public void setLogname(String name)
{
logname=name;
}
public String getLogname()
{
return logname;
}
public void setRealname(String name)
{
realname=name;
}
public String getRealname()
{
return realname;
}
public void setPassword(String pw)
{
password=pw;
}
public String getPassword()
{
return password;
}
public void setEmail(String em)
{
email=em;
}
public String getEmail()
{
return email;
}
public void setPhone(String ph)
{
phone=ph;
}
public String getPhone()
{
return phone;
}
public void setAddress(String ad)
{
address=ad;
}
public String getAddress()
{
return address;
}
public String getMessage()
{
return message;
}
//添加记录到数据库的user表:
public void addItem()
{
try
{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement();
String s="'"+logname+"'"+","+"'"+realname+"'"+","+"'"+password+"'"+","+"'"+
email+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
String condition="insert into user values"+"("+s+")";
sql.executeUpdate(condition);
message="注册成功了";
con.close();
}
catch(SQLException e)
{
message=e.getMessage();//+"你还没有注册,或该用户已经存在,请你更换一个名字";
}
}
}