JSP student exchange forum system MyEclipse development of MySQL database BS framework Java programming JDBC

jspstudentexchangeforummyeclipse

One 、 Source features
     JSP The student exchange forum system is a perfect web Design the system , Understanding JSP java Programming languages help , The system has complete source code and database , The development environment is TOMCAT7.0,Myeclipse8.5 Development , The database for
Mysql5.0, Use java language , The development system mainly adopts B/S Pattern development .

JSP Student exchange forum system myeclipse Development mysql database

JSP Student exchange forum system myeclipse Development mysql database bs frame java Programming jdbc- E-commerce document resources -CSDN download One 、 Source features JSP The student exchange forum system is a perfect web Design the system , Understanding JSPjava Programming development, more download resources 、 For learning materials, please visit CSDN Download channel .https://download.csdn.net/download/qq_41221322/85745840
Two 、 Function is introduced
Meet the application requirements of different user roles of the system : According to need , The system shall divide the roles of the two users according to their use functions and permissions , Form two roles , Namely :
  Administrators : With authority management 、 User management 、 Theme Management 、 Post management 、 Reply management , Have the highest authority of the system ;
  user : The user has registered login 、 View theme 、 Check out the post , Post reply and view announcements ;

(1) The permission information table is shown in table 5.1 Shown :

surface 5.1 Permission information table

Serial number

Field name

data type

length

Primary key

describe

1

qxid

INTEGER

11

yes

Authority number

2

qx

VARCHAR

40

no

jurisdiction

(2) User information table is shown in table 5.2 Shown :

surface 5.2 User information sheet

Serial number

Field name

data type

length

Primary key

describe

1

yhid

INTEGER

11

yes

The user id

2

yhm

VARCHAR

40

no

user name

3

mm

VARCHAR

40

no

password

4

xm

VARCHAR

40

no

full name

5

qx

VARCHAR

40

no

jurisdiction

6

sj

VARCHAR

40

no

mobile phone

7

cydz

VARCHAR

40

no

Common address

8

yx

VARCHAR

40

no

mailbox

(3) The subject information table is shown in table 5.3 Shown :

surface 5.3 Subject information table

Serial number

Field name

data type

length

Primary key

describe

1

ztid

INTEGER

11

yes

Subject number

2

zt

VARCHAR

40

no

The theme

3

js

VARCHAR

40

no

Introduce

(4) The post information table is shown in the following table 5.4 Shown :

surface 5.4 Post information table

Serial number

Field name

data type

length

Primary key

describe

1

tzid

INTEGER

11

yes

Post number

2

tz

VARCHAR

40

no

post

3

zt

VARCHAR

40

no

The theme

4

tp

VARCHAR

40

no

picture

5

nr

VARCHAR

40

no

Content

6

yh

VARCHAR

40

no

user

7

fbsj

VARCHAR

40

no

Release time

8

sfjh

VARCHAR

40

no

Is it essence

(5) Reply information table is shown in table 5.5 Shown :

surface 5.5 Reply information form

Serial number

Field name

data type

length

Primary key

describe

1

hfid

INTEGER

11

yes

Reply No

2

tz

VARCHAR

40

no

post

3

hf

VARCHAR

40

no

reply

4

yh

VARCHAR

40

no

user

5

hfsj

VARCHAR

40

no

Reply time

(6) The announcement information table is shown in table 5.6 Shown :

surface 5.6 Announcement information sheet

Serial number

Field name

data type

length

Primary key

describe

1

ggid

INTEGER

11

yes

Announcement number

2

bt

VARCHAR

40

no

title

3

nr

VARCHAR

40

no

Content

4

fbsj

VARCHAR

40

no

Release time

3、 ... and 、 matters needing attention
    1、 Administrator account :admin password :admin Database configuration file DBO.java
     2、 The development environment is TOMCAT7.0,Myeclipse8.5 Development , The database for Mysql5.0, Use java Language development .
    3、 The database file name is jspsjllt.sql, System name jllt
    4、 System home page address :http://127.0.0.1:8080/jllt/shouye.jsp


 

copyright:author[qq_ two hundred and fifty-one million eight hundred and thirty-],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/175/202206240125278797.html