/**
* Конструктор. <br>
* Constructor.
*/
public Connection() {
ConfigLoader confGlobal = new ConfigLoader("org.apache.xerces.parsers.SAXParser");
confGlobal.LoadFromFile("xml/confGlobal.xml");
String instanceName = confGlobal.getTagValue("Root.SqlServer.InstanceName");
instanceName = (instanceName != null && !instanceName.isEmpty())
? ("\\" + instanceName) : "";
// Строка подключение к SQL Server
connectionUrl = "jdbc:sqlserver://"
+ confGlobal.getTagValue("Root.SqlServer.ServerName")
+ instanceName
+ ":"
+ confGlobal.getTagValue("Root.SqlServer.PortNumber")
+ ";"
+ "databaseName="
+ confGlobal.getTagValue("Root.SqlServer.DBName")
+ ";"
+ "user="
+ confGlobal.getTagValue("Root.SqlServer.User")
+ ";"
+ "password="
+ confGlobal.getTagValue("Root.SqlServer.Password")
// + textEncryptor.decrypt(
// confGlobal.getTagValue("Root.SqlServer.Password"))
+ ";";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");