const mongoose = require(‘mongoose‘)
    //数据库连接27017是mongodb数据库的默认端口
mongoose.connect(‘mongodb://localhost/playground‘, { useNewUrlParser: true })
    .then(() => console.log(‘数据库连接成功‘))
    .catch(() => console.log(‘数据库连接失败‘))

const mongoose = require(‘mongoose‘)
    // 创建用户集合规则
const userSchema = new mongoose.Schema({
    name: {
        type: String,
        required: true,
        minlength: 2,
        maxlength: 20
    },
    age: {
        type: Number,
        min: 18,
        max: 80
    },
    password: String,
    email: String,
    hobbies: [String]
})

const User = mongoose.model(‘User‘, userSchema)

module.exports = User;

const http = require(‘http‘);
const url = require(‘url‘)
const querystring = require(‘querystring‘)

// 连接数据库
require(‘./model/index.js‘)
const User = require(‘./model/user.js‘)



// 创建服务器
const app = http.createServer();


// 为服务器对象添加请求事件
app.on(‘request‘, async(req, res) => {
    // 请求方式
    const method = req.method;
    // 请求地址
    const { pathname, query } = url.parse(req.url, true)
    console.log(query, ‘123‘)

    console.log(pathname)
    if (method == "GET") {
        listtt = ‘‘
        if (pathname == ‘/list‘) {
            let data = await User.find()
            listtt += `
            

        

            

                

                    添加用户
                
                

                    
                        `
            data.forEach(item => {

                listtt +=
                    `
                                                     `
            });
            listtt += `
                        


用户名
                                
年龄
                                
爱好
                                
邮箱
                                
操作
                            


${item.name}
                            
${item.age}
                             


                    `
                item.hobbies.forEach(item => {
                    listtt += `  
                                  
                    ${item}              
                    `
                })
                listtt += ` 
                            

                            
${item.email}
                            

                                修改
                                删除
                            
                        




            
        
    

 `
            res.end(listtt)
        } else if (pathname == ‘/add‘) {
            add = `
            



        

            

                
添加用户
                

                    

                        for="exampleInputEmail1">姓名
                        

                    

                        for="exampleInputPassword1">年龄
                        

                    

                        for="exampleInputEmail1">密码
                        

                    

                        for="exampleInputPassword1">邮箱
                        


                    

                        
                         篮球
                       
                        
                         足球
                      
                         
                         橄榄球
                       
                        
                         敲代码
                      
                         
                         抽烟
                       
                         
                         喝酒
                      
                         
                         烫头
                      
                    
                    提交
                
            
        
    




            `
            res.end(add)
        } else if (pathname == ‘/edit‘) {
            let user = await User.findOne({ _id: query.id });
            let hobbies = [‘足球‘, ‘篮球‘, ‘橄榄球‘, ‘敲代码‘, ‘抽烟‘, ‘喝酒‘, ‘烫头‘]
            let edit = ``
            var editid = user._id
            edit += `
            



        

            

                
编辑用户
                
>
                
"form-group">
                    "exampleInputEmail1">姓名
                    "name" type="text" class="form-control" id="exampleInputEmail1" placeholder="请输入姓名" value="${user.name}">
                    "useid" type="hidden" class="form-control" value="${user._id}">
                

                
"form-group">
                    "exampleInputPassword1">年龄
                    "age" type="text" class="form-control" id="exampleInputPassword1" placeholder="请输入年龄" value="${user.age}">
                

                
"form-group">
                    "exampleInputEmail1">密码
                    "password" type="password" class="form-control" id="exampleInputEmail1" placeholder="请输入密码" value="${user.password}">
                

                
"form-group">
                    "exampleInputPassword1">邮箱
                    "email" type="email" class="form-control" id="exampleInputPassword1" placeholder="请输入邮箱" value="${user.email}">
                

                
"checkbox">
                `

            hobbies.forEach(item => {
                console.log(item)
                    //判断当前循环项在不在用户的爱好数组里
                let isHobby = user.hobbies.includes(item);
                if (isHobby) {
                    edit += `
                   
                       
                           "checkbox" checked name=" hobbies" value="${item}"> ${item}
                       
                    `
                } else {
                    edit += `

                       
                           "checkbox" name=" hobbies" value="${item}">${item}
                       
                   `
                }
            })
            edit += `
                    

                    "submit" class="btn btn-success">提交修改
                
            
        
    



`
            res.end(edit)
        } else if (pathname == ‘/delete‘) {
            // res.end(query.id)
            await User.findOneAndDelete({ _id: query.id });
            res.writeHead(301, {
                Location: ‘/list‘
            })
            res.end()
        }
    } else if (method == "POST") {
        //用户添加功能
        if (pathname == ‘/add‘) {
            //接受用户提交的信息
            let formData = ‘‘;
            //接受post参数
            req.on(‘data‘, param => {
                    formData += param;
                })
                //post 参数接受完毕
            req.on(‘end‘, async() => {
                let user = querystring.parse(formData.replace(/\+/g, ""))
                console.log(user[‘hobbies‘])

                //将提交的数据提交到数据库中
                await User.create(user);
                // 301 代表重定向
                // location 跳转地址
                res.writeHead(301, {
                    Location: ‘/list‘
                });
                res.end();
            })
        } else if (pathname == ‘/edit‘) {
            //接受用户提交的信息
            let formData = ‘‘;
            //接受post参数
            req.on(‘data‘, param => {
                    formData += param;
                })
                //post 参数接受完毕
            req.on(‘end‘, async() => {
                let user = querystring.parse(formData.replace(/\+/g, ""))

                //将提交的数据提交到数据库中
                await User.updateOne({ _id: user.useid }, { name: user.name, age: user.age, password: user.password, email: user.email, hobbies: user.hobbies });
                // 301 代表重定向
                // location 跳转地址
                res.writeHead(301, {
                    Location: ‘/list‘
                });
                res.end();

            })
        }
    }
})

console.log(‘连接服务器成功‘)
app.listen(3000)