• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Apps jdbc connection problem

K

krishnaveni

Well-Known Member
i developed one login form...when am entered username and password then clicked login button means nothing happened in my emulator..my logcat having dis error..how it is cleared...help me friends.
package com.example.login;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import android.app.Activity;
import android.content.Intent;
import android.net.Uri;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;



public class LoginLayoutActivity extends Activity {

EditText username,password;
TextView error;
Button ok;

private static final String url = "jdbc:mysql://localhost/xcart";
private static final String user = "root";
private static final String pass = "";
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
username=(EditText)findViewById(R.id.et_un);
password=(EditText)findViewById(R.id.et_pw);

ok=(Button)findViewById(R.id.btn_login);

ok.setOnClickListener(new View.OnClickListener() {



@Override
public void onClick(View v) {
// TODO Auto-generated method stub



try {

Class.forName("com.mysql.jdbc.Driver");
}
catch (ClassNotFoundException ex) {
Logger.getLogger(LoginLayoutActivity.class.getName()).log(Level.SEVERE, null, ex);
}


try {
Connection con = DriverManager.getConnection("jdbc:mysql://dev.mercuryminds.com/xc444test", "xc444tusr", "testxc444");
Statement st = con.createStatement();
String query = "SELECT password FROM xcart_customers where login='"+username+"'";
System.out.println(query);
ResultSet rs = st.executeQuery(query);

if(rs.next())
{
String dbpass = rs.getString(1);
if(dbpass.equals(password)){
error.setText("Correct Username or Password");
Intent i = new Intent(Intent.ACTION_VIEW, Uri.parse("http://www.google.co.in"));
startActivity(i);
}
else
{
error.setText("Sorry!! Incorrect Username or Password");
}
}

} catch (SQLException ex) {
Logger.getLogger(LoginLayoutActivity.class.getName()).log(Level.SEVERE, null, ex);
}
}


});
}
}
Click to expand...
main.xml:
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="210dip"
android:layout_marginTop="10dip"
android:background="#DDDDDD">
<TextView
android:id="@+id/tv_un"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="10pt"
android:textColor="#444444"
android:layout_alignParentLeft="true"
android:layout_marginRight="9dip"
android:layout_marginTop="20dip"
android:layout_marginLeft="10dip"
android:text="User Name:"/>
<EditText
android:id="@+id/et_un"
android:layout_width="150dip"
android:layout_height="wrap_content"
android:background="@android:drawable/editbox_background"
android:layout_toRightOf="@id/tv_un"
android:layout_alignTop="@id/tv_un"/>
<TextView
android:id="@+id/tv_pw"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textSize="10pt"
android:textColor="#444444"
android:layout_alignParentLeft="true"
android:layout_below="@id/tv_un"
android:layout_marginRight="9dip"
android:layout_marginTop="15dip"
android:layout_marginLeft="10dip"
android:text="Password:"/>
<EditText
android:id="@+id/et_pw"
android:layout_width="150dip"
android:layout_height="wrap_content"
android:background="@android:drawable/editbox_background"
android:layout_toRightOf="@id/tv_pw"
android:layout_alignTop="@id/tv_pw"
android:layout_below="@id/et_un"
android:layout_marginLeft="17dip"
android:password="true" />
<Button
android:id="@+id/btn_login"
android:layout_width="100dip"
android:layout_height="wrap_content"
android:layout_below="@id/et_pw"
android:layout_alignParentLeft="true"
android:layout_marginTop="15dip"
android:layout_marginLeft="110dip"
android:text="Login" />
<TextView
android:id="@+id/tv_error"
android:layout_width="fill_parent"
android:layout_height="40dip"
android:textSize="7pt"
android:layout_alignParentLeft="true"
android:layout_below="@id/btn_login"
android:layout_marginRight="9dip"
android:layout_marginTop="15dip"
android:layout_marginLeft="15dip"
android:textColor="#AA0000"
android:text=""/>
</RelativeLayout>
Click to expand...
AndroidManifest.xml:
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.login"
android:versionCode="1"
android:versionName="1.0" >

<uses-sdk android:minSdkVersion="8" />
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.ACCESS_FINE_LOCATION" />
<uses-permission android:name="android.permission.ACCESS_COARSE_LOCATION" />

<application
android:icon="@drawable/ic_launcher"
android:label="@string/app_name" >
<activity
android:label="@string/app_name"
android:name=".LoginLayoutActivity" >
<intent-filter >
<action android:name="android.intent.action.MAIN" />

<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>

</application>

</manifest>
Click to expand...
...
plz reply me....
 
