Friday, January 24, 2014

Oracle ( Log in code ) query, make db & java LogIn code


SET DEFINE OFF;
Insert into LOGIN_USER
   (USR_ID, USRNAME, USRPW, USRTYPE, EMAIL,
    ACT_FG, CRE_DT, CRE_BY, UPD_DT, UPD_BY,
    USRIMG, GENDER, CONTACT_NO, EMP_ID)
 Values
   (1, 'kaniz', '`“ºŒt¨©dve;WÌ^h8Ë$    Ð', NULL, NULL,
    1, NULL, NULL, NULL, NULL,
    NULL, NULL, NULL, NULL);
COMMIT;


USR_ID = 1
USRNAME = as wish

Coloumn USRPW  = 6093BA8C74A8A96476653B57CC5E6838CB2409D0
USRTYPE = empty
EMAIL = empty
ACT_FG = 1
CRE_DT = empty
CRE_BY = empty
UPD_DT = empty UPD_BY = empty

And others coloumn empty


Log in Code
//START Login code **************
/*public String quickRegPage(){
           
            String usrname = "";
            String usrpw = "";
            boolean fg = true;
        con = dbc.connectDB();

        if (con == null) {
            fg = false;
        }
           
           
       
        if (fg) {
            try {

                  st = con.createStatement();

                query = "select usrname from  login_user where usrname='" + userName + "' "
                        + " and usrpw= pkg_password.encrypt_passmd5('" + password + "') "
                        + " and nvl(act_fg,'0')='1'";
                System.out.println(query);

                rs = st.executeQuery(query);

                while (rs.next()) {
                  usrname = rs.getString("usrname");
                 
                }

            } catch (SQLException sq) {            
                sq.printStackTrace();
            } finally {
                try {
                    if (rs != null) {
                        rs.close();
                    }
                  
                    con.close();
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
        }
       
        if (!usrname.equals("") || usrname!="" && !usrpw.equals("") || usrpw!="") {
            return "quickRegPage";
        }else{
            return "quickRegPageFail";   
        }
       
       
            //return "quickRegPageFail";
      }*/
           
//END Log in code ***************  

No comments:

Post a Comment