Netty实现Unity登录验证(三)

编写服务端工具类，MySQL连接及登陆信息验证，及int和byte之间的转化

MySQL用户信息表结构：

package com.netty.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class LoginConnetDB {
    private static Connection ct = null;
    private static LoginConnetDB instance = null;

    public static LoginConnetDB getInstance() {
        if (instance == null) {
            instance = new LoginConnetDB();
            instance.init();
        }
        return instance;
    }

    public void init() {
        try {
            getConnet();
        } catch (Exception e) {

        }
    }

    public Connection getConnet() {
        try {

            if (ct == null) {
                String url = "jdbc:mysql://101.200.55.192/armorcraft?user=DBUsername&password=DBPassword&useUnicode=true&characterEncoding=UTF-8";
                Class.forName("com.mysql.jdbc.Driver").newInstance();
                ct = DriverManager.getConnection(url);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return ct;
    }

    public void close() {
        if (ct != null) {
            try {
                ct.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}

package com.netty.util;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class VerifyOperate {

    private PreparedStatement  ps = null;
    private ResultSet rs = null;
    
    private static VerifyOperate instance;
    
    public static VerifyOperate getInstance()
    {
        if (instance == null)
        {
            instance = new VerifyOperate();
            instance.init();
        }
        return instance;
    }
    public void init()
    {
        try
        {

        }
        catch (Exception e)
        {
    
        }
    }
    
    public int checkPlayer(String tableName,String emailOrPhone,String password)
    {    
        //1表示用户名错误、2表示密码错误、-1表示其他错误、>10000 表示成功、
        int re=-1;
        try
        {
            String sql = null;
            if(emailOrPhone.contains("@"))
            {
                sql = "select  *  from  "+tableName+"  where email='"+emailOrPhone+"'";
            }
            else
            {
                sql = "select  *  from  "+tableName+"  where phone='"+emailOrPhone+"'";
            }
            ps = LoginConnetDB.getInstance().getConnet().prepareStatement(sql);
            rs=ps.executeQuery();
            
            if(rs.next())
            {
                String dbPasswd = rs.getString(2);
                
                if(dbPasswd.equals(password))
                {
                    //登入成功
                    re = rs.getInt(1);
                }
                else 
                {
                    //密码错误
                    re = 2;
                }
            }
            else
            {
                //用户名错误
                re = 1;
            }
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
        finally
        {
            try {
                if(rs!=null)
                {
                    
                    rs.close();                
                    rs = null;
                }
                if(ps!=null)
                {
                    
                    ps.close();
                    ps = null;
                }
            } catch (SQLException e) {
                
                e.printStackTrace();
            }
        }
        
        return re;
    }    
    
    public void close()
    {
        try
        {
            if(rs!=null)
            {
                rs.close();
                rs = null;
            }
            if(ps!=null)
            {
                ps.close();
                ps = null;
            }            
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
    }
}

package com.netty.util;
/*
 * int和byte之间的转化
 */
public class CoderUtil {

    public static int bytesToInt(byte[] data, int offset)
    {
        int num = 0;
        
        for(int i = offset; i < offset + 4; i++)
        {
            num <<= 8;
            num |= (data[i] & 0xff);
        }
        
        return num;
    }
    
    public static byte[] intToBytes(int num)
    {
        byte[] b = new byte[4];
        
        for(int i= 0; i < 4; i++)
        {
            b[i] = (byte)(num >>> (24 - i * 8));
        }
        
        return b;
    }    
}