devname.java

java 读写EXCEL文件的源码

/********************************************************************
 *
 * $RCSfile: DevName.java,v $  $Revision: 1.1 $  $Date: 2003/09/22 08:06:24 $
 *
 * $Log: DevName.java,v $
 * Revision 1.1  2003/09/22 08:06:24  icestone
 * init
 *
 *
 *
 **********************************************************************/
package pcdmupgradedata;

import java.sql.*;
import java.util.*;

public class DevName{

  /**根据设施英文表名得到中文名称*/
  public static String getCname(Connection conn,String ename){
    String cname=null;
    String sql = "select cname from u_feature_t where ename='"+ename+"'";
      	try{
      		Statement stmt= conn.createStatement();
      		ResultSet rs = stmt.executeQuery(sql);
      		if(rs.next())
                  cname=rs.getString(1);
      		rs.close();
      		stmt.close();
	}catch(java.sql.SQLException e){
		}
	return cname;
  }

  /**根据设施中文名称得到英文表名*/
  public static String getEname(Connection conn,String cname){
    String ename=null;
    String sql = "select ename from u_feature_t where cname='"+cname+"'";
      try{
              Statement stmt= conn.createStatement();
              ResultSet rs = stmt.executeQuery(sql);
              if(rs.next())
                ename=rs.getString(1);
              rs.close();
              stmt.close();
      }catch(java.sql.SQLException e){
      }
      return ename;
  }
}