最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
JSP实现树型组织架构(5)--删除部门页面orgDelete.jsp
时间:2008-01-12 编辑:简简单单 来源:一聚教程网
//orgDelete.jsp 删除部门页面,由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+"
");
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.executeQuery();
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);
/*
<%@ 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+"
");
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.executeQuery();
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);
/*
相关文章
- SpringBoot测试配置属性与web启动环境解析 10-24
- vue中将el-switch值true、false改为number类型的1和0解析 10-24
- Vue中的路由配置项meta使用解读 10-24
- SpringBoot自定义bean绑定解析 10-24
- SpringBoot常用计量与bean属性校验和进制数据转换规则解析 10-24
- 工厂方法在Spring框架中的运用介绍 10-24