用jsp+servlet+javabean做的博客系统

create table userinfo( userinfo_id int primary key identity, userinfo_name varchar(30), user_pwd varchar(30), user_role int, user_date datetime ) create table phototype( phototype_id int primary key identity, phototype_type varchar(30), ) create table photo( photo_id int primary key identity, photo_title varchar(40), photo_type varchar(30), photo_author varchar(12), photo_url varchar(40), photo_info varchar(400), photo_Date datetime, photo_forkey int ) insert into phototype values('aaaaaa') insert into phototype values('bbbbbb') insert into phototype values('cccccc')