添加可视化数据库

    Database->Data Source->MySQL->名字、密码、数据库名称->OK

    1. package com.chentianyu.pojo;
    2. /**
    3. * 与数据库匹配的定义
    4. */
    5. public class User {
    6. private String userId;
    7. private String cardType;
    8. private String cardNo;
    9. private String userName;
    10. private String userSex;
    11. private String userAge;
    12. private String userRole;
    13. public User() {
    14. }
    15. public User(String userId, String cardType, String cardNo, String userName, String userSex, String userAge, String userRole) {
    16. this.userId = userId;//user_id变成userId去写属性
    17. this.cardType = cardType;
    18. this.cardNo = cardNo;
    19. this.userName = userName;
    20. this.userSex = userSex;
    21. this.userAge = userAge;
    22. this.userRole = userRole;
    23. }
    24. public String getUserId() {
    25. return userId;
    26. }
    27. public void setUserId(String userId) {
    28. this.userId = userId;
    29. }
    30. public String getCardType() {
    31. return cardType;
    32. }
    33. public void setCardType(String cardType) {
    34. this.cardType = cardType;
    35. }
    36. public String getCardNo() {
    37. return cardNo;
    38. }
    39. public void setCardNo(String cardNo) {
    40. this.cardNo = cardNo;
    41. }
    42. public String getUserName() {
    43. return userName;
    44. }
    45. public void setUserName(String userName) {
    46. this.userName = userName;
    47. }
    48. public String getUserSex() {
    49. return userSex;
    50. }
    51. public void setUserSex(String userSex) {
    52. this.userSex = userSex;
    53. }
    54. public String getUserAge() {
    55. return userAge;
    56. }
    57. public void setUserAge(String userAge) {
    58. this.userAge = userAge;
    59. }
    60. public String getUserRole() {
    61. return userRole;
    62. }
    63. public void setUserRole(String userRole) {
    64. this.userRole = userRole;
    65. }
    66. @Override
    67. public String toString() {
    68. return "User{" +
    69. "userId='" + userId + '\'' +
    70. ", cardType='" + cardType + '\'' +
    71. ", cardNo='" + cardNo + '\'' +
    72. ", userName='" + userName + '\'' +
    73. ", userSex='" + userSex + '\'' +
    74. ", userAge='" + userAge + '\'' +
    75. ", userRole='" + userRole + '\'' +
    76. '}';
    77. }
    78. }