Problem with sql

[Bigi]

L2J Revision Number: L2J Interlude
L2JDP Revision Number: L2J Interlude

Hi all. I have a some problem with sql. Who can help?
How to write inquiry for loading from base of a variable for each character?

Sorry for my English

[Tryskell]

Consider to give FAR more details, cause like that... It means nothing .

Gl anyway .

[Bigi]

Consider to give FAR more details, cause like that... It means nothing .

Gl anyway .

I need only code of loading a parameter from database. I want to load for each characters a parameter, which influences on a chance of level up of soul crystals. I want to place this code to L2Attackable.java


Sorry for my English

[Tryskell]

There's a lot of exemples everywhere. Search for that sort of codes. And understand how work mySQL queries.

Line number On/Off | Expand/Contract | Select all

1.         Connection con = null;
2.         try
3.         {
4.             con = L2DatabaseFactory.getInstance().getConnection();
5.             PreparedStatement statement = con.prepareStatement("write your SQL query here");
6.             ResultSet result = statement.executeQuery();
7.  
8.             while (result.next())
9.             {
10.                 // Do your blabla here (based on your previous query, it must refer to each player)
11.             }
12.             result.close();
13.             statement.close();
14.         }
15.         catch (Exception e)
16.         {
17.             _log.log(Level.SEVERE, "Error on blabla: ", e);
18.         }
19.         finally
20.         {
21.             try { con.close(); } catch (Exception e) {}
22.         }