Jchat:linux Chat Program 2:mysql

The database used by the software is MySQL, because it is free, open source, and is almost the best option under Linux.

The first thing to do in MySQL is to create a new database for the root user and empower the user:

1 CREATE database jchat; 2 ' huanglianjing ';

Then log in to the MySQL huanglianjing user to add the data table:

User table:

1 CREATE TABLE User 2 (3     user varchar (null,4     passwd varchar (null,5     intnull, 6     primary KEY (user)7 );

Message table:

1 CREATE TABLE MESG 2 (3     senduser varchar (null,4     recvuser varchar (  - NULL , 5     Text varchar (null,6    primary KEY (Senduser, Recvuser, text)  7 );

Message table here should be another unique ordinal attribute as the primary key, but omitted because it is relatively simple.

Jchat:linux Chat Program 2:mysql