...
        L2DatabaseFactory.getInstance();

        java.sql.Connection con =  null ;
         try 
        {
            con = L2DatabaseFactory.getInstance().getConnection();
            PreparedStatement statement = con.prepareStatement("SELECT login, email FROM accounts WHERE login=?");
            _log.config("Prepare statement "+statement);
            statement.setString( 1 , "balancer");
            ResultSet rset = statement.executeQuery();
             if (rset.next())
                _log.info("account exists -> "+rset.getString( 1 ) + ", "+rset.getString( 2 ));
             else 
                _log.info("Account not found");

            rset.close();
            statement.close();

            _log.info("statement executed ");

        }
...

            String userName = "-----";
            String password = "------";
            String url = "jdbc:mysql://localhost/WWW";
             Class .forName ("com.mysql.jdbc.Driver").newInstance ();
            conn = DriverManager.getConnection (url, userName, password);
            System.out.println ("Database connection established");

            PreparedStatement s = conn.prepareStatement("SELECT id, value FROM hts_data_title WHERE id = ?");
            s.setString( 1 , "тут-значение-ключа");
            s.executeQuery();
            ResultSet rs = s.getResultSet ();
             int  count =  0 ;
             while  (rs.next () && (count <  5 ))
            {
                String id = rs.getString ("id");
                String val = rs.getString ("value");
                System.out.println("id = " + id + ", value = " + val);
                ++count;
            }
            rs.close ();
            s.close ();
            System.out.println (count + " rows were retrieved");

/usr/sbin/mysqld, Version:  4 . 1 . 21 -log. started with:
Tcp port:  3306   Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
 061021   16 : 06 : 06         1  Connect     username@localhost on WWW
                       1  Query       SET NAMES utf8
                       1  Query       SET character_set_results = NULL
                       1  Query       SHOW VARIABLES
                       1  Query       SHOW COLLATION
                       1  Query       SET autocommit= 1 
                       1  Prepare     [ 1 ] SELECT id, value FROM hts_data_title WHERE id = ?
                       1  Execute     [ 1 ] SELECT id, value FROM hts_data_title WHERE id = ''
                       1  Quit

                        PreparedStatement s = conn.prepareStatement("SELECT id, user_id, type, title FROM 
job WHERE id = ? AND user_id = ? AND type= ? AND time = ? AND timing = ? ");
                        s.setInt( 1 ,  117 );
                        s.setInt( 2 ,  0 );
                        s.setString( 3 , "vacancy");
                        s.setInt( 4 ,  1153232406 );
                        s.setString( 5 , "fulltime");
                        s.executeQuery();
                        ResultSet rs = s.getResultSet ();

 061021   16 : 14 : 19        25  Connect     username@localhost on WWW
                      25  Query       SET NAMES utf8
                      25  Query       SET character_set_results = NULL
                      25  Query       SHOW VARIABLES
                      25  Query       SHOW COLLATION
                      25  Query       SET autocommit= 1 
                      25  Prepare     [ 1 ] SELECT id, user_id, type, title FROM job WHERE id = ? AND user_id
= ? AND type= ? AND time = ? AND timing = ?
                      25  Execute     [ 1 ] SELECT id, user_id, type, title FROM aviaport_job WHERE id =  196864  AND use
r_id =  16580611  AND type= '\0.\0' AND time =  117  AND timing = ''
                      25  Quit

System.out.println("ps="+s.toString());

ps=com.mysql.jdbc.ServerPreparedStatement[ 1 ] - SELECT id, user_id, type, title FROM job WHERE id =  117  AND user_id =  0  AND type= 'vacancy' AND time =  1153232406  AND timing = 'fulltime'

useServerPrepStmts=false