I am practicing some development for Android using Android Studio and I am currently trying to establish an SQL connection between the app I'm working on and the SQL Server I have got set up on my local machine. I would like to note that I am debugging the program through my LG G2 SmartPhone.
Here is the code I've got out of the net after a long search. It's pretty much impossible for me to find anything better:
public class DB_Handler {
public static void ConnectToDatabase(){
new Thread(new Runnable() {
public void run() {
try {
// SET CONNECTIONSTRING
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String username = "DB_9C48A0_androidApp_admin";
String password = "xx";
Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://208.118.63.19:1433/DB_9C48A0_androidApp;user=" + username + ";password=" + password);
Log.w("Connection", "open");
Statement stmt = DbConn.createStatement();
ResultSet reset = stmt.executeQuery(" select * from users ");
String s = reset.getString(1);
DbConn.close();
} catch (Exception e) {
Log.w("Error connection", "" + e.getMessage());
}
}
}).start();
}
}
No errors occur, my debugging just stops and the application shuts down.
Any ideas?
Aucun commentaire:
Enregistrer un commentaire