Database Develop

Adding a Spinner and posting the data to database [volley]

public class MainActivity extends Activity {
EditText name, phonenumber, address;
Button insert;
RequestQueue requestQueue;
String insertUrl = "localhosti/insertCustomer.php";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
/* CHECK INTERNET CONNECTION */
boolean mobileNwInfo = false;
ConnectivityManager conxMgr = (ConnectivityManager) getSystemService(CONNECTIVITY_SERVICE);
try { mobileNwInfo = conxMgr.getActiveNetworkInfo().isConnected(); }
catch (NullPointerException e) { mobileNwInfo = false; }
if ( mobileNwInfo == false ) {
Toast.makeText(this, "No Network, please check your connection. ", Toast.LENGTH_LONG).show();
}
/* CHECK INTERNET CONNECTION PROCEDURE DONE */
name = (EditText) findViewById(R.id.editText);
phonenumber= (EditText) findViewById(R.id.editText2);
address = (EditText) findViewById(R.id.editText3);
insert = (Button) findViewById(R.id.insert);
requestQueue = Volley.newRequestQueue(getApplicationContext());
insert.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
final ProgressDialog pd = new ProgressDialog(MainActivity.this);
pd.setMessage("Booking Service ....");
pd.show();
StringRequest request = new StringRequest(Request.Method.POST, insertUrl, new Response.Listener<String>() {
@Override
public void onResponse(String response) {
pd.hide();
System.out.println(response.toString());
name.setText("");
phonenumber.setText("");
address.setText("");
Toast.makeText(getApplicationContext(), "Service successfully booked !!", Toast.LENGTH_LONG).show();
}
}, new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
pd.hide();
Toast.makeText(getApplicationContext(), "Error: Please try again later.", Toast.LENGTH_LONG).show();
}
}) {
@Override
protected Map<String, String> getParams() throws AuthFailureError {
Map<String, String> parameters = new HashMap<String, String>();
parameters.put("name", name.getText().toString());
parameters.put("phonenumber", phonenumber.getText().toString());
parameters.put("address", address.getText().toString());
return parameters;
}
};
requestQueue.add(request);
}
});
}
}
Click to expand...
Click to collapse
how can i fetch the data from a spinner and post it to my db along with the current data ?

My countdown timers don't work smooth.

Hello everyone i try to get commands from txt file and I want to run these commands in order for a certain period of time.I can get the commands from the txt file correctly but when I want to do these commands using a countdown timer for a certain period of time, there is a problem.The problem is that I do the first command in the time that I want, but it does not execute the next commands.
My txt file:
Ileri,5,1 /n -->this command work well.mp.start() method works for 5 seconds.Commands under this command do not work.
Sol,10,1 /n -->10 is operation time 1 is The number of repetitions.
Sag,5,1 /n
Geri,10,1 /n
Button's Code:
start_btn.setOnClickListener(new View.OnClickListener() { 
 @override
public void onClick(View v) {
String yon;
String saniye1;
String tekrar;
int i=0,j=0,c=0,d=0;
ArrayList<String> listS=new ArrayList<String>();
try {
Scanner s=new Scanner(new File("/data/data/com.example.emrecan.myapplication/files/komutlar.txt"));
while(s.hasNextLine())
{
listS.add(s.nextLine());
}
} catch (FileNotFoundException e) {
e.printStackTrace();
}
String[] line2=new String[100];
for(String str:listS)
{
String[] line=str.split(",");
line2[c]=line;
line2[c+1]=line[i+1];
line2[c+2]=line[i+2];
c=c+3;
}
String [] line3=new String[c+2];
while(d<c)
{
line3[d]=line2[d];
d=d+1;
}
d=0;
tekrar=line3[2];
int tekrar1=Integer.parseInt(tekrar);
while(d<tekrar1)
{
while(j<=c-2)
{
yon = line3[j];
saniye1 = line3[j + 1];
sure1 = Long.parseLong(saniye1);
sure1=sure1*1000;
sure1=sure1+1000;
System.out.println(yon);
System.out.println(sure1);
System.out.println(tekrar1);
e=0;
switch (yon)
{
case "Ileri":
countdowntimer=new CountDownTimer(sure1,1000) {
@override
public void onTick(long millisUntilFinished) {
mp.start();
}
@override
public void onFinish() {
mp.stop();
Toast.makeText(getApplicationContext(),"İleri Komutu Bitti",Toast.LENGTH_LONG).show();
}
}.start();
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
break;
case "Sol":
countdowntimer2=new CountDownTimer(sure1,1000) {
@override
public void onTick(long millisUntilFinished) {
mp2.start();
}
@override
public void onFinish() {
mp2.stop();
Toast.makeText(getApplicationContext(),"Sol Komutu Bitti",Toast.LENGTH_LONG).show();
}
}.start();
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
break;
case "Sag":
countdowntimer3=new CountDownTimer(sure1,1000) {
@override
public void onTick(long millisUntilFinished) {
mp3.start();
}
@override
public void onFinish() {
mp3.stop();
Toast.makeText(getApplicationContext(),"Sag Komutu Bitti",Toast.LENGTH_LONG).show();
}
}.start();
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
break;
case "Geri":
countdowntimer4=new CountDownTimer(sure1,1000) {
@override
public void onTick(long millisUntilFinished) {
mp4.start();
}
@override
public void onFinish() {
mp4.stop();
Toast.makeText(getApplicationContext(),"Geri Komutu Bitti",Toast.LENGTH_LONG).show();
}
}.start();
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
break;
default:
Toast.makeText(getApplicationContext(), "Sıkıntı var!", Toast.LENGTH_LONG).show();
break;
}
j=j+3;
}
j=0;
d=d+1;
System.out.println('A');
}
}
});
App output:
I/System.out: Ileri
6000
1
I/System.out: Sol
11000
1
I/System.out: Sag
6000
1
I/System.out: Geri
11000
1
I/System.out: A

