How to create stored procedure in MS SQL database server and run (call) it from your Android App? скачать в хорошем качестве

How to create stored procedure in MS SQL database server and run (call) it from your Android App?

This video shows the complete end to end steps to create a simple stored procedure in MS SQL server and call the same from the Android App. In the first part of the video it shows how to create a simple stored procedure using MS SQL Server Management Studio (SSMS). It uses a test table to create procedure. It then tests the Stored procedure by framing the respective EXECUTE query to call the stored procedure. In the second part, it shows how to create a simple Android App to call the stored procedure on the MS SQL Server through TCP/IP connection. It uses the concepts shown in the part-1 of this video - How to connect to MS SQL Server database from your Android App? Link below: https://programmerworld.co/android/ho... In the Android App, it uses a very simple layout to display the output (that is the number of row count received). It also shows the relevant permissions needed to be granted in Manifest file and the gradle file update with the required implementation. I hope you liked this video, for any questions, suggestions or appreciation please contact us at: https://programmerworld.co/contact/ or email at: programmerworld1990@gmail.com The complete source code of this video is shared at the link below: https://programmerworld.co/android/ho... However, Java part of the code is available below for reference: package com.programmerworld.mssqlstoredprocedureapp; import androidx.appcompat.app.AppCompatActivity; import androidx.core.app.ActivityCompat; import android.Manifest; import android.content.pm.PackageManager; import android.os.Bundle; import android.os.StrictMode; import android.view.View; import android.widget.TextView; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Types; public class MainActivity extends AppCompatActivity { private TextView textView; private static String ip = "192.168.1.137"; private static String port = "1433"; private static String Classes = "net.sourceforge.jtds.jdbc.Driver"; private static String database = "testDatabase"; private static String username = "test"; private static String password = "test"; private static String url = "jdbc:jtds:sqlserver://"+ip+":"+port+"/"+database; private Connection connection = null; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); ActivityCompat.requestPermissions(this, new String[]{Manifest.permission.INTERNET}, PackageManager.PERMISSION_GRANTED); textView = findViewById(R.id.textView); StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build(); StrictMode.setThreadPolicy(policy); try { Class.forName(Classes); connection = DriverManager.getConnection(url, username,password); textView.setText("SUCCESS"); } catch (ClassNotFoundException e) { e.printStackTrace(); textView.setText("ERROR"); } catch (SQLException e) { e.printStackTrace(); textView.setText("FAILURE"); } } public void buttonMS_SQL_StoredProcedure(View view){ if (connection == null){ textView.setText("SQL Query Failed"); return; } try { CallableStatement callableStatement = connection.prepareCall("{call TestSP(?,?)}"); callableStatement.setInt(1, 2); callableStatement.registerOutParameter(2, Types.INTEGER); callableStatement.execute(); callableStatement.getMoreResults(); int intOutput = callableStatement.getInt(2); textView.setText(Integer.toString(intOutput)); callableStatement.close(); } catch (SQLException e) { e.printStackTrace(); } } }