Error in connecting with mysql using android
I'm developing an app which will retrieve some data from mysql database. I
needed to connect my app with mysql directly to do this. I know, that i
have to use an ip address instead of localhost in getconnection method.
here is the code :
Class.forName("com.mysql.jdbc.Driver");
Log.i("output","class");
con =
DriverManager.getConnection("jdbc:mysql://192.168.1.1:3306/outsidelaundry",
"root", "");
Log.i("output","connection");
Statement stmt = con.createStatement();
String query = "select Name from nonmember";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
val = val + rs.getString(1) + "\n";
}
Log.i("output",val);
con.close();
Manifest.xml
<uses-permission
android:name="android.permission.SEND_SMS"></uses-permission>
<uses-permission
android:name="android.permission.RECEIVE_SMS"></uses-permission>
<uses-permission android:name="android.permission.VIBRATE"/>
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.CAMERA"/>
<uses-feature android:name="android.hardware.camera" />
To be honest i don't know what is the ip address i want to use to get
connection with mysql database. Above i used ip address is not working
too. Please help me with this.
No comments:
Post a Comment