I solved my problem
I solved my problem by using thread.sleep(); and i'm writing here because someone might need my code.
start_btn.setOnClickListener(new View.OnClickListener() {
@override
public void onClick(View v) {
timer=new Timer();
///data/data/com.example.emrecan.myapplication/files/komutlar.txt
String yon;
String saniye1;
String tekrar;
int i=0,j=0,c=0,d=0;
ArrayList<String> listS=new ArrayList<String>();
try {
Scanner s=new Scanner(new File("/data/data/com.example.emrecan.myapplication/files/komutlar.txt"));
while(s.hasNextLine())
{
listS.add(s.nextLine());
}
} catch (FileNotFoundException e) {
e.printStackTrace();
}
String[] line2=new String[100];
for(String str:listS)
{
String[] line=str.split(",");
line2[c]=line;
line2[c+1]=line[i+1];
line2[c+2]=line[i+2];
c=c+3;
}
String [] line3=new String[c+2];
while(d<c)
{
line3[d]=line2[d];
d=d+1;
}
d=0;
tekrar=line3[2];
int tekrar1=Integer.parseInt(tekrar);
while(d<tekrar1)
{
while(j<=c-2) {
yon = line3[j];
saniye1 = line3[j + 1];
sure1 = Long.parseLong(saniye1);
sure1 = sure1 * 1000;
//sure1 = sure1 + 1000;
System.out.println(yon);
System.out.println(sure1);
System.out.println(tekrar1);
e = 0;
while (sure1>0)
{
switch (yon) {
case "Ileri":
try {
outputStream.write(1);
} catch (IOException e1) {
e1.printStackTrace();
}
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
try {
Thread.sleep(1000); //1000 milliseconds is one second.
} catch(InterruptedException ex) {
Thread.currentThread().interrupt();
}
break;
case "Sol":
try {
outputStream.write(2);
} catch (IOException e1) {
e1.printStackTrace();
}
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
try {
Thread.sleep(1000); //1000 milliseconds is one second.
} catch(InterruptedException ex) {
Thread.currentThread().interrupt();
}
break;
case "Sag":
try {
outputStream.write(3);
} catch (IOException e1) {
e1.printStackTrace();
}
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
try {
Thread.sleep(1000); //1000 milliseconds is one second.
} catch(InterruptedException ex) {
Thread.currentThread().interrupt();
}
break;
case "Geri":
mp4.start();
try {
outputStream.write(4);
} catch (IOException e1) {
e1.printStackTrace();
}
Toast.makeText(getApplicationContext(), "Komut Tamamlandı!", Toast.LENGTH_LONG).show();
try {
Thread.sleep(1000); //1000 milliseconds is one second.
} catch(InterruptedException ex) {
Thread.currentThread().interrupt();
}
break;
default:
Toast.makeText(getApplicationContext(), "Sıkıntı var!", Toast.LENGTH_LONG).show();
break;
}
sure1=sure1-1000;
}
j=j+3;
}
j=0;
d=d+1;
System.out.println('A');
}
try {
outputStream.write(10);
} catch (IOException e1) {
e1.printStackTrace();
}
}
});

Quiz error

