! [] (D0a593ed-64a4-495e-99a6-1efa11014eca_files/b013acf0-4402-4e22-bfda-5993df97257d.png)
# # Database
1. Save a fixed 30 IMEI Testimeis for testing
```
CREATE TABLE ' Testimeis ' (
' IMEIs ' VARCHAR (+) DEFAULT NULL
) Engine=innodb DEFAULT charset=utf8mb4;
```
2. Test the configuration Table testcnf
Structure IMEI time Note name
```
CREATE TABLE ' testcnf ' (
' Imei ' VARCHAR (+) DEFAULT NULL,
' Time ' DATETIME DEFAULT NULL,
' Note ' TEXT,
' Name ' VARCHAR (+) DEFAULT NULL
) Engine=innodb DEFAULT charset=utf8mb4;
```
3. Saved Data Sheet TestResult
Structure name IMEI phonenumber receivenumber nettime messagetime interval
```
CREATE TABLE ' TestResult ' (
' Name ' VARCHAR (+) DEFAULT NULL,
' Imei ' VARCHAR (+) DEFAULT NULL,
' PhoneNumber ' VARCHAR (+) DEFAULT NULL,
' Receivenumber ' VARCHAR (+) DEFAULT NULL,
' NetTime ' DATETIME DEFAULT NULL,
' Messagetime ' DATETIME DEFAULT NULL,
' Interval ' DATETIME DEFAULT NULL
) Engine=innodb DEFAULT charset=utf8mb4;
```
# # Backstage Design
1. Model
"' Java
public class Testcnf () {}//configuration model
public class TestResult () {}//Saved data type
```
2. DAO Layer Interface
"' Java
public int Selectbyimei (String IMEI); IMEI query, limit IMEI within test range
public int
```
From for notes (Wiz)
Database design and background model