Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
WebContent
build/classes
src
README.md

README.md

#Q&A-Platform

Sample Page, see also helloworld-qna, helloworld-qna-list

Q&A Platform written by java(servlet), html, js.

Any requests are welcomed!

##Requirements

  • Apache Tomcat
  • MySQL

##Used Libraries

  • jquery mobile
  • mysql-connector-java(jdbc)

##Database Schema ####table info : CREATE TABLE qna ( id int(10) unsigned NOT NULL AUTO_INCREMENT, speaker varchar(30) NOT NULL DEFAULT '', user varchar(100) NOT NULL DEFAULT '', msg varchar(200) NOT NULL DEFAULT '', date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

##REST API

Settings

  • ###in Java Source [src/com.proinlab.util/QnASetting.java]
    • HOST : Database Location, default localhost.
    • PORT : Database Port, default 3306.
    • DB_USER : Database user id, default root.
    • DB_PASSWORD : Database password, default null.
    • DB_NAME : Database name, default qna_example, this is not table name.
  • ###in JavaScript [WebContent/global.js]
    • host : Tomcat Hosts, default 115.88.201.42, is my host.
    • port : Tomcat Port, default 8080.
    • appName : Tomcat webapps name, default qna.
    • refreshTime : ajax reload data delay time, default 1000.
    • textLimit : minimum question text length, default 5.