Planning for a tiny
system combining Spring/Struts/Hibernate
Assuming one month's effort(05/20/2016-06/20/2016)
Description:
Input a single web link. Download the pics of this domain and save to the
database. Will also create a page to load and display all the pics if get enough time.
Env:
maven, tomcat
Creating an independent database for this
project
Sybase DB for UAT:
class="sql">
--create database
use master
go
sp_dropdevice syb_data --the file is still there even if drop the device. Need to delete the file from disk manually
go
sp_dropdevice syb_data
go
disk init name = 'syb_data', physname = 'E:\develop\tools\SAP\data\sybdata.dat', size = '10M', dsync = true
go
disk init name = 'syb_log', physname = 'E:\develop\tools\SAP\log\syblog.log', size = '10M', dsync = true
go
create database SYBData on syb_data = '5M' log on syb_log = '5M'
go
--create user
sp_addlogin 'SybDev', 'develop001', 'SYBData' --add new user, can connect to the system dbs,but not other user dbs
go
use SYBData
go
sp_adduser 'SybDev' --can connect to this db at this stage
go
Mysql DB for DEV:
drop database if exists mysqldata; --DB name is case insensitive in mysql
create database if not exists mysqldata;
use mysqldata;
create user 'MysqlUat'@'localhost' identified by 'develop002';
create user 'MysqlUat'@'%' identified by 'develop002';