Forbinde til mysql på webserver fra app?
Er det muligt at forbinde til en mysql server fra en applikation? Jeg skal bruge det til at fjernstyre mine applikationer. Jeg har forsøgt således:import java.sql.*;
class ConnectDB
{
private Connection con;
ConnectDB( String url, String username, String password )
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection( url, username, password );
}
catch( ClassNotFoundException c )
{
System.out.println( "Kunne ikke finde driveren \n"+c );
c.printStackTrace();
}
catch( SQLException cs )
{
System.out.println( "Kunne ikke forbinde til databasen \n"+cs );
cs.printStackTrace();
}
}
public ResultSet select( String SQL )
{
ResultSet rs = null;
try
{
Statement s = con.createStatement();
rs = s.executeQuery( SQL );
}
catch( SQLException sc )
{
System.out.println( "Fejl i QUERY \n"+sc+"\n"+SQL );
sc.printStackTrace();
}
return rs;
}
}
....................................................
import java.sql.*;
class Sql
{
final static ConnectDB db = new ConnectDB( "jdbc:mysql://mysql.cliche.dk/rikif_dk","bruger","kode");
Sql()
{
try{
ResultSet row = db.select("select * from superadmin");
while(row.next())
{
System.out.println("row :"+row.getString("password"));
}
}catch(SQLException e){e.printStackTrace();}
}
public static void main(String[] aslan)
{
new Sql();
}
}
..................................................
Jeg får denne exception:
Kunne ikke forbinde til databasen
java.sql.SQLException: Cannot connect to MySQL server on mysql.cliche.dk:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)
java.sql.SQLException: Cannot connect to MySQL server on mysql.cliche.dk:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at ConnectDB.<init>(ConnectDB.java:11)
at Sql.<clinit>(Sql.java:5)
java.lang.NullPointerException
at ConnectDB.select(ConnectDB.java:29)
at Sql.<init>(Sql.java:10)
at Sql.main(Sql.java:20)
Exception in thread "main"
