Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2015
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. module.exports = {
  2.  
  3. create :function(req,res){
  4.  
  5. if(req.method=="POST"&&req.param("User",null)!=null)
  6. {
  7.  
  8. var insert = "INSERT INTO User VALUES("+req.params.userId+",'"+req.params.loginName+"','"+req.params.userName+"','"+req.params.password+"','"+req.params.userMail+"')";
  9.  
  10. User.query(insert,function(err,record){
  11. if(err)
  12. {
  13. console.log("Error");
  14. }
  15. else
  16. {
  17.  
  18. console.log(record);
  19. res.redirect('User/index');
  20.  
  21. }
  22.  
  23. });
  24. }
  25.  
  26. },
  27.  
  28. <form action="/user/create" method="POST">
  29. <table>
  30. <tr><td>UserId:<td><input type="text" name="User[userId]"><br/>
  31. <tr><td>LoginName:<td><input type="text" name="User[loginName]"><br/>
  32. <tr><td>UserName:<td><input type="text" name="User[userName]"><br/>
  33. <tr><td>Password:<td><input type="text" name="User[password]"><br/>
  34. <tr><td>UserMail:<td><input type="text" name="User[userMail]"><br/>
  35. <tr><td><td><input type="submit" value="Register">
  36. </form>
  37.  
  38. module.exports.connections = {
  39.  
  40. mysql: {
  41. module : 'sails-mysql',
  42. host : 'localhost',
  43. port : 3306,
  44. user : 'root',
  45. password : 'assyst',
  46. database : 'User'
  47.  
  48. },
  49.  
  50. module.exports = {
  51.  
  52. attributes : {
  53. userId : {type: 'string'},
  54. loginName : {type: 'string'},
  55. userName : {model: 'user'},
  56. password : {type: 'array', defaultsTo: []},
  57. userMail : {type: 'text', required: true, unique: true}
  58. }
  59. };
  60.  
  61. <form action="/user" method="POST">
  62. <table>
  63. <tr><td>UserId:<td><input type="text" name="userId"><br/>
  64. <tr><td>LoginName:<td><input type="text" name="loginName"><br/>
  65. <tr><td>UserName:<td><input type="text" name="userName"><br/>
  66. <tr><td>Password:<td><input type="text" name="password"><br/>
  67. <tr><td>UserMail:<td><input type="text" name="userMail"><br/>
  68. <tr><td><td><input type="submit" value="Register">
  69. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement