Où est charly ?
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
public static void insertConsommationMysql(Connection conn, String table,String nom, String etat,String Password,String Select_priv, String Insert_priv, String Update_priv, String Delete_priv, String Create_priv, String Drop_priv, String Reload_priv, String Shutdown_priv, String Process_priv, String File_priv, String Grant_priv, String References_priv, String Index_priv, String Alter_priv, String Show_db_priv, String Super_priv, String Create_tmp_table_priv,String Lock_tables_priv, String Execute_priv, String Repl_slave_priv, String Repl_client_priv, String Create_view_priv, String Show_view_priv, String Create_routine_priv, String Alter_routine_priv, 
String Create_user_priv, String Event_priv, String Trigger_priv, String ssl_type, String ssl_cipher, String x509_issuer, String x509_subject, String max_questions, String max_updates, String max_connections, String max_user_connections, 
String valeur1, String valeur2,String valeur3,String valeur4,String valeur5,String valeur6,String valeur7,String valeur8, String valeur9,String valeur10,String valeur11,String valeur12,String valeur13,String valeur14,
String valeur15, String valeur16,String valeur17,String valeur18,String valeur19,String valeur20,String valeur21,String valeur22, String valeur23,String valeur24,String valeur25,String valeur26,String valeur27,String valeur28,String valeur29, String valeur30,String valeur31,String valeur32,String valeur33,String valeur34,String valeur35,int valeur36, int valeur37,int valeur38,int valeur39) {
        try {
            Statement stmt = conn.createStatement();
            stmt.executeUpdate("INSERT INTO " + table + 
                    " (" + nom + ", "+ etat + ","+Password+","+Select_priv+ ","+Insert_priv+","+Update_priv+","+ Delete_priv + ", "+ Create_priv + ","+Drop_priv+","+Reload_priv+ ","+Shutdown_priv+","+Process_priv+","+ File_priv+ ", "+ Grant_priv + ","+References_priv+","+Index_priv+ ","+Alter_priv+","+Show_db_priv+","+ Super_priv+ ", "+ Create_tmp_table_priv +","+Lock_tables_priv +","+ Execute_priv +","+Repl_slave_priv+"," +Repl_client_priv+","+ Create_view_priv+ ", "+ Show_view_priv + ","+Create_routine_priv+","+ Alter_routine_priv+ ","+Create_user_priv+","+Event_priv+" + Trigger_priv + ", "+ ssl_type + ","+ssl_cipher+","+ssl_cipher+ ","+x509_issuer+","+x509_subject +","+ max_questions + ", "+ max_updates + ","+max_connections +"," +max_user_connections+") " 
+ "VALUES " +"('" + valeur1 + "','" + valeur2 + "','" + valeur3 +"','" + valeur4 +"','" + valeur5 +"','" +valeur6 +"','" + valeur7 + "','" + valeur8 +"','" + valeur9 +"','" + valeur10 +"','" + valeur11 + "','" + valeur12 +"','" + valeur13 +"','" + valeur14 +"','" + valeur15 + "','" + valeur16 +"','" + valeur17 +"','" + valeur18 +
"','" + valeur19 + "','" + valeur20 +"','" + valeur21 +"','" + valeur22 +"','" + valeur23 + "','" + valeur24 +"','" + valeur25 +"','" + valeur26 +"','" + valeur27 + "','" + valeur28 +"','" + valeur29 +"','" + valeur30 +"','" + valeur31 + "','" + valeur32 +"','" + valeur33 +"','" + valeur34 +"','" + valeur35 + "'," + valeur36 +"," + valeur37 +"," + valeur38 +"," + valeur39 + ")");
 
                 stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }