1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page
language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp-request="http://apache.org/xsp/request"
>
<xsp:logic>
String process = null;
String name = null;
String departmentId = null;
int currId = -1;
</xsp:logic>
<page>
<xsp:logic>
process = <xsp-request:get-parameter name="process"/>;
name = <xsp-request:get-parameter name="name"/>;
departmentId = <xsp-request:get-parameter name="department"/>;
</xsp:logic>
<title><xsp:expr>process</xsp:expr> Employee Processed</title>
<content>
<esql:connection>
<esql:pool>personnel</esql:pool>
<esql:autocommit>false</esql:autocommit>
<esql:execute-query>
<esql:query>select max(id) as maxid from employee_table</esql:query>
<esql:results>
<esql:row-results>
<xsp:logic>
currId = <esql:get-int column="maxid"/>;
</xsp:logic>
<esql:execute-query>
<esql:query>
insert into employee_table (id, name, department_id) values (
(<esql:parameter><xsp:expr>currId + 1</xsp:expr></esql:parameter>),
<esql:parameter><xsp:expr>name</xsp:expr></esql:parameter>,
<esql:parameter><xsp:expr>departmentId</xsp:expr></esql:parameter>
)
</esql:query>
</esql:execute-query>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
<para><xsp:expr>name</xsp:expr> added</para>
<a href="../welcome">Back to the welcome page</a>
</content>
</page>
</xsp:page>
|
