JSP implementation tree structure (4) -- insert page orgInsert. jsp

// OrgInsert. jsp insert page
<% @ Include file = "connectionDB. jsp" %>
<%
Request. setCharacterEncoding ("big5 ");
String fDep = request. getParameter ("fDep ");
String dep = request. getParameter ("dep ");
// Out. println (fDep );
// Out. println (dep );
Boolean autoCommit = conn. getAutoCommit ();
Try {
Conn. setAutoCommit (false );
String queryF = "select total" +
"From ngb_org" +
"Where name = '" + fDep + "'Order by total ";
// Out. println (queryF + "<br> ");
String tempF = null;
PreparedStatement ps = conn. prepareStatement (queryF );
ResultSet rsw.ps.exe cuteQuery ();
While (rs. next ())
{TempF = rs. getString ("total ");}
// Out. println (tempF + "<br> ");
Char tempFa = tempF. charAt (0 );
Char tempFb = tempF. charAt (1 );
Char tempFc = tempF. charAt (2 );
Char tempFd = tempF. charAt (3 );
Char tempFe = tempF. charAt (4 );
Char tempFf = tempF. charAt (5 );
Int tempFg = Integer. parseInt (tempF. substring (4, 6 ));
String tempC = null;
String tempCC = null;
If (tempFd = 'a ')
{TempC = "% B %"; tempCC = "B ";}
Else if (tempFd = 'B ')
{TempC = "% C %"; tempCC = "C ";}
Else if (tempFd = 'C ')
{TempC = "% D %"; tempCC = "D ";}
Else if (tempFd = 'd ')
{TempC = "% E %"; tempCC = "E ";}
String queryColumn = "select count (*)" +
"From ngb_org" +
"Where total like '" + tempC + "'";
String queryDefference = "select total" +
"From ngb_org" +
"Where total like? ";
Int totalNumber = 0;
// Configure