I have written the experience of loan system for 2 months

5 Projects done at the beginning of the month , Some things delay the progress of the project , So until now, only about half of it has been written . however , The core of the project is borrowing 、 The repayment is almost finished . therefore , I share some of my experiences with you .

1. Database design ： I don't think we need to design too many watches , Too much is not good for managing the logical relationship between tables , Too little, the logical relationship is not tight . From borrowing to repayment ： Borrowing requires the borrower to borrow , Then there should be a borrower information form . Each borrower has a different amount , There are different types of quotas , You need a quota information table and a quota category table . When the borrower releases the loan information , Need a table to process loan information , And the loan has different target types for the borrower to borrow , You need a table of loan subject types , At the same time, after the loan information is successfully released , The administrator is required to audit , At this time, you can get another administrator table , You can also combine the administrator table and the borrower information table into a personnel table . Administrator audit completed , There must be investors to invest , At this time, it is necessary to deal with investor information and investment capital flow records , Of course , Investors can be included in the personnel table , The capital record must be handled with a capital record form . How much did investors invest , You can see in the loan information . The full bid review is completed , The capital record sheet records the borrower's capital arrival , And design a repayment form , Supervise repayment .

2. Page design , Most of the pages in the early stage of the project are static , The purpose is to take the static page as the template when realizing the dynamic update of the page . Design static pages , For the same , There's no big difference , Copy if you can , You can also go directly to the web page to find templates , Not for anything else, just to save time . Backstage design , Direct copy Layui Just the page , Because there are more tables and navigation bars in the background

3. Realization function , Or issue a loan , Involves changing the database , Roll back the table of the wrong operation with rollback , Rollback is not a database operation failure , Rollback of the database is more predictable , Will correct the inevitable errors , Similar to delete , There will be rollback information in the database , But through ordinary queries , It's impossible to get . Judge that the database has been rolled back , Observe the automatically updated primary key , Generally, you will see that the numbers are incoherent .

1. Primary key of this table 1-18 All rolled back .