<%/*
 *this file is part of nseer erp
 *Copyright(C)2006-2010 Nseer(Beijing) Technology co.LTD/http://www.nseer.com 
 *
 *This program is free software; you can redistribute it and/or
 *modify it under the terms of the GNU General Public License
 *as published by the Free Software Foundation; either
 *version 2 of the License, or(at your option) any later version.
*/%><%@page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" import="java.util.*" import="java.io.*" import="include.nseer_db.*,java.text.*,include.nseer_cookie.*,include.get_name_from_ID.*"%><jsp:useBean id="demo" class="include.tree_index.businessComment" scope="page"/><%
demo.setPath(request);
String search="";
String sql="";
ResultSet rs=null;
nseer_db finance_db=new nseer_db((String)session.getAttribute("unit_db_name"));
try{
String currency_id=request.getParameter("currency_id");
sql="select * from finance_config_currency where currency_id='"+currency_id+"'";
rs=finance_db.executeQuery(sql);
if(rs.next()){
search=rs.getString("currency_id")+"⊙"+rs.getString("currency_name")+"⊙"+rs.getString("currency_mark")+"⊙"+demo.qformat(rs.getDouble("currency_rate"))+"⊙"+rs.getString("way_tag")+"⊙"+rs.getString("currency_decimal")+"⊙"+rs.getString("currency_time");
}
System.out.println(search);
out.print(search);
finance_db.close();
}catch(Exception ex){
ex.printStackTrace();
}
%>