JSP implementation tree structure (5) -- delete Department page orgDelete. jsp

// OrgDelete. jsp deletes the department page, which is from orgManage. jsp.
<% @ Page contentType = "text/html; charset = Big5" %>
<% @ Include file = "orgConnInclude. jsp" %>
<% @ Page import = "javax. SQL. *" %>
<%
Request. setCharacterEncoding ("big5 ");
String depName = request. getParameter ("name ");
// Out. println (depName + "<br> ");
String message = null;
Boolean autoCommit = conn. getAutoCommit ();
String query1 = "select total" +
"From ngb_org" +
"Where name = '" + depName + "'";
String query2 = "select *" +
"From ngb_org" +
"Where total like? ";
String delete = "delete from ngb_org" +
"Where total like? ";
String delete1 = "delete from ngb_org" +
"Where name =? ";
String temp1 = null;
String temp1a = null;
String temp1aa = null;
String temp1b = null;
Try {
Conn. setAutoCommit (false );
PreparedStatement ps = conn. prepareStatement (query1 );
ResultSet rs1+ps.exe cuteQuery ();
While (rs1.next ())
{Temp1 = rs1.getString ("total ");}
// Out. println (temp1 );
Temp1a = temp1.substring (0, 1 );
Temp1aa = temp1.substring (0, 3 );
Temp1b = temp1.substring (3, 6 );
// Out. println (temp1b );
/*