dbhelper.java~27~

jBuilder编写的用户登陆和注册验证小程序 不含数据库

package loginprj;
import java.sql.*;
/**
 *
 * <p>Title: </p>
 *
 * <p>数据库帮助类: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company aptech: </p>
 *
 * @accp
 * @version 1.0
 */
public class DBHelper {
    public DBHelper() {
    }
    public Connection getConn()
    {
        Connection conn = null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:ds");

        } catch (Exception ex) {
            System.out.println("连接失败"+ex.getMessage());
        }
        return conn;
    }

    public void closeAll(ResultSet rs,PreparedStatement ps,Connection conn)
    {
      try
      {
            if(rs!=null)
            {
                rs.close();
            }
            if(ps!=null)
            {
                ps.close();
            }
            if(conn!=null)
             {
                 conn.close();
            }

      } catch (Exception ex) {
          System.out.println("关闭失败"+ex.getMessage());
      }


    }

    //登陆验证方法
    public  boolean yanzheng(String name,String pwd)
    {
        boolean f =false;
        Connection conn = this.getConn();
        ResultSet rs = null;
        PreparedStatement ps = null;
        try
        {
            ps = conn.prepareStatement("select * from userinfo where uname=? and upwd=?");
            ps.setString(1,name);
            ps.setString(2,pwd);
            rs = ps.executeQuery();
            //如果有数据查出来 则就表示用户合法
            if(rs.next())
            {
                f = true;
            }

        }
        catch (Exception ex)
        {

            System.out.println("登陆失败"+ex.getMessage());
        } finally
        {
            this.closeAll(rs,ps,conn);
        }
        return f;

    }
    //注册方法
    public boolean addUser(String name,String pwd,int age,String sex)
    {
        boolean f =false;
        Connection conn = this.getConn();
        ResultSet rs = null;
        PreparedStatement ps = null;
        try
        {
            ps = conn.prepareStatement("insert into userinfo values (?,?,?,?)");
            ps.setString(1,name);
            ps.setString(2,pwd);
            ps.setInt(3,age);
            ps.setString(4,sex);
            int i =ps.executeUpdate();
            if(i>0)
            {
                f = true;
            }


        }
        catch (Exception ex)
        {
            System.out.println("注册失败 "+ex.getMessage());
        } finally {

        }

    }












}