1 14 package org.compiere.model; 15 16 import java.sql.*; 17 import java.util.*; 18 19 import org.compiere.Compiere; 20 import org.compiere.util.*; 21 22 28 public class MLanguage extends X_AD_Language 29 { 30 31 37 public static MLanguage get (Properties ctx, Language lang) 38 { 39 return get (ctx, lang.getAD_Language()); 40 } 42 48 public static MLanguage get (Properties ctx, String AD_Language) 49 { 50 MLanguage lang = null; 51 String sql = "SELECT * FROM AD_Language WHERE AD_Language=?"; 52 PreparedStatement pstmt = null; 53 try 54 { 55 pstmt = DB.prepareStatement(sql); 56 pstmt.setString(1, AD_Language); 57 ResultSet rs = pstmt.executeQuery(); 58 if (rs.next()) 59 lang = new MLanguage (ctx, rs); 60 rs.close(); 61 pstmt.close(); 62 pstmt = null; 63 } 64 catch (SQLException ex) 65 { 66 s_log.error("get", ex); 67 } 68 try 69 { 70 if (pstmt != null) 71 pstmt.close(); 72 } 73 catch (SQLException ex1) 74 { 75 } 76 pstmt = null; 77 return lang; 78 } 80 86 public static MLanguage[] getWithLanguage (Properties ctx, String LanguageISO) 87 { 88 ArrayList list = new ArrayList(); 89 String sql = "SELECT * FROM AD_Language WHERE LanguageISO=?"; 90 PreparedStatement pstmt = null; 91 try 92 { 93 pstmt = DB.prepareStatement(sql); 94 pstmt.setString(1, LanguageISO); 95 ResultSet rs = pstmt.executeQuery(); 96 while (rs.next()) 97 list.add(new MLanguage (ctx, rs)); 98 rs.close(); 99 pstmt.close(); 100 pstmt = null; 101 } 102 catch (SQLException ex) 103 { 104 s_log.error("getWithLanguage", ex); 105 } 106 try 107 { 108 if (pstmt != null) 109 pstmt.close(); 110 } 111 catch (SQLException ex1) 112 { 113 } 114 pstmt = null; 115 MLanguage[] languages = new MLanguage[list.size()]; 117 list.toArray(languages); 118 return languages; 119 } 121 122 123 124 129 public MLanguage (Properties ctx, ResultSet rs) 130 { 131 super (ctx, rs); 132 } 134 142 private MLanguage (Properties ctx, String AD_Language, String Name, 143 String CountryCode, String LanguageISO) 144 { 145 super (ctx, 0); 146 setAD_Language (AD_Language); setIsBaseLanguage (false); 148 setIsSystemLanguage (false); 149 setName (Name); 150 setCountryCode(CountryCode); setLanguageISO(LanguageISO); String sql = "SELECT NVL(MAX(AD_Language_ID),0)+1 AS DefaultValue FROM AD_Language"; 153 setAD_Language_ID(DB.getSQLValue(sql)); 154 } 156 157 private static Logger s_log = Logger.getCLogger (MLanguage.class); 158 159 163 public String toString() 164 { 165 return "MLanguage[" + getAD_Language() + "-" + getName() 166 + ",Language=" + getLanguageISO() + ",Country=" + getCountryCode() 167 + "]"; 168 } 170 174 public Locale getLocale() 175 { 176 return new Locale (getLanguageISO(), getCountryCode()); 177 } 179 180 181 182 186 public static void main(String [] args) 187 { 188 System.out.println("Language"); 189 Compiere.startupClient(); 190 Log.setTraceLevel(4); 191 192 System.out.println(MLanguage.get(Env.getCtx(), "de_DE")); 193 System.out.println(MLanguage.get(Env.getCtx(), "en_US")); 194 195 216 } 218 } | Popular Tags |