I build a .jsp by following web and adjust some code 
(The code is wrong, can't build a workable .sql )
web site:
http://j796160836.pixnet.net/blog/post/31158417-%5Bjsp%5D-jsp%E9%80%A3%E6%8E%A5mysql%E5%88%9D%E6%8E%A2

following are my solution{
CREATE DATABASE test_jsdb;
use test_jsdb;
CREATE TABLE IF NOT EXISTS employee(
emp_id int(11) unsigned NOT NULL AUTO_INCREMENT,
emp_name varchar(100) NOT NULL,
emp_age int(11) NOT NULL,
PRIMARY KEY (emp_id))
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

INSERT INTO employee(emp_id, emp_name, emp_age) VALUES(1, 'mary', 20);
INSERT INTO employee(emp_id, emp_name, emp_age) VALUES(2, 'amy', 22);
}

=============
That's my solution which is different with the bloger. YEAH!
And following is the result from Tomcat:
{
can't read data
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'test_jsdb.album' doesn't exist
}

===============
Also, I adjust the demo.jsp . But, it's still can't work.
QAQ

localhost/demo/demo.jsp 
show nothing !!

How can I do ?

============
I solved some promblems. Now, each one of jsp can work.
Next step, I will add two operation : Deleat and update.
I build a .jsp by following web and adjust some code
(The code is wrong, can't build a workable .sql )
web site:
http://j796160836.pixnet.net/blog/post/31158417-%5Bjsp%5D-jsp%E9%80%A3%E6%8E%A5mysql%E5%88%9D%E6%8E%A2

following are my solution{
CREATE DATABASE test_jsdb;
use test_jsdb;
CREATE TABLE IF NOT EXISTS employee(
emp_id int(11) unsigned NOT NULL AUTO_INCREMENT,
emp_name varchar(100) NOT NULL,
emp_age int(11) NOT NULL,
PRIMARY KEY (emp_id))
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;

INSERT INTO employee(emp_id, emp_name, emp_age) VALUES(1, 'mary', 20);
INSERT INTO employee(emp_id, emp_name, emp_age) VALUES(2, 'amy', 22);
}

=============
That's my solution which is different with the bloger. YEAH!
And following is the result from Tomcat:
{
can't read data
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'test_jsdb.album' doesn't exist
}

===============
Also, I adjust the demo.jsp . But, it's still can't work.
QAQ

localhost/demo/demo.jsp
show nothing !!

How can I do ?

============
I solved some promblems. Now, each one of jsp can work.
Next step, I will add two operation : Deleat and update.