我的烂笔头

//分类显示
select c.customer_id,'客户' ind,c.real_name,c.phone
from tbu_fpm_pub_customer  c where c.agent_code='0000000123' and c.customer_id<>1
union 
select a.agent_id, '顾问' ind,a.real_name,a.phone
from tbu_fpm_pub_agent  a
union
select c.customer_id + 119,'客户' ind,c.real_name,c.phone
from tbu_fpm_pub_customer  c where c.agent_code='0000000123' and c.customer_id=1

返回上级菜单
window.opener.document.getElementById("msg_content").value = document.getElementById(temp).value;
windows.close();

刷新页面
var src=parent.parent.top_menu.window.location;
parent.parent.top_menu.window.location=src;

确定/取消
if(!confirm("真的要删除该记录吗？"))
{return;}

alert("ddddsdfa");提示框

<input type="text" style="border-width:0px; border-bottom-width: 0px;" name="" value=""> //隐藏text边框

 

select c.customer_id,'客户' ind,c.real_name,c.phone from tbu_fpm_pub_customer c " +
    "where c.agent_code='0000000123'  union  " +
    "select a.agent_id, '顾问' ind,a.real_name,a.phone from tbu_fpm_pub_agent a

 

   try {
    pool = ConnectionPool.getInstance();
    conn = pool.getConnection();// 获得链接
    chitList = ds.getLinkList(link, conn); 
   } catch (Exception e) {
    e.printStackTrace();
    try {
     conn.rollback();// 如果有异常出现，则回滚
    } catch (SQLException e1) {
     e1.printStackTrace();
    }
   } finally {
    pool.releaseConnection(conn);
   }