Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.ujicobaspinner;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.ArrayList;
- import android.annotation.SuppressLint;
- import android.os.Bundle;
- import android.os.StrictMode;
- import android.util.Log;
- import android.view.View;
- import android.widget.AdapterView;
- import android.widget.AdapterView.OnItemSelectedListener;
- import android.widget.ArrayAdapter;
- import android.widget.Button;
- import android.widget.EditText;
- import android.widget.Spinner;
- import android.widget.Toast;
- import androidx.appcompat.app.AppCompatActivity;
- public class MainActivity extends AppCompatActivity {
- Spinner spinner1, spinner2, spinner3;
- String ip, db, un, passwords;
- Button btnsearch;
- EditText searchdata;
- EditText edtnobarang;
- Connection connect;
- PreparedStatement stmt;
- ResultSet rs;
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- ip = "192.168.0.171";
- un = "sa";
- passwords = "arya281196";
- db = "aryaaa";
- btnsearch = (Button) findViewById(R.id.btnsearch);
- searchdata = (EditText) findViewById(R.id.searchdata);
- edtnobarang = (EditText) findViewById(R.id.edtnobarang);
- spinner1 = (Spinner) findViewById(R.id.idspinner1);
- spinner2 = (Spinner) findViewById(R.id.idspinner2);
- //spinner3 = (Spinner) findViewById(R.id.idspinner3);
- btnsearch.setOnClickListener(new View.OnClickListener() {
- @Override
- public void onClick(View v) {
- String search = searchdata.getText().toString().trim();
- setSpinner1 (search);
- setSpinner2 (search);
- }
- });
- edtnobarang.setOnFocusChangeListener(new View.OnFocusChangeListener() {
- @Override
- public void onFocusChange(View arg0, boolean hasFocus) {
- // TODO Auto-generated method stub
- if(hasFocus){
- spinner2.setVisibility(View.VISIBLE);
- }
- }
- });
- spinner1.setOnItemSelectedListener(new OnItemSelectedListener() {
- @Override
- public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
- String name = spinner1.getSelectedItem().toString();
- if(name.equals("Pintu")){
- }
- Toast.makeText(MainActivity.this, name, Toast.LENGTH_SHORT).show();
- }
- @Override
- public void onNothingSelected(AdapterView<?> parent) {
- }
- });
- spinner2.setOnItemSelectedListener(new OnItemSelectedListener() {
- @Override
- public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
- String name = spinner2.getSelectedItem().toString();
- if (name.equals("")){
- }
- Toast.makeText(MainActivity.this, name, Toast.LENGTH_SHORT).show();
- }
- @Override
- public void onNothingSelected(AdapterView<?> parent) {
- }
- });
- // spinner3.setOnItemSelectedListener(new OnItemSelectedListener() {
- // @Override
- // public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
- // String name = spinner3.getSelectedItem().toString();
- // Toast.makeText(MainActivity.this, name, Toast.LENGTH_SHORT).show();
- // }
- // @Override
- // public void onNothingSelected(AdapterView<?> parent) {
- // }
- // });
- }
- // set spinner pertama (1)
- public void setSpinner1(String kode) {
- connect = CONN(un, passwords, db, ip);
- String query1 = "select namabarang from Jenis_Barang where id = '"+kode+"' ";
- Log.e("query",""+query1);
- try {
- connect = CONN(un, passwords, db, ip);
- stmt = connect.prepareStatement(query1);
- rs = stmt.executeQuery();
- ArrayList<String> data = new ArrayList<String>();
- while (rs.next()) {
- String id = rs.getString(1);
- data.add(id);
- Log.e("idun",""+id);
- }
- String[] array = data.toArray(new String[0]);
- ArrayAdapter NoCoreAdapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, data);
- spinner1.setAdapter(NoCoreAdapter);
- } catch (Exception e) {
- e.printStackTrace();
- Log.e("errora",""+e.getMessage());
- }
- }
- //set spinner ke dua
- public void setSpinner2(String kode) {
- connect = CONN(un, passwords, db, ip);
- String query2 = "select namaitembarang from Item_Barang where id = '"+kode+"' ";
- Log.e("query",""+query2);
- try {
- connect = CONN(un, passwords, db, ip);
- stmt = connect.prepareStatement(query2);
- rs = stmt.executeQuery();
- ArrayList<String> data = new ArrayList<String>();
- while (rs.next()) {
- String id = rs.getString(1);
- data.add(id);
- }
- String[] array = data.toArray(new String[0]);
- ArrayAdapter NoCoreAdapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, data);
- spinner2.setAdapter(NoCoreAdapter);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- @SuppressLint("NewApi")
- private Connection CONN(String _user, String _pass, String _DB, String _server) {
- StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
- StrictMode.setThreadPolicy(policy);
- Connection conn = null;
- String ConnURL = null;
- try {
- Class.forName("net.sourceforge.jtds.jdbc.Driver");
- ConnURL = "jdbc:jtds:sqlserver://" + _server + ";"
- + "databaseName=" + _DB + ";user=" + _user + ";password="
- + _pass + ";";
- conn = DriverManager.getConnection(ConnURL);
- } catch (SQLException se) {
- Log.e("ERRO", se.getMessage());
- } catch (ClassNotFoundException e) {
- Log.e("ERRO", e.getMessage());
- } catch (Exception e) {
- Log.e("ERRO", e.getMessage());
- }
- return conn;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement