📄 datainitial.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) index pagesize 2k) </sql:update> <sql:update var="newprojectTable"> create table project_mast (proj_ID varchar (256) not null, proj_name varchar(256), group varchar(256), lead varchar(256), desc varchar(256), constraint pkcons primary key (proj_ID) index pagesize 2k constraint fk_user foreign key (lead) references user_mast (user_ID) index pagesize 2k) </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), task_desc varchar(256), type varchar(256), comment varchar(256), constraint pkcons primary key (task_ID) index pagesize 2k constraint fk_proj foreign key (project) references project_mast (proj_ID) index pagesize 2k) </sql:update> <sql:update var="newstateTable"> create table state_mast (state_ID varchar (256) not null, state_name varchar(256), plan_start_dt date, plan_end_dt date, act_start_dt date, act_end_dt date, status varchar(256), project varchar(256), state_desc varchar(256), comment varchar(256), constraint pkcons primary key (state_ID) index pagesize 2k constraint fk_proj foreign key (project) references project_mast (proj_ID) index pagesize 2k) </sql:update> <sql:update var="newactivityTable"> create table activity_mast (act_ID varchar (256) not null, act_name varchar(256), parent_task varchar(256), resp_engineer varchar(256), plan_start_dt date, plan_end_dt date, act_st_dt date, act_end_dt date, status varchar(256), reason varchar(1024), act_desc varchar(256), comment varchar(256), constraint pkcons primary key (act_ID) index pagesize 2k constraint fk_task foreign key (parent_task) references task_mast (task_ID) index pagesize 2k constraint fk_task foreign key (resp_engineer) references user_mast (user_ID) index pagesize 2k) </sql:update> <sql:update var="newassignmentTable"> create table assignment_mast (assign_ID varchar (256) not null, assign_name varchar(256), task varchar(256), user varchar(256), desc varchar(256), comment varchar(256), constraint pkcons primary key (assign_ID) index pagesize 2k constraint fk_task foreign key (task) references task_mast (task_ID) index pagesize 2k constraint fk_user foreign key (user) references user_mast (user_ID) index pagesize 2k) </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 + -