import java.sql.Connection;

import bitel.billing.server.contract.bean.Contract;
import bitel.billing.server.contract.bean.ContractManager;
import bitel.billing.server.util.MailMsg;
import ru.bitel.bgbilling.kernel.event.Event;
import ru.bitel.bgbilling.kernel.event.events.ContractCreatedEvent;
import ru.bitel.bgbilling.kernel.script.server.dev.EventScriptBase;
import ru.bitel.bgbilling.server.util.Setup;


 
   public void onEvent( event, setup, con, conSlave )
   {
      static final String JDBC_DRIVER = "com.mysql.jdbc.Driver"; 
      String DB_URL = "jdbc:mysql://172.16.0.15/redmine_default";

     //  Database credentials
      String USER = "root";
      String PASS = "root";
      Class.forName("com.mysql.jdbc.Driver");
      Connection conn = DriverManager.getConnection(DB_URL,USER,PASS);
      Statement stmt = conn.createStatement();
       String sql = "SELECT name FROM projects limit 1";
       ResultSet rs = stmt.executeQuery(sql);
      rs.next();

       String first = rs.getString("name");

       print("First: " + first);
     
     
      rs.close();
      stmt.close();
      conn.close();
   }

      try {
         String user = setup.get("xxx.db.user");
         String pswd = setup.get("xxx.db.pswd");
         String dbUrl = setup.get("xxx.db.url");
         String dbDriver = setup.get("xx.db.driver");

         DriverManager.registerDriver((Driver)Class.forName(dbDriver).newInstance());
         neoConn = DriverManager.getConnection(dbUrl, user, pswd);
      } catch (Exception e) {
         log.error("Cannot connect to FTTx DB: " + e.getMessage());
         e.printStackTrace();
         return false;
      }

         String user = setup.get("xxx.db.user");
         String pswd = setup.get("xxx.db.pswd");
         String dbUrl = setup.get("xxx.db.url");
         String dbDriver = setup.get("xx.db.driver");

     try{
           
         String DB_URL = "jdbc:mysql://адрес/bgbilling";
         String USER = "user";
         String PASS = "pass";
         Class.forName("com.mysql.jdbc.Driver");
         Connection conn =  DriverManager.getConnection(DB_URL,USER,PASS);
         Statement stmt = conn.createStatement();
         String sql = "SELECT * FROM contract limit 1";
         ResultSet rs = stmt.executeQuery(sql);
         rs.next();

         String first = rs.getString("title");

         print("First: " + first);
     
     
         rs.close();
         stmt.close();
         conn.close();
} catch(Exception e){
print(e.getMessage());
e.printStackTrace();

}

     try{
           
         String user = setup.get("db.user");
         String pswd = setup.get("db.pswd");
         String dbUrl = setup.get("db.url");
         String dbDriver = setup.get("db.driver");

         DriverManager.registerDriver((Driver)Class.forName(dbDriver).newInstance());
         neoConn = DriverManager.getConnection(dbUrl, user, pswd);
        Statement stmt = neoConn.createStatement();
        String sql = "SELECT * FROM contract limit 1";
        ResultSet rs = stmt.executeQuery(sql);
       rs.next();

         String first = rs.getString("title");

         print("First: " + first);
     
      //STEP 6: Clean-up environment
      rs.close();
      stmt.close();
      conn.close();
} catch(Exception e){
print(e.getMessage());
e.printStackTrace();

}

characterEncoding=utf8

jdbc:mysql://адрес/redmine?characterEncoding=utf8

 String query = "set names utf8";
    stmt.execute(query);

    query = "set character set utf8";
    stmt.execute(query);

@echo off

set BGBILLING_DIR=.
set CLASSPATH=%BGBILLING_DIR%;%BGBILLING_DIR%\lib\*

if not exist %BGBILLING_DIR%\lib.update goto m0

copy %BGBILLING_DIR%\lib.update\* %BGBILLING_DIR%\lib
rmdir /q /s %BGBILLING_DIR%\lib.update

:m0
start c:\Java\jre6\bin\javaw -Dupdate.folder=lib.update -Djavax.net.ssl.trustStore=.keystore -Dsun.net.client.defaultConnectTimeout=1000 -Xmx256m -Duser.language=ru -Duser.region=RU -cp %CLASSPATH% bitel.billing.ShellFrame

start c:\Java\jre6\bin\javaw -Dupdate.folder=lib.update -Djavax.net.ssl.trustStore=.keystore -Dsun.net.client.defaultConnectTimeout=1000 -Xmx256m -Duser.language=ru -Dfile.encoding=UTF-8 -Duser.region=RU -cp %CLASSPATH% bitel.billing.ShellFrame

public void onEvent( event, setup, con, conSlave )
 
   {
     try{
           
        String DB_URL = "jdbc:mysql://адрес редмайна/redmine?characterEncoding=utf8";
        String USER = "user";
        String PASS = "pass";
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

       Statement stmt = conn.createStatement();
       String sql = "select * from news";

        ResultSet rs = stmt.executeQuery(sql);
        rs.next();

        String first = rs.getString("title");

        print("First: " + first);

   
        rs.close();
        stmt.close();
        conn.close();
} catch(Exception e){
    print(e.getMessage());
    e.printStackTrace();

}

 print("привет" );