loginbean.java

J2EE指南

package com.sun;
import java.sql.*;
public class LoginBean
{           String logname;
            String password;
           
            String message=""; //用来返回登录是否成功的消息。 
    Connection con;
    Statement stmt; 
    ResultSet rs;
    public LoginBean()
    {  //加载桥接器：
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
    }
   //设置属性值、获取属性值的方法：
   public void setLogname(String name)
    {  logname=name;
    }
   public String getLogname()
    {return logname;
    }
   public void setPassword(String pw)
    {  password=pw;
    }
    public String getPassword()
    {return password;
    }
   
   //查询数据库的member表：
   public String getMessage()
    {
    	try{
        
    con = DriverManager.getConnection("jdbc:odbc:login","","");
    stmt = con.createStatement();
    String sql= "select * from Users where username='" + logname + "' and password='" + password +"';" ; 
    rs = stmt.executeQuery(sql);
          
         if(rs.next())
           { 
           message = rs.getString("username");
           } 
           else
           
           message="输入的用户名或密码不正确";
        stmt.close();
        con.close();
        return message;
       }
     catch(SQLException e)
       { message="输入的用户名或密码不正确";
         
         return message;
       }
    }
}