gVXTU4g8

1package fr.r0x.mysqlTesting;
2import java.sql.Connection;
3import java.sql.DriverManager;
4import java.sql.SQLException;
5import java.sql.Statement;
6import java.util.logging.Level;
7import java.util.logging.Logger;
8
9import javax.persistence.Version;
10
11import org.bukkit.plugin.java.JavaPlugin;
12
13
14
15public class mysqlTesting extends JavaPlugin {
16	
17	
18	
19	public static mysqlTesting plugin;
20	public final Logger logger = Logger.getLogger("Minecraft");
21	
22	
23	Statement st = null;
24	Connection con = null;
25	
26	 
27	
28	
29	@Override
30	public void onDisable() {
31		try {
32			
33			if (con !=null) {
34				con.close();
35			}
36			if (st !=null) {
37				st.close();
38			}
39		}
40				catch (SQLException ex) {
41					Logger lgr = Logger.getLogger(Version.class.getName());
42					lgr.log(Level.WARNING, ex.getMessage(), ex);
43		System.out.println("Tuto Unloaded !");
44	}
45			}
46	
47	@Override
48public void onEnable(){
49		this.getConfig().options().copyDefaults(false);
50		saveConfig();
51		String url = getConfig().getString("sql.url");
52		String usr = getConfig().getString("sql.user");
53		String pass = getConfig().getString("sql.password");
54	
55		String create = "CREATE TABLE IF NOT EXISTS TEST (Player VARCHAR(17), LocationX DOUBLE, LocationY DOUBLE, LocationZ DOUBLE )";
56		
57		
58			
59	try {
60		
61		con = DriverManager.getConnection(url, usr, pass);		
62		st = con.createStatement();
63        st.executeUpdate(create);
64        System.out.println("Connecté avec succès à la table TEST");
65			 
66			 
67				}      
68            
69	catch (SQLException ex) 
70		{	
71		
72        		Logger lgr = Logger.getLogger(Version.class.getName());
73        		lgr.log(Level.SEVERE, ex.getMessage(), ex);
74        		System.out.println(lgr.getName());
75        		
76        		 }
77 
78	
79	
80	
81	
82}
83
84
85}