3. Login - asdfgl98/Project-CodeBuddy GitHub Wiki

๐Ÿ“Œ Login

โœ… Login ์ฃผ์š” ๊ธฐ๋Šฅ

  • ๋กœ๊ทธ์ธ ๋ฒ„ํŠผ ํด๋ฆญ(form์ œ์ถœ) ์‹œ, axios๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋กœ๊ทธ์ธ ๋ผ์šฐํ„ฐ์— ID์™€ PW๋ฅผ ์ „์†กํ•ฉ๋‹ˆ๋‹ค.
  • ๋ผ์šฐํ„ฐ ๋‚ด๋ถ€์—์„œ DB์™€ ์—ฐ๊ฒฐํ•˜์—ฌ ๋ฐ์ดํ„ฐ ๊ฒ€์ฆ ํ›„ ๋กœ๊ทธ์ธ ์ฒ˜๋ฆฌ๋ฅผ ํ•ฉ๋‹ˆ๋‹ค.
  • ID, PW ๊ฒ€์ฆ ์„ฑ๊ณต ์‹œ ์‚ฌ์šฉ์ž ์ด๋ฆ„, ๋‹‰๋„ค์ž„ ๋“ฑ์˜ Session ์ƒ์„ฑ ๋ฐ Main ํŽ˜์ด์ง€๋ฅผ ๋ Œ๋”๋งํ•ฉ๋‹ˆ๋‹ค.
  • ID ๋˜๋Š” PW ์˜ค๋ฅ˜ ์‹œ, ๋กœ๊ทธ์ธ ์‹คํŒจ ๊ฐ’์„ login ํŽ˜์ด์ง€๋กœ ์ „์†กํ•˜์—ฌ nunjucks ๋ฌธ๋ฒ•์„ ์‚ฌ์šฉํ•ด Alert๋กœ ์•„์ด๋”” ๋ฐ ํŒจ์Šค์›Œ๋“œ ํ™•์ธ ๋ฌธ๊ตฌ๋ฅผ ์ถœ๋ ฅํ•ฉ๋‹ˆ๋‹ค.

๐Ÿ’ป CodeDetail

๋กœ๊ทธ์ธ ์š”์ฒญ ๋ผ์šฐํ„ฐ


routes -> user.js (line 87)

 

//๋กœ๊ทธ์ธ๋ผ์šฐํ„ฐ
router.post('/login',(req,res)=>{
    let id = req.body.userId
    let pw = req.body.userPw
    let loginSql = 'SELECT USER_ID, USER_PW, USER_NICK, USER_NAME, USER_LEVEL FROM TB_USER WHERE USER_ID =?'
    conn.connect()

    conn.query(loginSql,[id],(err,result)=>{
        if(err){
            console.log('์ฟผ๋ฆฌ๋ฌธ ์—๋Ÿฌ')
        }
        else{
            if(result.length == 0){
                console.log('ํ•ด๋‹น ์•„์ด๋””๊ฐ€ ์กด์žฌํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค.')
                let faLogin = req.session.loginFalse = true
                res.render('join',{loginFalse : faLogin})
            }
            else{
                if(result[0].USER_ID == id && result[0].USER_PW == pw){
                    console.log(result[0].USER_NICK,'๋‹˜์ด ์ ‘์†ํ•˜์˜€์Šต๋‹ˆ๋‹ค.')

                    // ์ ‘์†์ž ์„ธ์…˜์ƒ์„ฑ
                    let userName = result[0].USER_NAME
                    let userLevel = result[0].USER_LEVEL
                    let seName = req.session.userName = userName
                    let seLevel = req.session.userlevel = userLevel
                    let seLogin = req.session.login = true
                    res.render('main',{login : seLogin, name : seName, level : seLevel})

                }
                else{
                    console.log('๋กœ๊ทธ์ธ์ด ์‹คํŒจํ•˜์˜€์Šต๋‹ˆ๋‹ค.')
                    let faLogin = req.session.loginFalse = true
                    res.render('join',{loginFalse : faLogin})
                }
            }
        }
    })
})
๋กœ๊ทธ์ธ ์‹คํŒจ ์•Œ๋ฆผ


join.html (line 89)


<script>
    let loginFalse = '{{loginFalse}}'
    if(loginFalse){
        alert('์•„์ด๋”” ๋˜๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ํ™•์ธํ•ด์ฃผ์„ธ์š”')
    }
</script>

๐Ÿ–ผ๏ธ Preview

Login.gif

login

โš ๏ธ **GitHub.com Fallback** โš ๏ธ