Hello everyone! I have just made a program in Android Studio which should be a Quiz. If you could help me to find the mistake in my code I would be very grateful. Probably it's just a little mistake (as I am beginner...).
At the beginning I have created an arraylist, that does contain the strings a,b,c,d. Then, the program should make a few questions, that can be answered with Yes or No. If the user clicks the button yes, some strings are going to be removed from the Arraylist. This should happen until only one string is in the arraylist.
Here is my code:
package com.example.test;
import androidx.appcompat.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import java.util.Arrays;
import java.util.Collections;
import java.util.*;
public class MainActivity extends AppCompatActivity {
static ArrayList<String> p = new ArrayList<String>();
static Button endbutton;
static Button questionbutton;
static Button yesbutton;
static Button nobutton;
static boolean yesbuttonisclicked=false;
static boolean nobuttonisclicked=false;
@override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
endbutton = findViewById(R.id.endbutton);
questionbutton = findViewById(R.id.questionbutton);
yesbutton = findViewById(R.id.yesbutton);
nobutton = findViewById(R.id.nobutton);
p.add("a");
p.add("b");
p.add("c");
p.add("d");
yesbutton.setOnClickListener(new View.OnClickListener() {
@override
public void onClick(View v) {
yesbuttonisclicked=true;
nobuttonisclicked=false;
}
});
nobutton.setOnClickListener(new View.OnClickListener() {
@override
public void onClick(View v) {
nobuttonisclicked=true;
yesbuttonisclicked=false;
}
});
List array1 = Arrays.asList("1", "2", "3", "4");
Collections.shuffle(array1);
int i=0;
if (array1.get(i) == "1") {
questionbutton.setText("Question1");
if (yesbuttonisclicked) {
p.remove("a");
p.remove("b");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
} else {
p.remove("c");
p.remove("d");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
}
} else if (array1.get(i).equals("2")) {
questionbutton.setText("Question2");
if (yesbuttonisclicked) {
p.remove("a");
p.remove("c");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
} else {
p.remove("b");
p.remove("d");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
}
} else if (array1.get(i).equals("3")) {
questionbutton.setText("Question3");
if (yesbuttonisclicked) {
p.remove("a");
p.remove("d");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
} else {
p.remove("c");
p.remove("b");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
}
} else if (array1.get(i).equals("4")) {
questionbutton.setText("Question4");
if (yesbuttonisclicked) {
p.remove("d");
p.remove("c");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
} else {
p.remove("a");
p.remove("b");
if (p.size() == 1) {
endbutton.setText(p.get(0));
}
}
}
}
}

Download and parse xml file

Hello, I am learning to program in android and I have the following project. I need to download two XML files from the internet, these files correspond to fuel prices and the location of gas stations. The location and price come in different files, to join these files I need to identify the id of the service station and create a new file with the location and price of the fuel of each station. I am learning how to perform each of these steps. In the code that I add below I want to download a file, save it in memory and display it in TextView. The code does not work correctly, I manage to download the file but I cannot save it in memory to later show it in the Textview. The code downloads the data in the / data / folder, in order to verify that the connection is made and the data is downloaded. How can I download a file and save it in memory to later parse the XML?
Button button=(Button) findViewById(R.id.DownloadBt);
txt = (TextView) findViewById(R.id.txt);
button.setOnClickListener(this);
}
@override
public void onClick(View view){
switch (view.getId()){
case R.id.DownloadBt:
descargarPDF();
break;
}
}
void descargarPDF(){
String urlDescargarPlaces = "https://publicacionexterna.azurewebsites.net/publicaciones/places";
//String urlDescargarPrices = "https://publicacionexterna.azurewebsites.net/publicaciones/prices";
DescargarPDFAsyncTask descargarPlaces=new DescargarPDFAsyncTask("places.xml");
//DescargarPDFAsyncTask descargarPrices=new DescargarPDFAsyncTask("prices.xml");
descargarPlaces.execute(urlDescargarPlaces);
//descargarPrices.execute(urlDescargarPrices);
}
class DescargarPDFAsyncTask extends AsyncTask<String, Integer, String> {
String mFileName;
XMLParse xmlParse=new XMLParse();
DescargarPDFAsyncTask(String fileName){
mFileName=fileName;
}
@override
protected void onPreExecute(){
super.onPreExecute();
}
@override
protected String doInBackground(String... urlFichero) {
String urlADescargar=urlFichero[0];
HttpURLConnection conexion=null;
InputStream input=null;
OutputStream output=null;
try {
URL url = new URL(urlADescargar);
conexion = (HttpURLConnection) url.openConnection();
conexion.connect();
if(conexion.getResponseCode() != HttpURLConnection.HTTP_OK) {
return "Connection not successful";
}
input=conexion.getInputStream();
String rutaFicheroGuardado=getFilesDir()+ "/"+mFileName; // /data/data/com.exmaple.downloadurlfile/places.xml.
output=new FileOutputStream(rutaFicheroGuardado);
byte[] data=new byte[1024];
int count=0;
while((count=input.read(data)) >0){//!=-1;
output.write(data,0, count);
}
byteArrayStream = new ByteArrayInputStream(data);//XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
} catch (MalformedURLException ex) {
ex.printStackTrace();
return "Error: "+ ex.getMessage();
} catch (IOException ex) {
ex.printStackTrace();
return "Error: "+ex.getMessage();
} finally{
{
try {
if(input!=null) input.close();
if(output!=null) output.close();
if(conexion!=null) conexion.disconnect();
} catch (IOException e) {
e.printStackTrace();
}
}
}
return "Connection successful.";
}
@override
protected void onProgressUpdate(Integer...values){
super.onProgressUpdate(values);
}
@override
protected void onPostExecute(String mensaje){
super.onPostExecute(mensaje);
XMLParse xmlParse= new XMLParse();
xmlParse.parseXML();
Toast.makeText(getApplicationContext(),mensaje,Toast.LENGTH_LONG).show();
}
}
public class XMLParse {
StringBuilder result;
XMLParse(){
}
public void parseXML() {
XmlPullParserFactory parserFactory;
try {
parserFactory = XmlPullParserFactory.newInstance();
XmlPullParser parser = parserFactory.newPullParser();
parser.setFeature(XmlPullParser.FEATURE_PROCESS_NAMESPACES, false);
parser.setInput(byteArrayStream,null);//XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
processParsing(parser);
} catch (XmlPullParserException e) {
} catch (IOException e) {
}
}
private void processParsing(XmlPullParser parser) throws IOException, XmlPullParserException{
ArrayList<Player> players = new ArrayList<>();
int eventType = parser.getEventType();
Player currentPlayer = null;
while (eventType != XmlPullParser.END_DOCUMENT) {
String eltName = null;
switch (eventType) {
case XmlPullParser.START_TAG:
eltName = parser.getName();
if ("place".equals(eltName)) {
currentPlayer = new Player();
players.add(currentPlayer);
} else if (currentPlayer != null) {
if ("name".equals(eltName)) {
currentPlayer.name = parser.nextText();
} else if ("cre_id".equals(eltName)) {
currentPlayer.cre_id = parser.nextText();
} else if ("x".equals(eltName)) {
currentPlayer.x = parser.nextText();
} else if("y".equals(eltName)){
currentPlayer.y = parser.nextText();
}
}
break;
}
eventType = parser.next();
}
printPlayers(players);
}
private void printPlayers(ArrayList<Player> players) {
StringBuilder builder = new StringBuilder();
for (Player player : players) {
builder.append(player.name).append("\n").
append(player.cre_id).append("\n").
append(player.x).append("\n").
append(player.y).append("\n\n");
}
txt.setText(builder.toString());
}
}
}

