i have developing a database for android but it is not connected to database throw webservice that using to connect from jtds.

Question

0.00/5 (No votes)

See more:

I have problem to connect database that connect throw jtds webservice, I have include my coding please anyone rectify my problem...

Java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import net.sourceforge.jtds.jdbc.*; 

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;



public class Createaccount extends Activity {
	Button btncreate;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.register);
       btncreate=(Button)findViewById(R.id.btncreate);
    
       btncreate.setOnClickListener(new OnClickListener() {    	    
		
		@Override
		public void onClick(View v) {
			// TODO Auto-generated method stub
			//String connectionUrl = "jdbc:sqlserver://10.0.2.2:1433;"+"databaseName=click4grocer;integratedSecurity=true;";
			String connectionUrl="jdbc:jtds:sqlserver://server_ip_address:10.0.0.27:1433//databaseName=click4grocer;encrypt=fasle;user=sa;password=sa;instance=SQLEXPRESS;";
	          // Declare the JDBC objects.
	          Connection con = null;
	          Statement stmt = null;
	          
	          try {
	              // Establish the connection.
	        	  String driver = "net.sourceforge.jtds.jdbc.Driver";
	              Class.forName(driver);
	              //Class.forName("net.sourceforge.jtds.jdbc.Driver");
	              //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	              
	              con = DriverManager.getConnection(connectionUrl);
	            //Get information from EditText
		             EditText txtusername = (EditText)findViewById(R.id.txtusername);
		             EditText txtpassword = (EditText)findViewById(R.id.txtpassword);
		             EditText txtconpass = (EditText)findViewById(R.id.txtconpass);
		             EditText txtemail = (EditText)findViewById(R.id.txtemail);
		             EditText txtaddress = (EditText)findViewById(R.id.txtaddress);
		             EditText txtphone = (EditText)findViewById(R.id.txtphone);
		             EditText txtblood = (EditText)findViewById(R.id.txtblood);
		             
		           //get values from Textbox
		             String username = txtusername.getText().toString();
		             String password = txtpassword.getText().toString();
		             String conpassword = txtconpass.getText().toString();
		             String email = txtemail.getText().toString();
		             String address = txtaddress.getText().toString();
		             String phone = txtphone.getText().toString();
		             String blood = txtblood.getText().toString();
		             
		             //if required field is missing this msg will show.
		             if(username.equals("")||password.equals("")||conpassword.equals(""))
		             {
		                     Toast.makeText(getApplicationContext(), "Fill the empty field", Toast.LENGTH_LONG).show();
		                     return;
		             }
		             // check if both password matches
		             if(!password.equals(conpassword))
		             {
		                 Toast.makeText(getApplicationContext(), "Password does not match", Toast.LENGTH_LONG).show();
		                 return;
		             }
		             
		             
		          // Create and execute an SQL statement that returns some data.
		             String SQL = "insert into login values('" + username + "', '" + password + "','" + conpassword + "','" + email + "','" + address + "','" + phone + "','" + blood + "');";
		             stmt = con.createStatement();
		             stmt.executeUpdate(SQL);
		             Log.e("Success", "Success");		             
		             //shows the message if account created succesfully. 
		             Toast.makeText(getApplicationContext(),"Account created", Toast.LENGTH_SHORT).show();
		          }
	          
	             // Handle any errors that may have occurred.
	                 catch (Exception e) {
	                 e.printStackTrace();
	                 Log.e("Error", e.toString());
	                 Toast.makeText(getApplicationContext(),"Account is not created", Toast.LENGTH_SHORT).show();
	              }
	          
	                 finally {
	                   if (stmt != null) try { stmt.close(); } catch(Exception e) {}
	                    if (con != null) try { con.close(); } catch(Exception e) {}
	           }
	          
		}
	});
    }  
}

Posted 19-Sep-14 19:33pm

Vijay2106

Updated 19-Sep-14 21:50pm

Richard MacCutchan

v2

Add a Solution

Comments

Richard MacCutchan 20-Sep-14 3:51am

Please show where the error occurs, and provide the complete text of the exception.

Vijay2106 20-Sep-14 8:00am

sir i check my log there is no error msg is shown.when i compile all are compiled successfully but i click the createaccount button it comes to trigger the catch part shows the account is not created message throws my project.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MukeshSagar · Answer 1 · 2014-09-19T22:14:00

Try this Code snippet:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
 
import net.sourceforge.jtds.jdbc.*;
 
public void query2()
{
Log.i("Android"," MySQL Connect Example.");
Connection conn = null;
try {
String driver = "net.sourceforge.jtds.jdbc.Driver";
Class.forName(driver).newInstance();
//test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class;
String connString = "jdbc:jtds:sqlserver://server_ip_address :1433/DBNAME;encrypt=fasle;user=xxxxxxxxx;password=xxxxxxxx;instance=SQLEXPRESS;";
String username = "xxxxxx";
String password = "xxxxxxxxxx";
conn = DriverManager.getConnection(connString,username,password);
Log.w("Connection","open");
Statement stmt = conn.createStatement();
ResultSet reset = stmt.executeQuery("select * from TableName");
 
//Print the data to the console
while(reset.next()){
Log.w("Data:",reset.getString(3));
//              Log.w("Data",reset.getString(2));
}
conn.close();
 
} catch (Exception e)
{
Log.w("Error connection","" + e.getMessage());
}
}