Student Achievement Management Background second task: Preliminary modeling, building a simple website

Person in charge: Boymatt ru

PARTNER: Honourable

Contracted staff: Xiang Yurong

The background of student performance management, looks like a simple project, but for our future development is very important, the construction of a management background there are many ways, here we mainly use Rstudio, in the following article, will give details of our team to complete the process of the project and encountered problems, welcome everyone to learn from, in addition, Students should actively participate in the discussion.

Project steps: 1. Be familiar with and install the Rstudio, and configure the R internal environment.

2. establish the location where the files are stored and ensure that the documents are in good working order.

3. Build a simple website that is divided into servers. R Port with UI.R port.

4. After the site is set up, insert some controls that are used by the front end.

5. After the layout of the page.

6. Package and transfer of parameter sets.

7. Manage settings for permissions.

8. Create the database and read the data in.

Code:

wd<-"C:/rrr"

Dir.create (WD)

SETWD (WD)

Library (Shiny)

Install.packages ("shiny")

Library (Shiny)

RunApp ("Myzhan") Build a website

install.packages ("Rsqlite") Download a Rsqlite Package

Library (rsqlite) Read Package

Guandao<-dbconnect (Rsqlite (), "c:/rrr/mydata.db")

Dblisttables (Guandao)

Biao <-data.frame (name=c ("Zhang", "Wang", "Li"), create a table

gender=c ("Nan", "NV", "NV"),

home=c ("Wuhai", "Baotou", "Jining"),

stringsasfactors= F)

Dbwritetable (Guandao, "Myone", Biao)

Dblisttables (Guandao)

Dblistfields (Guandao, "Myone")

Dbgetquery (Guandao,

"SELECT * FROM Myone"

)->get.from.mydata

View (Get.form.mydata)

Student Achievement Management Background second task: Preliminary modeling, building a simple website