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
|
<?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;
int currId = -1;
</xsp:logic>
<page>
<xsp:logic>
process = <xsp-request:get-parameter name="process"/>;
name = <xsp-request:get-parameter name="name"/>;
</xsp:logic>
<title><xsp:expr>process</xsp:expr> Department Processed</title>
<content>
<esql:connection>
<esql:pool>personnel</esql:pool>
<esql:execute-query>
<esql:query>
select max(id) as maxid from department_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 department_table (id, name) values (
(<esql:parameter><xsp:expr>currId</xsp:expr></esql:parameter> + 1),
<esql:parameter><xsp:expr>name</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>
|