How can I parse an xml file from external folder in android studio?

Hi,
I have the following code but it doesn't work. When I work with the assets folder (InputStream is=getAssets().open("places.xml") I have no problem.
Thanks for help me.
public class MainActivity extends AppCompatActivity {
private TextView txt;
@override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
txt = (TextView) findViewById(R.id.txt);
parseXML();
Log.e("Mensaje:","onCreate");
}
private void parseXML() {
File file = null;
file = new File("/sdcard/Download/places.xml");
if(file.exists()){
Log.e("Message:", "File exists.");
}else {
Log.e("Message:", "File does NOT exists.");
}
try {
InputStream is = new FileInputStream(file);
XmlPullParserFactory parserFactory;
parserFactory = XmlPullParserFactory.newInstance();
XmlPullParser parser = parserFactory.newPullParser();
Log.e("Inside:","TRY");
parser.setFeature(XmlPullParser.FEATURE_PROCESS_NAMESPACES, false);
parser.setInput(is, null);
processParsing(parser);
} catch (XmlPullParserException e) {
Log.e("Message:","Error1");
} catch (IOException e) {
Log.e("Message:","Error2");
}
}
private void processParsing(XmlPullParser parser) throws IOException, XmlPullParserException {
Log.e("Inside:","processParsing");
ArrayList<Player> players = new ArrayList<>();
int eventType = parser.getEventType();
Player currentPlayer = null;
while (eventType != XmlPullParser.END_DOCUMENT) {
String eltName = null;
switch (eventType) {
case XmlPullParser.START_TAG:
eltName = parser.getName();
if ("place".equals(eltName)) {
currentPlayer = new Player();
players.add(currentPlayer);
} else if (currentPlayer != null) {
if ("name".equals(eltName)) {
currentPlayer.name = parser.nextText();
} else if ("cre_id".equals(eltName)) {
currentPlayer.cre_id = parser.nextText();
} else if ("x".equals(eltName)) {
currentPlayer.x = parser.nextText();
} else if ("y".equals(eltName)) {
currentPlayer.y = parser.nextText();
}
}
break;
}
eventType = parser.next();
}
printPlayers(players);
}
private void printPlayers(ArrayList<Player> players) {
StringBuilder builder = new StringBuilder();
Log.e("Inside:","printPlayers");
for (Player player : players) {
builder.append(player.name).append("\n").
append(player.cre_id).append("\n").
append(player.x).append("\n").
append(player.y).append("\n\n");
}
txt.setText(builder.toString());
}
}