Android Dynamic GridView - Using MSSQL SERVER and JDBC

Download Complete Source Code of the Android Dynamic GridView with MSSQL Server

Requirements for the App

1) Android Studio.
2) Microsoft SQL Server.
3) Firewall must allow to connect to database. (or turn off firewall from control panel)
4) Download and add latest version of jtds jar file and include it in your project. See how to include jtds jar file to your project HERE.

Now,first of all create new project in android studio which will create one MainActivity.Java file and one activity_main.xml file. You need to open activity_main.xml file and paste the below code.

activity_main.xml file:

<TextView android:layout_width="match_parent" android:layout_height="wrap_content" android:id="@+id/Textvv" android:paddingTop="20dp" android:paddingBottom="20dp" android:gravity="center" android:textSize="20sp" android:textStyle="bold" android:text="My GridView App Using MSSQL+JDBC"/> <GridView android:layout_width="match_parent" android:layout_height="match_parent" android:layout_centerHorizontal="true" android:layout_below="@+id/Textvv" android:clickable="true" android:columnWidth="100dip" android:gravity="center" android:horizontalSpacing="10dip" android:numColumns="3" android:stretchMode="spacingWidthUniform" android:verticalSpacing="10dip" android:id="@+id/gridView" />

Now, Create a new file under layout, named as list_content.xml file and paste following code into it.

list_content.xml

<ImageView android:layout_width="60dp" android:layout_height="60dp" app:srcCompat="@mipmap/ic_launcher" android:id="@+id/imageView" /> <TextView android:text="menu name" android:layout_width="wrap_content" android:layout_height="wrap_content" android:id="@+id/textName" android:textSize="14sp" android:maxLength="30" android:textColor="@color/colorPrimary" android:layout_below="@+id/imageView" android:layout_alignParentLeft="true" android:layout_alignParentStart="true" />

Now, Create a class under java and name it as ClassListItems and paste following code into it.

ClassListItems.java

public class ClassListItems { public String img; //Image URL public String name; //Name public ClassListItems(String name, String img) { this.img = img; this.name = name; } public String getImg() { return img; } public String getName() { return name; } }

Now, you need to download a file named as jtds 1.2.7 as I discussed and gave link earlier. Add that file into your project if you have not added so far. After adding that file

Open your AndroidManifest.xml file and add the following permission

AndroidManifest.xml

<uses-permission android:name="android.permission.INTERNET"/>

Now, Open build app module and add thes two lines there:

build.gradle (Module:app)

compile project(':jtds-1.2.7') //To be added for connection compile 'com.squareup.picasso:picasso:2.5.2'} //To be added to load image into GridView using url

Now, Create another java file named as ConnectionClass under your java folder:

ConnectionClass.java

public class ConnectionClass { // Change below settings as per your database ip and credentials String ip = "182.50.144.108"; // if you have to add port then it would be like .i.e. 182.50.133.109:1433 String db = "DatabaseTest"; //Name of Database String un = "saadmin"; //Database user String password = "123456789"; //Database Password @SuppressLint("NewApi") public Connection CONN() { 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://" + ip + ";" + "databaseName=" + db + ";user=" + un + ";password=" + password + ";"; 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; } }

Now, Open your MainActivity.java File and add the code below into that file:

MainActivity.java

public class MainActivity extends AppCompatActivity { private ArrayList<ClassListItems> itemArrayList; //List items Array private MyAppAdapter myAppAdapter; //Array Adapter private GridView gridView; // GridView private boolean success = false; // boolean private ConnectionClass connectionClass; //Connection Class Variable @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); gridView = (GridView) findViewById(R.id.gridView); //GridView Declaration connectionClass = new ConnectionClass(); // Connection Class Initialization itemArrayList = new ArrayList<ClassListItems>(); // Arraylist Initialization // Calling Async Task SyncData orderData = new SyncData(); orderData.execute(""); } // Async Task has three overrided methods, private class SyncData extends AsyncTask<String, String, String> { String msg = "Internet/DB_Credentials/Windows_FireWall_TurnOn Error, See Android Monitor in the bottom For details!"; ProgressDialog progress; @Override protected void onPreExecute() //Starts the progress dailog { progress = ProgressDialog.show(MainActivity.this, "Synchronising", "GridView Loading! Please Wait...", true); } @Override protected String doInBackground(String... strings) // Connect to the database, write query and add items to array list { try { Connection conn = connectionClass.CONN(); //Connection Object if (conn == null) { success = false; } else { // Change below query according to your own database. String query = "SELECT name,url FROM MainTable"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(query); if (rs != null) // if resultset not null, I add items to itemArraylist using class created { while (rs.next()) { try { itemArrayList.add(new ClassListItems(rs.getString("name"),rs.getString("url"))); } catch (Exception ex) { ex.printStackTrace(); } } msg = "Found"; success = true; } else { msg = "No Data found!"; success = false; } } } catch (Exception e) { e.printStackTrace(); Writer writer = new StringWriter(); e.printStackTrace(new PrintWriter(writer)); msg = writer.toString(); success = false; } return msg; } @Override protected void onPostExecute(String msg) // disimissing progress dialoge, showing error and setting up my GridView { progress.dismiss(); Toast.makeText(MainActivity.this, msg + "", Toast.LENGTH_LONG).show(); if (success == false) { } else { try { myAppAdapter = new MyAppAdapter(itemArrayList, MainActivity.this); gridView.setChoiceMode(GridView.CHOICE_MODE_MULTIPLE); gridView.setAdapter(myAppAdapter); } catch (Exception ex) { } } } } public class MyAppAdapter extends BaseAdapter //has a class viewholder which holds { public class ViewHolder { TextView textName; ImageView imageView; } public List<ClassListItems> parkingList; public Context context; ArrayList<ClassListItems> arraylist; private MyAppAdapter(List<ClassListItems> apps, Context context) { this.parkingList = apps; this.context = context; arraylist = new ArrayList<ClassListItems>(); arraylist.addAll(parkingList); } @Override public int getCount() { return parkingList.size(); } @Override public Object getItem(int position) { return position; } @Override public long getItemId(int position) { return position; } @Override public View getView(final int position, View convertView, ViewGroup parent) // inflating the layout and initializing widgets { View rowView = convertView; ViewHolder viewHolder= null; if (rowView == null) { LayoutInflater inflater = getLayoutInflater(); rowView = inflater.inflate(R.layout.list_content, parent, false); viewHolder = new ViewHolder(); viewHolder.textName = (TextView) rowView.findViewById(R.id.textName); viewHolder.imageView = (ImageView) rowView.findViewById(R.id.imageView); rowView.setTag(viewHolder); } else { viewHolder = (ViewHolder) convertView.getTag(); } // here setting up names and images viewHolder.textName.setText(parkingList.get(position).getName()+""); Picasso.with(context).load("http://"+parkingList.get(position).getImg()).into(viewHolder.imageView); return rowView; } } }

Screenshots of the App :