sorry for am not mentioning logcat error.the logcat error is
02-15 02:03:43.882: E/LoginLayoutActivity(970): null
02-15 02:03:43.882: E/LoginLayoutActivity(970): java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.SocketException: The operation timed out
02-15 02:03:43.882: E/LoginLayoutActivity(970): ** BEGIN NESTED EXCEPTION **
02-15 02:03:43.882: E/LoginLayoutActivity(970): java.net.SocketException
02-15 02:03:43.882: E/LoginLayoutActivity(970): MESSAGE: java.net.SocketException: The operation timed out
02-15 02:03:43.882: E/LoginLayoutActivity(970): STACKTRACE:
02-15 02:03:43.882: E/LoginLayoutActivity(970): java.net.SocketException: java.net.SocketException: The operation timed out
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.Connection.createNewIO(Connection.java:1805)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.Connection.<init>(Connection.java:452)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.sql.DriverManager.getConnection(DriverManager.java:191)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.sql.DriverManager.getConnection(DriverManager.java:226)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.example.login.LoginLayoutActivity$1.onClick(LoginLayoutActivity.java:63)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.view.View.performClick(View.java:2408)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.view.View$PerformClick.run(View.java:8816)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.os.Handler.handleCallback(Handler.java:587)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.os.Handler.dispatchMessage(Handler.java:92)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.os.Looper.loop(Looper.java:123)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.app.ActivityThread.main(ActivityThread.java:4627)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.lang.reflect.Method.invokeNative(Native Method)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.lang.reflect.Method.invoke(Method.java:521)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at dalvik.system.NativeStart.main(Native Method)
02-15 02:03:43.882: E/LoginLayoutActivity(970): ** END NESTED EXCEPTION **
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.Connection.createNewIO(Connection.java:1875)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.Connection.<init>(Connection.java:452)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.sql.DriverManager.getConnection(DriverManager.java:191)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.sql.DriverManager.getConnection(DriverManager.java:226)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.example.login.LoginLayoutActivity$1.onClick(LoginLayoutActivity.java:63)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.view.View.performClick(View.java:2408)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.view.View$PerformClick.run(View.java:8816)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.os.Handler.handleCallback(Handler.java:587)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.os.Handler.dispatchMessage(Handler.java:92)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.os.Looper.loop(Looper.java:123)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at android.app.ActivityThread.main(ActivityThread.java:4627)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.lang.reflect.Method.invokeNative(Native Method)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at java.lang.reflect.Method.invoke(Method.java:521)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
02-15 02:03:43.882: E/LoginLayoutActivity(970): at dalvik.system.NativeStart.main(Native Method)
how it is cleared .......help me.....
 
At first I was going to admonish you first sending a user's username and password in clear text over the Internet, but you actually do far far worse. You send the username across the Internet and then send the user's actual password back in clear text! The means I don't even have to guess at the user's password, I can just ask for it and you'll give it!

If this is not a toy project or an assignment, seriously reconsider your approach.
 
hi when am entered username and password after then clicked login button that time displaying java.sql.SQLException error on the Username textbox&#8230;so what error is found here&#8230;y dis error is displayed on the text box&#8230;help me friends....plz reply me.
 
when am entered username and password after then clicked login button that time displaying java.sql.SQLException error on the Username textbox&#8230;so what error is found here&#8230;y dis error is displayed on the text box&#8230;help me friends....plz reply me.
my androidlogin.java file is:
package com.example.login;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import android.app.Activity;
import android.os.Bundle;
import android.text.Editable;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class LoginLayoutActivity extends Activity {


EditText username,password;
TextView error;
Button ok;


/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
username=(EditText)findViewById(R.id.et_un);
password=(EditText)findViewById(R.id.et_pw);
error=(TextView)findViewById(R.id.tv_error);
ok=(Button)findViewById(R.id.btn_login);

ok.setOnClickListener(new View.OnClickListener() {



@Override
public void onClick(View v) {
// TODO Auto-generated method stub

Editable user = username.getText();
Editable pass = password.getText();

try {

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost/login", "root", "");
Statement st = con.createStatement();


ResultSet rs = st.executeQuery("SELECT password FROM customers where username='"+user+"'");

if(rs.next())
{
String dbpass = rs.getString(1);
if(dbpass.equals(pass)){
error.setText("Correct Username or Password");

}
else
{
error.setText("Sorry!! Incorrect Username or Password");
}
}
}

catch (Exception e) {
username.setText(e.toString());
}
}


});
}
}
Click to expand...
plz help me friends...
my androidmanifest file also having internet permission...but y dis error is occured..help me friends.
 
hi, i too getting this same error. but am trying to connect in same machine. can anyone help me pls?
 
You must log in or register to reply here.
Back
Top Bottom