?? datainitialcloud.jsp
字號:
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %><%@page contentType="text/html"%><html><head><title>JSP Page</title></head><body><CENTER><FONT size='12' face='Arial' >The following tables have been created:User, Project, Task, State, Assignment, Activity</FONT></CENTER><sql:setDataSource dataSource="jdbc/WorkflowAppDb" var="workflow"/><sql:transaction dataSource="${workflow}"> <sql:update var="newuserTable"> create table user_mast (user_ID varchar (256) not null, password varchar(256), f_name varchar(256), l_name varchar(256), location varchar(256), phone varchar(256), email varchar(256), title varchar(256), role varchar(256), constraint pkcons primary key (user_ID) ) </sql:update> <sql:update var="newprojectTable"> create table project_mast (proj_ID varchar (256) not null constraint pkcons2 primary key, proj_name varchar(256), group_w varchar(256), desc1 varchar(256), lead varchar(256) constraint fk_user references user_mast ) </sql:update> <sql:update var="newtaskTable"> create table task_mast (task_ID varchar (256) not null, task_name varchar(256), plan_start_dt date, plan_end_dt date, act_start_dt date, act_end_dt date, status varchar(256), predecessor varchar(256), project varchar(256) constraint fk_proj references project_mast, task_desc1 varchar(256), type varchar(256), comment varchar(256), constraint pkcons3 primary key (task_ID) ) </sql:update> <sql:update var="newactivityTable"> create table activity_mast (act_ID varchar (256) not null, act_name varchar(256), parent_task varchar(256) constraint fk_task_ac references task_mast (task_ID) , resp_engineer varchar(256) constraint fk_user_ac references user_mast, plan_start_dt date, plan_end_dt date, act_st_dt date, act_end_dt date, status varchar(256), reason varchar(1024), act_desc1 varchar(256), comment varchar(256), constraint pkcons4 primary key (act_ID) ) </sql:update> <sql:update var="newassignmentTable"> create table assignment_mast (assign_ID varchar (256) not null, assign_name varchar(256), task varchar(256) constraint fk_task2 references task_mast, user_w varchar(256) constraint fk_user2 references user_mast, desc1 varchar(256), comment varchar(256), constraint pkcons5 primary key (assign_ID) ) </sql:update> <sql:update var="newuserEntry"> insert into user_mast values ( 'tomcat', 'sqe', 'first name', 'last name', 'SCA14', ' ', 'tomat-test@sun.com', 'tomat-testgroup', 'engineer') </sql:update></sql:transaction></body></html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -