private static Boolean keyEqual( String key, ConnectionItemType connectionItemType ) {
if (connectionItemType == ConnectionItemType.Server) return key == "server";
if (connectionItemType == ConnectionItemType.Database) return key == "database";
if (connectionItemType == ConnectionItemType.UserId) return key == "user" || key == "uid" || key == "user id";
if (connectionItemType == ConnectionItemType.Password) return key == "password" || key == "pwd";
return false;
}
public static String getConnectionItem(String connStr, ConnectionItemType connectionItemType)
{
if (strUtil.IsNullOrEmpty(connStr))
{
throw new Exception("mysql connection string is empty");
}
String[] arrItems = connStr.ToLower().Split(';');
foreach (String item in arrItems)
{
if (strUtil.IsNullOrEmpty(item))
{
continue;
}
String[] arrPair = item.Split('=');
if (arrPair.Length != 2)
{
continue;
}
String key = arrPair[0].Trim();
String val = arrPair[1].Trim();
if (keyEqual(key, connectionItemType))
{
return(val);
}
}
return("");
}
private String getEnumKey( ConnectionItemType connectionItem ) {
if (connectionItem == ConnectionItemType.Server) return "server";
if (connectionItem == ConnectionItemType.UserId) return "userid";
if (connectionItem == ConnectionItemType.Password) return "password";
if (connectionItem == ConnectionItemType.Database) return "database";
if (connectionItem == ConnectionItemType.IsTrusted) return "istrusted";
return null;
}
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) {
String str = connectionItem.ToString().ToLower().Replace( "userid", "uid" ).Replace( "password", "pwd" );
String[] strArray = connectionString.ToLower().Split( new char[] { ';' } );
foreach (String item in strArray) {
if (item.Trim().ToLower().StartsWith( str ))
return item.Replace( str, "" ).Replace( "=", "" ).Replace( " ", "" );
}
return null;
}
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) {
String str = connectionItem.ToString().ToLower().Replace( "database", "data source" ).Replace( "userid", "user id" );
String[] arrItem = connectionString.ToLower().Split( new char[] { ';' } );
foreach (String item in arrItem) {
if (item.Trim().ToLower().StartsWith( str ))
return item.Replace( str, "" ).Replace( "=", "" ).Replace( " ", "" );
}
return null;
}
public static String getConnectionItem( String connStr, ConnectionItemType connectionItemType ) {
if (strUtil.IsNullOrEmpty( connStr )) throw new Exception( "mysql connection string is empty" );
String[] arrItems = connStr.ToLower().Split( ';' );
foreach (String item in arrItems) {
if (strUtil.IsNullOrEmpty( item )) continue;
String[] arrPair = item.Split( '=' );
if (arrPair.Length != 2) continue;
String key = arrPair[0].Trim();
String val = arrPair[1].Trim();
if (keyEqual( key, connectionItemType )) return val;
}
return "";
}
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem)
{
String str = connectionItem.ToString().ToLower().Replace("database", "data source").Replace("userid", "user id");
String[] arrItem = connectionString.ToLower().Split(new char[] { ';' });
foreach (String item in arrItem)
{
if (item.Trim().ToLower().StartsWith(str))
{
return(item.Replace(str, "").Replace("=", "").Replace(" ", ""));
}
}
return(null);
}
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem)
{
String str = connectionItem.ToString().ToLower().Replace("userid", "uid").Replace("password", "pwd");
String[] strArray = connectionString.ToLower().Split(new char[] { ';' });
foreach (String item in strArray)
{
if (item.Trim().ToLower().StartsWith(str))
{
return(item.Replace(str, "").Replace("=", "").Replace(" ", ""));
}
}
return(null);
}
private static Boolean keyEqual(String key, ConnectionItemType connectionItemType)
{
if (connectionItemType == ConnectionItemType.Server)
{
return(key == "server");
}
if (connectionItemType == ConnectionItemType.Database)
{
return(key == "database");
}
if (connectionItemType == ConnectionItemType.UserId)
{
return(key == "user" || key == "uid" || key == "user id");
}
if (connectionItemType == ConnectionItemType.Password)
{
return(key == "password" || key == "pwd");
}
return(false);
}
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem)
{
if (connectionString == null)
{
throw new NullReferenceException("connectionString");
}
String[] arrItems = connectionString.Split(';');
Dictionary <String, String> dic = new Dictionary <String, String>();
foreach (String item in arrItems)
{
if (strUtil.IsNullOrEmpty(item))
{
continue;
}
String[] arr = item.Trim().Split('=');
if (arr.Length != 2)
{
continue;
}
String akey = getKey(arr[0].Trim());
if (akey == null)
{
continue;
}
dic[akey] = arr[1].Trim();
}
String result = null;
dic.TryGetValue(getEnumKey(connectionItem), out result);
return(result);
}
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) {
if (connectionString == null) throw new NullReferenceException( "connectionString" );
String[] arrItems = connectionString.Split( ';' );
Dictionary<String,String> dic = new Dictionary<String,String>();
foreach (String item in arrItems) {
if (strUtil.IsNullOrEmpty( item )) continue;
String[] arr = item.Trim().Split( '=' );
if (arr.Length != 2) continue;
String akey = getKey( arr[0].Trim() );
if (akey == null) continue;
dic[akey] = arr[1].Trim();
}
String result = null;
dic.TryGetValue( getEnumKey( connectionItem ), out result );
return result;
}
private String getEnumKey(ConnectionItemType connectionItem)
{
if (connectionItem == ConnectionItemType.Server)
{
return("server");
}
if (connectionItem == ConnectionItemType.UserId)
{
return("userid");
}
if (connectionItem == ConnectionItemType.Password)
{
return("password");
}
if (connectionItem == ConnectionItemType.Database)
{
return("database");
}
if (connectionItem == ConnectionItemType.IsTrusted)
{
return("istrusted");
}
return(null);
}
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem )
{
return getConnectionItem( connectionString, connectionItem );
}
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem)
{
return(getConnectionItem(connectionString, connectionItem));
}
