{"id":20486,"date":"2018-01-17T16:15:56","date_gmt":"2018-01-17T14:15:56","guid":{"rendered":"http:\/\/www.webcodegeeks.com\/?p=20486"},"modified":"2018-01-16T10:34:56","modified_gmt":"2018-01-16T08:34:56","slug":"angularjs-sql-example","status":"publish","type":"post","link":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/","title":{"rendered":"AngularJS with SQL Example"},"content":{"rendered":"<p>Hello readers, in this basic example, developers will learn what <strong>AngularJS<\/strong> is and how to make a simple angular application to interact with the database.<\/p>\n<h2>1. Introduction<\/h2>\n<h3>1.1 What is AngularJS?<\/h3>\n<p><em>AngularJS<\/em> is a JavaScript MVC or Model-View-Controller framework developed by Google that lets developers build well structured, easily testable, and maintainable front-end applications. Before we start with creating an actual application using AngularJS, let us see what the actual parts of an AngularJS application are.<br \/>\n[ulp id=&#8217;LXJcMJZXSsqGXYW8&#8242;]<\/p>\n<h4>1.1.1 Templates<\/h4>\n<p>In AngularJS, a <span style=\"text-decoration: underline;\">template<\/span> is an <code>HTML<\/code> with additional markups. AngularJS library compiles the templates and renders the resultant <code>HTML<\/code> page.<\/p>\n<h4>1.1.2 Directives<\/h4>\n<p><span style=\"text-decoration: underline;\">Directives<\/span> are the markers (i.e. attributes) on a DOM element that tell AngularJS to attach a specific behavior to that DOM element or even transform the DOM element and its children. Most of the directives in AngularJS library starts with the <code>ng<\/code>. The directives consist of the following three parts:<\/p>\n<ul>\n<li><code>ng-app<\/code>: The <code>ng-app<\/code> directive is a <em>starting point<\/em>. If the AngularJS framework finds the <code>ng-app<\/code> directive anywhere in the <code>HTML<\/code> document, it bootstraps (i.e. initializes) itself and compiles the <code>HTML<\/code> template<\/li>\n<li><code>ng-model<\/code>: The <code>ng-model<\/code> directive binds an <code>HTML<\/code> element to a property on the <code>$scope<\/code> object. It also binds the values of AngularJS application data to the <code>HTML<\/code> input controls.<\/li>\n<li><code>ng-bind<\/code>: The <code>ng-bind<\/code> directive binds the AngularJS application data to the <code>HTML<\/code> tags<\/li>\n<li><code>ng-controller<\/code>: The <code>ng-controller<\/code> directive is used to specify a controller in the <code>HTML<\/code> element. This controller will add behavior or maintain the data in that <code>HTML<\/code> element and its child elements<\/li>\n<\/ul>\n<h4>1.1.3 Expressions<\/h4>\n<p>An <span style=\"text-decoration: underline;\">expression<\/span> is like a JavaScript code which is usually wrapped inside the double curly braces such as <code>{{ expression }}<\/code>. AngularJS library evaluates the expression and produces a result.<\/p>\n<p>The following table lists all the important concepts in AngularJS library.<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Concept<\/strong><\/th>\n<th><strong>Description<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Template<\/strong><\/td>\n<td>An <code>HTML<\/code> with additional markups.<\/td>\n<\/tr>\n<tr>\n<td><strong>Directives<\/strong><\/td>\n<td>Extend the <code>HTML<\/code> with the custom attributes (or markers) and elements.<\/td>\n<\/tr>\n<tr>\n<td><strong>Model<\/strong><\/td>\n<td>It is the data shown to the user in the view with which the user interacts.<\/td>\n<\/tr>\n<tr>\n<td><strong>Scope<\/strong><\/td>\n<td>A Scope is a context where the model is stored so that controllers, directives, and expressions can access it.<\/td>\n<\/tr>\n<tr>\n<td><strong>Expressions<\/strong><\/td>\n<td>An expression executes the JavaScript code inside the double curly braces such as <code>{{ expression }}<\/code>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Compiler<\/strong><\/td>\n<td>The Compiler parses the template and instantiates the directives and expressions.<\/td>\n<\/tr>\n<tr>\n<td><strong>Filter<\/strong><\/td>\n<td>A Filter formats the value of an expression for display to the user.<\/td>\n<\/tr>\n<tr>\n<td><strong>Data Binding<\/strong><\/td>\n<td>This syncs the data between the model and the view.<\/td>\n<\/tr>\n<tr>\n<td><strong>Controller<\/strong><\/td>\n<td>The controller in AngularJS maintains the application data, business logic, and behavior using the <code>$scope<\/code> object. Developers can attach properties and methods to the <code>$scope<\/code> object inside a controller function, which in turn will add or update the data and attach behaviors to the <code>HTML<\/code> elements.<\/td>\n<\/tr>\n<tr>\n<td><strong>Module<\/strong><\/td>\n<td>A module is the container for different parts of an application including the controllers, services, filters, and directives which configures the Injector.<\/td>\n<\/tr>\n<tr>\n<td><strong>Service<\/strong><\/td>\n<td>A Service is reusable business logic which is independent of the views.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>1.2 Why should we use AngularJS?<\/h3>\n<p>Using the Model-View-Controller architecture, the framework separates a web application into a simple and yet manageable structure, which comprises of \u201cviews\u201d, \u201cmodels\u201d and \u201ccontrollers\u201d. The AngularJS library provides the in-build directives (or attributes) to extend the <code>HTML<\/code> inside a web page. When developers attach these directives to the <code>HTML<\/code> elements and attributes, it creates a dynamic web-page with very little coding.<\/p>\n<p>These new APIs make a developer life easier, really! But it would be difficult for a beginner to understand this without an example. Therefore, let\u2019s see how to integrate AngularJS with <code>SQL<\/code> in Java web applications.<\/p>\n<h2>2. AngularJS with SQL Example<\/h2>\n<p>Here is a step-by-step guide for implementing the AngularJS framework in Java.<\/p>\n<h3>2.1 Tools Used<\/h3>\n<p>We are using Eclipse Kepler SR2, JDK 8, MySQL database, and Maven. Having said that, we have tested the code against JDK 1.7 and it works well.<\/p>\n<h3>2.2 Project Structure<\/h3>\n<p>Firstly, let\u2019s review the final project structure, in case you are confused about where you should create the corresponding files or folder later!<\/p>\n<figure id=\"attachment_20487\" aria-describedby=\"caption-attachment-20487\" style=\"width: 307px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_structure_guide_1_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20487\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_structure_guide_1_new-1.jpg\" alt=\"Fig. 1: Application Project Structure\" width=\"307\" height=\"508\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_structure_guide_1_new-1.jpg 307w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_structure_guide_1_new-1-181x300.jpg 181w\" sizes=\"(max-width: 307px) 100vw, 307px\" \/><\/a><figcaption id=\"caption-attachment-20487\" class=\"wp-caption-text\">Fig. 1: Application Project Structure<\/figcaption><\/figure>\n<h3>2.3 Project Creation<\/h3>\n<p>This section will demonstrate on how to create a Java-based Maven project with Eclipse. In Eclipse Ide, go to <code>File -&gt; New -&gt; Maven Project<\/code>.<\/p>\n<figure id=\"attachment_20488\" aria-describedby=\"caption-attachment-20488\" style=\"width: 657px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_1_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20488\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_1_new-1.jpg\" alt=\"Fig. 2: Create Maven Project\" width=\"657\" height=\"690\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_1_new-1.jpg 657w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_1_new-1-286x300.jpg 286w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><figcaption id=\"caption-attachment-20488\" class=\"wp-caption-text\">Fig. 2: Create Maven Project<\/figcaption><\/figure>\n<p>In the New Maven Project window, it will ask you to select project location. By default, &#8216;Use default workspace location&#8217; will be selected. Just click on next button to proceed.<\/p>\n<figure id=\"attachment_20489\" aria-describedby=\"caption-attachment-20489\" style=\"width: 598px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_2_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20489\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_2_new-1.jpg\" alt=\"Fig. 3: Project Details\" width=\"598\" height=\"543\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_2_new-1.jpg 598w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_2_new-1-300x272.jpg 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/a><figcaption id=\"caption-attachment-20489\" class=\"wp-caption-text\">Fig. 3: Project Details<\/figcaption><\/figure>\n<p>Select the &#8216;Maven Web App&#8217; Archetype from the list of options and click next.<\/p>\n<figure id=\"attachment_20490\" aria-describedby=\"caption-attachment-20490\" style=\"width: 601px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_3_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20490\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_3_new-1.jpg\" alt=\"Fig. 4: Archetype Selection\" width=\"601\" height=\"539\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_3_new-1.jpg 601w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_3_new-1-300x269.jpg 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/a><figcaption id=\"caption-attachment-20490\" class=\"wp-caption-text\">Fig. 4: Archetype Selection<\/figcaption><\/figure>\n<p>It will ask you to &#8216;Enter the group and the artifact id for the project&#8217;. We will input the details as shown in the below image. The version number will be by default: <code>0.0.1-SNAPSHOT<\/code>.<\/p>\n<figure id=\"attachment_20491\" aria-describedby=\"caption-attachment-20491\" style=\"width: 599px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_4_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20491\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_4_new-1.jpg\" alt=\"Fig. 5: Archetype Parameters\" width=\"599\" height=\"540\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_4_new-1.jpg 599w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_4_new-1-300x270.jpg 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/a><figcaption id=\"caption-attachment-20491\" class=\"wp-caption-text\">Fig. 5: Archetype Parameters<\/figcaption><\/figure>\n<p>Click on Finish and the creation of a maven project is completed. If you observe, it has downloaded the maven dependencies and a <code>pom.xml<\/code> file will be created. It will have the following code:<\/p>\n<p><span style=\"text-decoration: underline;\"><em>pom.xml<\/em><\/span><\/p>\n<pre class=\"brush:xml; wrap-lines:false;\">&lt;project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd\"&gt;\r\n\t&lt;modelVersion&gt;4.0.0&lt;\/modelVersion&gt;\r\n\t&lt;groupId&gt;AngularJsSqlEx&lt;\/groupId&gt;\r\n\t&lt;artifactId&gt;AngularJsSqlEx&lt;\/artifactId&gt;\r\n\t&lt;version&gt;0.0.1-SNAPSHOT&lt;\/version&gt;\r\n\t&lt;packaging&gt;war&lt;\/packaging&gt;\r\n&lt;\/project&gt;\r\n<\/pre>\n<p>Let\u2019s start building the application!<\/p>\n<h2>3. Application Building<\/h2>\n<p>Below are the steps involved in developing this application.<\/p>\n<h3>3.1 Database &amp; Table Creation<\/h3>\n<p>The following MySQL script is used to create a database called <code>servletDb<\/code> with table: <code>employeetbl<\/code>. Open MySQL Workbench and execute the <code>SQL<\/code>script to create a sample database table for this tutorial.<\/p>\n<pre class=\"brush:sql; wrap-lines:false;\">CREATE DATABASE servletDb;\r\n\r\nCREATE TABLE employeetbl (\r\n        e_id INT NOT NULL AUTO_INCREMENT,\r\n        e_name VARCHAR(100),\r\n        e_email VARCHAR(200),\r\n        e_gender VARCHAR(100),\r\n        PRIMARY KEY (e_id)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO employeetbl (e_id, e_name, e_email, e_gender) VALUES (100, 'Severus', 'severus.snape@hogwarts.com', 'F');\r\nINSERT INTO employeetbl (e_id, e_name, e_email, e_gender) VALUES (101, 'Harry', 'harry.potter@hogwarts.com', 'M');\r\nINSERT INTO employeetbl (e_id, e_name, e_email, e_gender) VALUES (102, 'April', 'april.o.neil@gmail.com', 'F');\r\nINSERT INTO employeetbl (e_id, e_name, e_email, e_gender) VALUES (103, 'Daniel', 'daniel.atlas@eye.com', 'M');\r\nINSERT INTO employeetbl (e_id, e_name, e_email, e_gender) VALUES (104, 'Albus', 'albus.dumbledore@hogwarts.com', 'M');\r\nINSERT INTO employeetbl (e_id, e_name, e_email, e_gender) VALUES (105, 'Hermione', 'hermione.granger@hogwarts.com', 'F');\r\n\r\nSELECT * FROM employeetbl;\r\n<\/pre>\n<h3>3.2 Maven Dependencies<\/h3>\n<p>Here, we specify the dependencies for the Servlet, MySQL, and JSON API. The rest dependencies will be automatically resolved by the Maven framework and the <strong>updated<\/strong> file will have the following code:<\/p>\n<p><span style=\"text-decoration: underline;\"><em>pom.xml<\/em><\/span><\/p>\n<pre class=\"brush:xml; wrap-lines:false;\">&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;\r\n&lt;project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/maven-v4_0_0.xsd\"&gt;\r\n    &lt;modelVersion&gt;4.0.0&lt;\/modelVersion&gt;\r\n    &lt;groupId&gt;AngularJsSqlEx&lt;\/groupId&gt;\r\n    &lt;artifactId&gt;AngularJsSqlEx&lt;\/artifactId&gt;\r\n    &lt;packaging&gt;war&lt;\/packaging&gt;\r\n    &lt;version&gt;0.0.1-SNAPSHOT&lt;\/version&gt;\r\n    &lt;name&gt;AngularJsSqlEx Maven Webapp&lt;\/name&gt;\r\n    &lt;url&gt;http:\/\/maven.apache.org&lt;\/url&gt;\r\n    &lt;dependencies&gt;\r\n        &lt;!-- Servlet Api Dependency --&gt;\r\n        &lt;dependency&gt;\r\n            &lt;groupId&gt;javax.servlet&lt;\/groupId&gt;\r\n            &lt;artifactId&gt;javax.servlet-api&lt;\/artifactId&gt;\r\n            &lt;version&gt;3.0.1&lt;\/version&gt;\r\n        &lt;\/dependency&gt;\r\n        &lt;dependency&gt;\r\n            &lt;groupId&gt;javax.servlet.jsp&lt;\/groupId&gt;\r\n            &lt;artifactId&gt;jsp-api&lt;\/artifactId&gt;\r\n            &lt;version&gt;2.1&lt;\/version&gt;\r\n        &lt;\/dependency&gt;\r\n        &lt;!-- AngularJs Json Dependency --&gt;\r\n        &lt;dependency&gt;\r\n            &lt;groupId&gt;org.json&lt;\/groupId&gt;\r\n            &lt;artifactId&gt;json&lt;\/artifactId&gt;\r\n            &lt;version&gt;20160810&lt;\/version&gt;\r\n        &lt;\/dependency&gt;\r\n        &lt;dependency&gt;\r\n            &lt;groupId&gt;com.google.code.gson&lt;\/groupId&gt;\r\n            &lt;artifactId&gt;gson&lt;\/artifactId&gt;\r\n            &lt;version&gt;2.8.0&lt;\/version&gt;\r\n        &lt;\/dependency&gt;\r\n        &lt;!-- MySql Connector Dependency --&gt;\r\n        &lt;dependency&gt;\r\n            &lt;groupId&gt;mysql&lt;\/groupId&gt;\r\n            &lt;artifactId&gt;mysql-connector-java&lt;\/artifactId&gt;\r\n            &lt;version&gt;5.1.41&lt;\/version&gt;\r\n        &lt;\/dependency&gt;\r\n        &lt;!-- Java Jstl Dependency --&gt;\r\n        &lt;dependency&gt;\r\n            &lt;groupId&gt;jstl&lt;\/groupId&gt;\r\n            &lt;artifactId&gt;jstl&lt;\/artifactId&gt;\r\n            &lt;version&gt;1.2&lt;\/version&gt;\r\n        &lt;\/dependency&gt;\r\n    &lt;\/dependencies&gt;\r\n    &lt;build&gt;\r\n        &lt;finalName&gt;${project.artifactId}&lt;\/finalName&gt;\r\n    &lt;\/build&gt;\r\n&lt;\/project&gt;\r\n<\/pre>\n<h3>3.3 Java Class Creation<\/h3>\n<p>Let\u2019s create the required Java files. Right-click on <code>src\/main\/java<\/code> folder, <code>New -&gt; Package<\/code>.<\/p>\n<figure id=\"attachment_20492\" aria-describedby=\"caption-attachment-20492\" style=\"width: 682px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_5_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20492\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_5_new-1.jpg\" alt=\"Fig. 6: Java Package Creation\" width=\"682\" height=\"393\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_5_new-1.jpg 682w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_5_new-1-300x173.jpg 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><figcaption id=\"caption-attachment-20492\" class=\"wp-caption-text\">Fig. 6: Java Package Creation<\/figcaption><\/figure>\n<p>A new pop window will open where we will enter the package name as: <code>com.jcg.java<\/code>.<\/p>\n<figure id=\"attachment_20493\" aria-describedby=\"caption-attachment-20493\" style=\"width: 519px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_6_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20493\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_6_new-1.jpg\" alt=\"Fig. 7: Java Package Name (com.jcg.java)\" width=\"519\" height=\"423\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_6_new-1.jpg 519w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_6_new-1-300x245.jpg 300w\" sizes=\"(max-width: 519px) 100vw, 519px\" \/><\/a><figcaption id=\"caption-attachment-20493\" class=\"wp-caption-text\">Fig. 7: Java Package Name (com.jcg.java)<\/figcaption><\/figure>\n<p>Once the package is created in the application, we will need to create the servlet controller, model, and the database interaction classes. Right-click on the newly created package: <code>New -&gt; Class<\/code>.<\/p>\n<figure id=\"attachment_20494\" aria-describedby=\"caption-attachment-20494\" style=\"width: 691px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_7_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20494\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_7_new-1.jpg\" alt=\"Fig. 8: Java Class Creation\" width=\"691\" height=\"364\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_7_new-1.jpg 691w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_7_new-1-300x158.jpg 300w\" sizes=\"(max-width: 691px) 100vw, 691px\" \/><\/a><figcaption id=\"caption-attachment-20494\" class=\"wp-caption-text\">Fig. 8: Java Class Creation<\/figcaption><\/figure>\n<p>A new pop window will open and enter the file name as: <code>Employee<\/code>. The model (i.e. <code>POJO<\/code>) class will be created inside the package: <code>com.jcg.java<\/code>.<\/p>\n<figure id=\"attachment_20495\" aria-describedby=\"caption-attachment-20495\" style=\"width: 535px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_8_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20495\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_8_new-1.jpg\" alt=\"Fig. 9: Java Class (Employee.java)\" width=\"535\" height=\"628\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_8_new-1.jpg 535w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_8_new-1-256x300.jpg 256w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><figcaption id=\"caption-attachment-20495\" class=\"wp-caption-text\">Fig. 9: Java Class (Employee.java)<\/figcaption><\/figure>\n<p>Repeat the step (i.e. Fig. 7) and enter the filename as: <code>EmployeeServlet<\/code>. The servlet controller class will be created inside the package: <code>com.jcg.java<\/code>.<\/p>\n<figure id=\"attachment_20496\" aria-describedby=\"caption-attachment-20496\" style=\"width: 535px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_9_new.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20496\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_9_new.jpg\" alt=\"Fig. 10: Java Class (EmployeeServlet.java)\" width=\"535\" height=\"629\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_9_new.jpg 535w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_9_new-255x300.jpg 255w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><figcaption id=\"caption-attachment-20496\" class=\"wp-caption-text\">Fig. 10: Java Class (EmployeeServlet.java)<\/figcaption><\/figure>\n<p>Again repeat the step listed in Fig. 7 and enter the file name as: <code>MyDb<\/code>. The database interaction class will be created inside the package: <code>com.jcg.java<\/code><\/p>\n<figure id=\"attachment_20497\" aria-describedby=\"caption-attachment-20497\" style=\"width: 535px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_10_new.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20497\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_10_new.jpg\" alt=\"Fig. 11: Java Class (MyDb.java)\" width=\"535\" height=\"629\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_10_new.jpg 535w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_guide_10_new-255x300.jpg 255w\" sizes=\"(max-width: 535px) 100vw, 535px\" \/><\/a><figcaption id=\"caption-attachment-20497\" class=\"wp-caption-text\">Fig. 11: Java Class (MyDb.java)<\/figcaption><\/figure>\n<h4>3.3.1 Implementation of Model Class<\/h4>\n<p>This class is used to map the model attributes with the <code>SQL<\/code> column names. Let\u2019s see the simple code snippet that follows this implementation.<\/p>\n<p><span style=\"text-decoration: underline;\"><em>Employee.java<\/em><\/span><\/p>\n<pre class=\"brush:java; wrap-lines:false;\">package com.jcg.java;\r\n\r\npublic class Employee {\r\n\r\n\tpublic int emp_id;\r\n\tpublic String emp_name, emp_email, emp_gender;\r\n\r\n\tpublic Employee() {}\r\n\r\n\tpublic Employee(int id, String name, String email, String gender) {\r\n\t\tthis.emp_id = id;\r\n\t\tthis.emp_name = name;\r\n\t\tthis.emp_gender = gender;\r\n\t\tthis.emp_email = email;\r\n\t}\r\n\r\n\tpublic int getEmp_id() {\r\n\t\treturn emp_id;\r\n\t}\r\n\r\n\tpublic void setEmp_id(int emp_id) {\r\n\t\tthis.emp_id = emp_id;\r\n\t}\r\n\r\n\tpublic String getEmp_name() {\r\n\t\treturn emp_name;\r\n\t}\r\n\r\n\tpublic void setEmp_name(String emp_name) {\r\n\t\tthis.emp_name = emp_name;\r\n\t}\r\n\r\n\tpublic String getEmp_email() {\r\n\t\treturn emp_email;\r\n\t}\r\n\r\n\tpublic void setEmp_email(String emp_email) {\r\n\t\tthis.emp_email = emp_email;\r\n\t}\r\n\r\n\tpublic String getEmp_gender() {\r\n\t\treturn emp_gender;\r\n\t}\r\n\r\n\tpublic void setEmp_gender(String emp_gender) {\r\n\t\tthis.emp_gender = emp_gender;\r\n\t}\r\n}\r\n<\/pre>\n<h4>3.3.2 Implementation of Servlet Controller<\/h4>\n<p>This is a normal Java servlet except the part that it reads the employee list from the database and display it on the angular view. Let\u2019s see the simple code snippet that follows this implementation.<\/p>\n<p><span style=\"text-decoration: underline;\"><em>EmployeeServlet.java<\/em><\/span><\/p>\n<pre class=\"brush:java; wrap-lines:false;\">package com.jcg.java;\r\n\r\nimport java.io.IOException;\r\nimport java.util.List;\r\n\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.annotation.WebServlet;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\n\r\nimport org.json.JSONArray;\r\n\r\nimport com.google.gson.Gson;\r\n\r\n@WebServlet(\"\/employeeServlet\")\r\npublic class EmployeeServlet extends HttpServlet {\r\n\r\n\tprivate static final long serialVersionUID = 1L;\r\n\r\n\t\/***** This Method Is Called By The Servlet Container To Process A 'GET' Request. *****\/\r\n\tpublic void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException {\r\n\t\thandleRequest(req, resp);\r\n\t}\r\n\r\n\tpublic void handleRequest(HttpServletRequest req, HttpServletResponse resp) throws ServletException {\r\n\r\n\t\tJSONArray arrayObj = null;\r\n\t\tList empList = null;\r\n\t\ttry {\r\n\r\n\t\t\t\/***** Fetching Employee Records From The Database *****\/\r\n\t\t\tempList = MyDb.getEmployeeListFromDb();\r\n\t\t\tif(empList != null &amp;&amp; empList.size() &gt; 0) {\t\t\t\t\r\n\t\t\t\tSystem.out.println(\"Total Employee Records Fetch From Db Are?= \" + empList.size());\r\n\t\t\t} else {\r\n\t\t\t\tSystem.out.println(\"No Employee Records Are Present In Db\");\r\n\t\t\t}\r\n\r\n\t\t\tarrayObj = new JSONArray(empList);\r\n\t\t\tString jObj = new Gson().toJson(arrayObj);\r\n\r\n\t\t\t\/***** Preparing The Output Response *****\/\r\n\t\t\tresp.setContentType(\"text\/html\");\r\n\t\t\tresp.setCharacterEncoding(\"UTF-8\");\r\n\t\t\tresp.getWriter().write(jObj);\r\n\t\t} catch (IOException ex) {\r\n\t\t\tex.printStackTrace();\r\n\t\t}\r\n\t}\r\n}\r\n<\/pre>\n<h4>3.3.3 Implementation of Db Utility Controller<\/h4>\n<p>This class helps in interacting with the database to perform the <code>SELECT<\/code> operation (i.e. to fetch the records to the database). Let\u2019s see the simple code snippet that follows this implementation.<\/p>\n<p><span style=\"text-decoration: underline;\"><em>MyDb.java<\/em><\/span><\/p>\n<pre class=\"brush:java; wrap-lines:false;\">package com.jcg.java;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\nimport java.util.ArrayList;\r\nimport java.util.List;\r\n\r\npublic class MyDb {\r\n\r\n\tstatic ResultSet rsObj = null;\r\n\tstatic Statement stmtObj = null;\r\n\tstatic Connection connObj = null;\r\n\r\n\t\/***** Method #1 :: This Method Is Used To Create A Connection With The Database *****\/\r\n\tprivate static Connection connectDb() {\r\n\t\tString connUrl = \"jdbc:mysql:\/\/localhost:3306\/servletDb\",\r\n\t\t\t\tconnName = \"&lt;!-- Db Username --&gt;\", connPwd = \"&lt;!-- Db Password --&gt;\";\r\n\t\ttry {\r\n\t\t\tClass.forName(\"com.mysql.jdbc.Driver\");\r\n\t\t\tconnObj = DriverManager.getConnection(connUrl, connName, connPwd);\t\t\t\r\n\t\t} catch (Exception exObj) {\r\n\t\t\texObj.printStackTrace();\r\n\t\t}\r\n\t\treturn connObj;\r\n\t}\r\n\r\n\t\/***** Method #2 :: This Method Is Used To Retrieve The Records From The Database *****\/\r\n\tpublic static List&lt;Employee&gt; getEmployeeListFromDb() {\t\t\r\n\t\tEmployee emp = null;\r\n\t\tList&lt;Employee&gt; eList = new ArrayList&lt;Employee&gt;();\r\n\t\ttry {\r\n\t\t\tstmtObj = connectDb().createStatement();\r\n\r\n\t\t\tString sql = \"SELECT * FROM servletDb.EmployeeTbl\";\r\n\t\t\trsObj = stmtObj.executeQuery(sql);\r\n\t\t\twhile(rsObj.next()) {\r\n\t\t\t\temp = new Employee(rsObj.getInt(\"e_id\"), rsObj.getString(\"e_name\"), rsObj.getString(\"e_email\"), rsObj.getString(\"e_gender\"));\r\n\t\t\t\teList.add(emp);\r\n\t\t\t}\r\n\t\t} catch (SQLException sqlExObj) {\r\n\t\t\tsqlExObj.printStackTrace();\r\n\t\t} finally {\r\n\t\t\tdisconnectDb();\r\n\t\t}\r\n\t\treturn eList;\r\n\t}\r\n\r\n\t\/***** Method #3 :: This Method Is Used To Close The Connection With The Database *****\/\r\n\tpublic static void disconnectDb() {\r\n\t\ttry {\r\n\t\t\trsObj.close();\r\n\t\t\tstmtObj.close();\r\n\t\t\tconnObj.close();\r\n\t\t} catch (SQLException sqlExObj) {\r\n\t\t\tsqlExObj.printStackTrace();\r\n\t\t}\t\t\r\n\t}\r\n}\r\n<\/pre>\n<p>Do remember, to change the database username and password as per the application\u2019s database configuration.<\/p>\n<h3>3.3 Creating JSP View<\/h3>\n<p>This file is responsible for the <em>AJAX<\/em> call made to the servlet and for updating the response back in the <code>JSP<\/code>. Let\u2019s see the simple code snippet to create a simple view using the angular framework.<\/p>\n<p><span style=\"text-decoration: underline;\"><em>index.jsp<\/em><\/span><\/p>\n<pre class=\"brush: html; wrap-lines:false;\">&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n   &lt;head&gt;\r\n      &lt;meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\"&gt;\r\n      &lt;title&gt;AngularJS&lt;\/title&gt;\r\n      \r\n      &lt;!-- Javascript Files --&gt;      \r\n      &lt;script type=\"text\/javascript\" src=\"resource\/js\/angular_v1.6.0.js\"&gt;&lt;\/script&gt;\t    \t   \r\n      &lt;script type=\"text\/javascript\" src=\"resource\/js\/form.js\"&gt;&lt;\/script&gt;    \r\n           \r\n      &lt;!-- Bootstrap Css --&gt;\r\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\"&gt;\r\n      \r\n      &lt;style type=\"text\/css\"&gt;\r\n      \t.marginTop14 {\r\n      \t\tmargin-top: 14px;\r\n      \t}\r\n      &lt;\/style&gt;\r\n   &lt;\/head&gt;\r\n   &lt;body&gt;\r\n      &lt;h2 align=\"center\" class=\"text-primary\"&gt;AngularJS Sql Example&lt;\/h2&gt;\r\n      &lt;div ng-app=\"myApp\"&gt;\r\n         &lt;form ng-controller=\"EmployeeController\" ng-submit=\"getData()\"&gt;\r\n            &lt;p&gt;\r\n               &lt;button id=\"formBtn\" type=\"submit\" class=\"btn btn-primary center-block marginTop14\"&gt;Get Data from Db&lt;\/button&gt;\r\n            &lt;\/p&gt;\r\n           \t&lt;div id=\"empTblContainer\" class=\"container\" ng-show=\"empList.length\"&gt;\r\n           \t\t&lt;table id=\"empTbl\" class=\"table table-bordered marginTop14\"&gt;\r\n              \t\t&lt;thead&gt;\r\n                 \t\t&lt;tr&gt;\r\n                    \t\t&lt;th&gt;Id&lt;\/th&gt;&lt;th&gt;Name&lt;\/th&gt;&lt;th&gt;Email&lt;\/th&gt;&lt;th&gt;Gender&lt;\/th&gt;\r\n                 \t\t&lt;\/tr&gt;\r\n              \t\t&lt;\/thead&gt;\r\n              \t\t&lt;tbody&gt;\r\n                 \t\t&lt;tr ng-repeat=\"detail in empList\"&gt;\r\n                    \t\t&lt;td&gt;&lt;span id=\"emp-id\"&gt;{{detail.map.emp_id}}&lt;\/span&gt;&lt;\/td&gt;&lt;td&gt;&lt;span id=\"emp-name\"&gt;{{detail.map.emp_name}}&lt;\/span&gt;&lt;\/td&gt;&lt;td&gt;&lt;span id=\"emp-email\"&gt;{{detail.map.emp_email}}&lt;\/span&gt;&lt;\/td&gt;&lt;td&gt;&lt;span id=\"emp-gender\"&gt;{{detail.map.emp_gender}}&lt;\/span&gt;&lt;\/td&gt;\r\n                 \t\t&lt;\/tr&gt;\r\n              \t\t&lt;\/tbody&gt;\r\n           \t\t&lt;\/table&gt;\r\n           \t&lt;\/div&gt;    \r\n           \t&lt;div id=\"errorTxt\" ng-show=\"noEmpRecord.length\" class=\"text-center text-danger marginTop14\"&gt;&lt;h5&gt;No record found in the database!&lt;\/h5&gt;&lt;\/div&gt;\r\n         &lt;\/form&gt;\r\n      &lt;\/div&gt;\r\n   &lt;\/body&gt;\r\n&lt;\/html&gt;\r\n<\/pre>\n<h4>3.3.1 Creating AngularJS Controller<\/h4>\n<p>The Javascript file i.e. <code>form.js<\/code> includes the function (i.e. <code>EmployeeController<\/code>) as the &#8220;<em>controller<\/em>&#8221; in the Model-View-Controller. It submits the form to the server and reads back the response message to the <code>$scope.empList<\/code>.<\/p>\n<p><span style=\"text-decoration: underline;\"><em>form.js<\/em><\/span><\/p>\n<pre class=\"brush:js; wrap-lines:false;\">\/* \r\n * Description - AngularJS Script for Retrieving the Employee Details from the Database.\r\n * Created By - Yatin Batra  \r\n * *\/\r\n\r\nvar ajaxApp = angular.module(\"myApp\", []);\r\n\r\najaxApp.controller(\"EmployeeController\", [ '$scope', '$http', function($scope, $http) {\r\n\t\r\n\t$http.defaults.headers.post[\"Content-Type\"] = \"application\/x-www-form-urlencoded; charset=utf-8\";\r\n\t$scope.getData = function() {\r\n\t\t$http({\r\n\t\t\turl : 'employeeServlet',\r\n\t\t\tmethod : \"GET\",\t\t\t\r\n\t\t}).then(function(response) {\r\n\t\t\tif(response.data.myArrayList.length == 0) {\r\n\t\t\t\t$scope.noEmpRecord = \"Yes\";\r\n\t\t\t} else {\r\n\t\t\t\t$scope.empList = response.data.myArrayList;\r\n\t\t\t}\r\n\t\t}, function(response) {\r\n\t\t\tconsole.log(\"Failure -&gt; \" + response.data);\r\n\t\t\t$scope.empList = response.data.myArrayList;\r\n\t\t});\r\n\t};\r\n} ]);\r\n<\/pre>\n<h2>4. Run the Application<\/h2>\n<p>As we are ready for all the changes, let us compile the project and deploy the application on the Tomcat7 server. To deploy the application on Tomat7, right-click on the project and navigate to <code>Run as -&gt; Run on Server<\/code>.<\/p>\n<figure id=\"attachment_20500\" aria-describedby=\"caption-attachment-20500\" style=\"width: 769px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_deploy_guide_1_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20500\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_deploy_guide_1_new-1.jpg\" alt=\"Fig. 12: How to Deploy Application on Tomcat\" width=\"769\" height=\"689\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_deploy_guide_1_new-1.jpg 769w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_deploy_guide_1_new-1-300x269.jpg 300w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_deploy_guide_1_new-1-768x688.jpg 768w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><figcaption id=\"caption-attachment-20500\" class=\"wp-caption-text\">Fig. 12: How to Deploy Application on Tomcat<\/figcaption><\/figure>\n<p>Tomcat will deploy the application in its web-apps folder and shall start its execution to deploy the project so that we can go ahead and test it in the browser.<\/p>\n<h2>5. Project Demo<\/h2>\n<p>Open your favorite browser and hit the following URL. The output page will be displayed.<\/p>\n<pre class=\"brush:plain; wrap-lines:false;\">http:\/\/localhost:8085\/AngularJsSqlEx\/\r\n<\/pre>\n<p>Server name (localhost) and port (8085) may vary as per your Tomcat configuration. Developers can debug the example and see what happens after every step. Enjoy!<\/p>\n<figure id=\"attachment_20501\" aria-describedby=\"caption-attachment-20501\" style=\"width: 849px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_1_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20501\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_1_new-1.jpg\" alt=\"Fig. 13: Welcome Page\" width=\"849\" height=\"112\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_1_new-1.jpg 849w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_1_new-1-300x40.jpg 300w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_1_new-1-768x101.jpg 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/a><figcaption id=\"caption-attachment-20501\" class=\"wp-caption-text\">Fig. 13: Welcome Page<\/figcaption><\/figure>\n<p>The user clicks the <em>Get Data from Db<\/em> button. The request will pass a <code>HTTP GET<\/code> request using the AngularJS controller and the servlet will return the response as below.<\/p>\n<figure id=\"attachment_20502\" aria-describedby=\"caption-attachment-20502\" style=\"width: 849px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_2_new-1.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20502\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_2_new-1.jpg\" alt=\"Fig. 14: Employee List\" width=\"849\" height=\"284\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_2_new-1.jpg 849w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_2_new-1-300x100.jpg 300w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_2_new-1-768x257.jpg 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/a><figcaption id=\"caption-attachment-20502\" class=\"wp-caption-text\">Fig. 14: Employee List<\/figcaption><\/figure>\n<p>In case, <em>no<\/em> employee list is returned, the servlet will return the response as below.<\/p>\n<figure id=\"attachment_20503\" aria-describedby=\"caption-attachment-20503\" style=\"width: 849px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_3_new.jpg\"><img decoding=\"async\" class=\"size-full wp-image-20503\" src=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_3_new.jpg\" alt=\"Fig. 15: Error Message\" width=\"849\" height=\"132\" srcset=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_3_new.jpg 849w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_3_new-300x47.jpg 300w, https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/angular_backend_ex_project_demo_guide_3_new-768x119.jpg 768w\" sizes=\"(max-width: 849px) 100vw, 849px\" \/><\/a><figcaption id=\"caption-attachment-20503\" class=\"wp-caption-text\">Fig. 15: Error Message<\/figcaption><\/figure>\n<p>That\u2019s all for this post. Happy Learning!!<\/p>\n<h2>6. Conclusion<\/h2>\n<p>In this section, developers learned how to create a simple AngularJS enabled Java web application. Developers can download the sample application as an Eclipse project in the <a href=\"#projectDownload\">Downloads<\/a> section. I hope this article served you with whatever developers were looking for.<\/p>\n<h2><a name=\"projectDownload\"><\/a>7. Download the Eclipse Project<\/h2>\n<p>This was an example of AngularJS with <code>SQL<\/code> implementation.<\/p>\n<div class=\"download\"><strong>Download<\/strong><br \/>\nYou can download the full source code of this example here: <a href=\"http:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2018\/01\/AngularJsSqlEx.zip\" target=\"_blank\" rel=\"noopener\"><strong>AngularJsSqlEx<\/strong><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hello readers, in this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the database. 1. Introduction 1.1 What is AngularJS? AngularJS is a JavaScript MVC or Model-View-Controller framework developed by Google that lets developers build well structured, easily testable, and maintainable front-end applications. Before &hellip;<\/p>\n","protected":false},"author":2162,"featured_media":909,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[48,266,416,82],"class_list":["post-20486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-angular-js","tag-angular","tag-angularjs","tag-html","tag-javascript"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>AngularJS with SQL Example - Web Code Geeks - 2026<\/title>\n<meta name=\"description\" content=\"In this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the SQL database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AngularJS with SQL Example - Web Code Geeks - 2026\" \/>\n<meta property=\"og:description\" content=\"In this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the SQL database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webcodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-17T14:15:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yatin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@webcodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yatin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\"},\"author\":{\"name\":\"Yatin\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/6c946b8aea919fb2cd83fb17268e9367\"},\"headline\":\"AngularJS with SQL Example\",\"datePublished\":\"2018-01-17T14:15:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\"},\"wordCount\":1575,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg\",\"keywords\":[\"angular\",\"angularjs\",\"HTML\",\"javascript\"],\"articleSection\":[\"Angular.js\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\",\"name\":\"AngularJS with SQL Example - Web Code Geeks - 2026\",\"isPartOf\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg\",\"datePublished\":\"2018-01-17T14:15:56+00:00\",\"description\":\"In this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the SQL database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webcodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JavaScript\",\"item\":\"https:\/\/www.webcodegeeks.com\/category\/javascript\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Angular.js\",\"item\":\"https:\/\/www.webcodegeeks.com\/category\/javascript\/angular-js\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"AngularJS with SQL Example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#website\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"name\":\"Web Code Geeks\",\"description\":\"Web Developers Resource Center\",\"publisher\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webcodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/www.webcodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webcodegeeks\",\"https:\/\/x.com\/webcodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/6c946b8aea919fb2cd83fb17268e9367\",\"name\":\"Yatin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3f011dd665043468ba193f7b07472ebbedfa359cff5e576a91a5901c130ca6f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3f011dd665043468ba193f7b07472ebbedfa359cff5e576a91a5901c130ca6f1?s=96&d=mm&r=g\",\"caption\":\"Yatin\"},\"description\":\"The author is graduated in Electronics &amp; Telecommunication. During his studies, he has been involved with a significant number of projects ranging from programming and software engineering to telecommunications analysis. He works as a technical lead in the information technology sector where he is primarily involved with projects based on Java\/J2EE technologies platform and novel UI technologies.\",\"sameAs\":[\"https:\/\/www.webcodegeeks.com\"],\"url\":\"https:\/\/www.webcodegeeks.com\/author\/yatin-batra\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AngularJS with SQL Example - Web Code Geeks - 2026","description":"In this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the SQL database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/","og_locale":"en_US","og_type":"article","og_title":"AngularJS with SQL Example - Web Code Geeks - 2026","og_description":"In this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the SQL database.","og_url":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/","og_site_name":"Web Code Geeks","article_publisher":"https:\/\/www.facebook.com\/webcodegeeks","article_published_time":"2018-01-17T14:15:56+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg","type":"image\/jpeg"}],"author":"Yatin","twitter_card":"summary_large_image","twitter_creator":"@webcodegeeks","twitter_site":"@webcodegeeks","twitter_misc":{"Written by":"Yatin","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#article","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/"},"author":{"name":"Yatin","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/6c946b8aea919fb2cd83fb17268e9367"},"headline":"AngularJS with SQL Example","datePublished":"2018-01-17T14:15:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/"},"wordCount":1575,"commentCount":5,"publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg","keywords":["angular","angularjs","HTML","javascript"],"articleSection":["Angular.js"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/","url":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/","name":"AngularJS with SQL Example - Web Code Geeks - 2026","isPartOf":{"@id":"https:\/\/www.webcodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage"},"image":{"@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg","datePublished":"2018-01-17T14:15:56+00:00","description":"In this basic example, developers will learn what AngularJS is and how to make a simple angular application to interact with the SQL database.","breadcrumb":{"@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#primaryimage","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2014\/10\/angularjs-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.webcodegeeks.com\/javascript\/angular-js\/angularjs-sql-example\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webcodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"JavaScript","item":"https:\/\/www.webcodegeeks.com\/category\/javascript\/"},{"@type":"ListItem","position":3,"name":"Angular.js","item":"https:\/\/www.webcodegeeks.com\/category\/javascript\/angular-js\/"},{"@type":"ListItem","position":4,"name":"AngularJS with SQL Example"}]},{"@type":"WebSite","@id":"https:\/\/www.webcodegeeks.com\/#website","url":"https:\/\/www.webcodegeeks.com\/","name":"Web Code Geeks","description":"Web Developers Resource Center","publisher":{"@id":"https:\/\/www.webcodegeeks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webcodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webcodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.webcodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.webcodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webcodegeeks","https:\/\/x.com\/webcodegeeks"]},{"@type":"Person","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/6c946b8aea919fb2cd83fb17268e9367","name":"Yatin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webcodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3f011dd665043468ba193f7b07472ebbedfa359cff5e576a91a5901c130ca6f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3f011dd665043468ba193f7b07472ebbedfa359cff5e576a91a5901c130ca6f1?s=96&d=mm&r=g","caption":"Yatin"},"description":"The author is graduated in Electronics &amp; Telecommunication. During his studies, he has been involved with a significant number of projects ranging from programming and software engineering to telecommunications analysis. He works as a technical lead in the information technology sector where he is primarily involved with projects based on Java\/J2EE technologies platform and novel UI technologies.","sameAs":["https:\/\/www.webcodegeeks.com"],"url":"https:\/\/www.webcodegeeks.com\/author\/yatin-batra\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/20486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/users\/2162"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/comments?post=20486"}],"version-history":[{"count":0,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/posts\/20486\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media\/909"}],"wp:attachment":[{"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/media?parent=20486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/categories?post=20486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webcodegeeks.com\/wp-json\/wp\/v2\/tags?post=20486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}