Initial exposure to open-source projects: JSP blog notes

To create a blog of your own, you must stand on the shoulders of giants, So I first tried an open-source blog system (JSP blog.

So first, I ran it first.

Prerequisites

Local Environment

WINXP, tomcat7, myeclipse10

Open Source project web site: http://www.oschina.net/p/jsp+blog

Download a. War package from the URL, and put it under Tomcat's webapps.

Result Tomcat automatically decompress the. War file.

Pre-installed Database

The source code provided by the author is obviously old.

Importing scripts to MySQL

Import the file to MySQL.

Specific Practices reference http://www.jb51.net/article/22734.htm

(Note: Some of the SQL code is older and may not be recognized in the newer mysql)

For example, the MySQL query statement is too old to write type = MyISAM. Replace type = MyISAM with engine = MyISAM, and MyISAM in MySQL is the default storage engine.

Method 2: Install a MySQL-front visualization software and copy and execute the code in portal. SQL.

Memorandum:

Org. gjt. Mm. MySQL. Driver and COM. MySQL. JDBC. Driver (http://hi.baidu.com/nzvxsqjptmafvzr/item/2487de1b950c02a6feded5e2)