register.java

这是用JSP和SQL来开发的,基本完成了一个网上书店所要的功能,有待于加油的是细点

package j0202_05_login;
import java.sql.*;
public class Register
{ String cus_name,
         cus_realname,
         cus_passw,
         cus_sex,
         cus_email,
         cus_pid,
         cus_phone,
         cus_pasre,
         cus_pasan;
  String message;
  Connection con;
  Statement sql;
  ResultSet rs;
  public Register()
  {try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }
   catch(ClassNotFoundException e){}
  }
  public void setCus_name(String name)
   {cus_name=name;
   }
  public String getCus_name()
   {return cus_name;
   }
  public void setCus_realname(String realname)
   {cus_realname=realname;
   }
  public String getCus_realname()
   {return cus_realname;
   }
  public void setCus_passw(String password)
   {cus_passw=password;
   }
  public String getCus_passw()
   {return cus_passw;
   }
  public void setCus_sex(String sex)
   {cus_sex=sex;
   }
  public String getCus_sex()
   {return cus_sex;
   } 
  public void setCus_email(String email)
   {cus_email=email;
   }
  public String getCus_email()
   {return cus_email;
   }  
  public void setCus_pid(String pid)
   {cus_pid=pid;
   }
  public String getCus_pid()
   {return cus_pid;
   }   
  public void setCus_phone(String phone)
   {cus_phone=phone;
   }
  public String getCus_phone()
   {return cus_phone;
   }  
  public void setCus_pasre(String pasre)
   {cus_pasre=pasre;
   }
  public String getCus_pasre()
   {return cus_pasre;
   }  
  public void setCus_pasan(String pasan)
   {cus_pasan=pasan;
   }
  public String getCus_pasan()
   {return cus_pasan;
   } 
  public String getMessage()
   {return message;
   } 
  public void addItem()
   {try{
     con=DriverManager.getConnection("jdbc:odbc:LocalServer","sa","");
     sql=con.createStatement();
     String s="'"+cus_name+"','"+cus_realname+"','"+cus_passw+"','"+cus_sex+"','"+cus_email+"','"+cus_pid+"','"+cus_phone+"','"+cus_pasre+"','"+cus_pasan+"'"; 
     String condition="insert into cusinf values"+"("+s+")"; 
     sql.executeUpdate(condition);
     message="注册成功";
     con.close();
       }
     catch(SQLException e)
       {message="请重新注册";
       }
    } 
 }