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";
}*/
No comments:
Post a Comment