JavaBean实现用户登陆

JavaBean实现用户登陆

本文简单讲述使用javabean实现用户登录，包括用户登录，注册和退出等。

1. 系统结构图

　　2.数据库表

1. create table P_USER  
2. (  
3.   id       VARCHAR2(50) not null,  
4.   username VARCHAR2(20),  
5. password VARCHAR2(20),  
6.   email    VARCHAR2(50)  
7. ) 

　　3.JavaBean编写

DataAccess.java   数据库操作类使用JDBC连接数据库，并封装了连接数据库、查询、修改、关闭资源等方法

  1 package data;
  2 import java.sql.Connection;
  3 import java.sql.DriverManager;
  4 import java.sql.ResultSet;
  5 import java.sql.SQLException;
  6 import java.sql.Statement;
  7 
  8 public class DataAccess {
  9       private String driver="oracle.jdbc.driver.OracleDriver";
 10       private String url="jdbc:oracle:" + "thin:@localhost:1521:orcl";
 11       private String username="C##LYJ";
 12       private String password="lyj123123";
 13       private Connection con;
 14       private Statement stm=null;
 15       private ResultSet rs;
 16       
 17       public String getDriver(){
 18           return driver;
 19       }
 20       public void setDriver(String driver){
 21           this.driver=driver;
 22       }
 23       
 24       public String getUrl(){
 25           return url;
 26       }
 27       public void setUrl(String url){
 28           this.url=url;
 29       }
 30       
 31       public String getUsername(){
 32           return username;
 33       }
 34       public void steUsername(String username){
 35           this.username=username;
 36       }
 37       
 38       public String getPassword(){
 39           return password;
 40       }
 41       public void setPassword(String password){
 42           this.password=password;
 43       }
 44       
 45       public Connection getCon(){
 46           return con;
 47       }
 48       public void steCon(Connection con){
 49           this.con=con;
 50       }
 51       
 52       public Statement getStm(){
 53           return stm;
 54       }
 55       public void setStm(Statement stm){
 56           this.stm=stm;
 57       }
 58       
 59       public ResultSet getRs(){
 60           return rs;
 61       }
 62       public void setRs(ResultSet rs){
 63           this.rs=rs;
 64       }
 65       //创建连接
 66       public boolean creatCon(){
 67           boolean b=false;
 68           try{
 69               Class.forName(driver);//加载oracle驱动程序
 70               con=DriverManager.getConnection(url, username, password);
 71               b=true;
 72           }catch(SQLException e){
 73               e.printStackTrace();
 74           }
 75           catch(ClassNotFoundException e){
 76               e.printStackTrace();
 77           }
 78           return b;
 79       }
 80       //修改