Se connecter à phpMyAdmin en Java
salut tout le monde :)
j'ai essayè de me connecter a la base de donnèes phpmyadmin avec ce code mais il me donne une erreur..
en fait je travail avec WAMPSERVER pour me connecter a la BD
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.swing.DefaultListModel;
import javax.swing.JFrame;
public class MySQLJDBCDriverTest extends JFrame{
private static javax.swing.JList<String> list;
public static void main(String args[]) throws ClassNotFoundException, SQLException
{
Connection connection ;
Statement statement ;
ResultSet resultSet ;
ResultSetMetaData metaData ;
int numberOfColumns = 0;
DefaultListModel mod=new DefaultListModel();
try
{
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:81/phone" ,"root",""); //phone et le nom de BD
statement = connection.createStatement();
System.out.println("Connection Established");
}catch(ClassNotFoundException | SQLException e){
System.err.println(e);
}
}} |
l'erreur est :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
|
run:
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:483)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:992)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at MySQLJDBCDriverTest.main(MySQLJDBCDriverTest.java:40)
** END NESTED EXCEPTION **
Last packet sent to the server was 20 ms ago.
BUILD SUCCESSFUL (total time: 1 minute 2 seconds) |
merci pour votre aide :D