Monday, January 28, 2019

A Beginners Guide to Java JDBC

Introduction to JDBC in Java

Java Database Connectivity is a standard Java API used to connect Java application with Database. Java JDBC is used to communicate with the different type of Databases like Oracle, MS Access, My SQL and SQL Server. JDBC can also define as the platform-independent interface between a relational database and Java programming. It allows a java program to execute the SQL statement and retrieve the result from the database. JDBC uses drivers to connect with database. 

Different Types of JDBC Driver in Java 

Java JDBC

1. JDBC-ODBC Bridge Driver
2. Natïve Driver
3. Network Protocol Driver
4. Thin Driver

Why should we use JDBC?

There is some critical point which explains why we should use JDBC.

1. JDBC API is Standard API. We can communicate with any Database without
revising our Application, i.e. it is Database Independent API.
2. JDBC Drivers developed in Java, and hence JDBC Concept is applicable for any
Platform. i.e., JDBC is Platform Independent Technology.
3. By using JDBC API, we can perform basic CRUD Operations very efficiently.
C ➔ Create (Insert)
 R ➔ Retrieve (Select)
 U ➔ Update (Update)
 D ➔ Delete (Delete)
4. We can also perform Complex Operations like inner joins, Outer joins, calling
Stored Procedures, etc. very quickly by using JDBC API.
5. JDBC API supported by many vendors and they developed multiple Products
based on JDBC API.

Advantages of JDBC:

1. Provide present enterprise information.
2. Automatically Creates an XML structure of data from the database.
3. No content conversion required.
4. Query and Stored procedure supported.
5. We can use JDBC for both Synchronous and Asynchronous processing.
6. Supports modules.
7. Zero Configuration for Network Computers.
8. Full Access to Metadata.
9. Database Connection Identified by URL.
10. It does not require an installation.

Monday, January 21, 2019

How Java Servlet Works?

Features of Java Servlet

There are 5 Features of Servlet are as Follow:
Portable: Servlet uses Java Programming language, and as we know java is portable language, so servlet is also portable.
Efficient: Servlets invocation is highly skilled as compared to any CGI programs.
Robust: JVM manages Servlet. That’s why Servlet is robust.
Performance: Servlet creates a thread for each request, so the performance of servlet is better than CGI.
Secure: Because it uses java language, so servlet is safe.

How Servlet Works?

Whenever a request comes, it received by the servlet, and then they forward the request to the web container. A Web container is responsible for handling the request by creating the new thread. Container creates multiple threads to execute various requests.

How Java Servlet Works?


Let’s understand the working of Servlet –
1. The User sends a request by clicking a link for a servlet.
2. Then, the container finds the servlet and Create two instances.
  a.HttpServletRequest
  b.HttpServletResponse
3. After this, the container creates a thread for executing the request. So they call the servlet’s service() method and passes the instances as arguments.
4.Based on the HTTPRequest method sent by client, service( ) method decides which servlet method, doGet() or doPost() to call. 
5. Then, to respond to the client, servlet uses response instance to write the response.
6.After the service( ) method is completed, container call the destroy( ) method. And the request and response instance are prepared for garbage collection.

Servlet API

there are 2 packages of java servlet API are as follow:

1.javax.servlet

This package contains several classes and interfaces that describe and define bonds between a class and environment for an object.

Interface: -

ServletResponse
ServletRequest
RequestDispatcher
ServletConfig
Servlet

Class: -

GenericServlet
ServletRequestWrapper
ServletResponseWrapper
ServletInputStream
ServletOutputStream

Exception

ServletException
UnavailableException

2.javax.servlet.http

This package contains several classes and interfaces that describe and define bonds between a servlet class running under HTTP protocol and environment for an object.

Interface:- 

HttpServletRequest
HttpServletResponse
HttpSession
HttpSessionContext
HttpSessionListener

Class: -

Cookie
HttpServlet
HttpServletRequestWrapper
HttpServletResponseWrapper
HttpSessionEvent




Thursday, January 17, 2019

16 Best On-Page SEO Techniques for Improve Search Ranking

16 On Page SEO Activities for Improve Search Ranking

On Page SEO including proper headings, proper keyword placement, ensuring content quality, and paying attention to many other factors.
16 On-Page SEO Techniques That'll Boost Your Rankings

1) website structure:

A website’s technical structure plays a central role in determining its success or failure. SEO professionals can develop content and customer-centric websites that are also accessible and attractive to search engines.


2) Meta Title:

Meta title is very important role play in search engine optimization. The title length should be 50 to 65 characters. Meta title display SERP.

3) Post Permalink Structure:

Your URL is displayed is one of the most important factors of On-page SEO. It is important to correctly display your URL with use of target keyword and should also avoid using special characters, symbols, brackets, commas, etc. within the actual URL.

4) Heading Tags:

Heading tags are mainly used to highlight various headings, sub-headings, and important Loading Word-press, the title tag is set at H1. You are not supposed to use any more than H1 tags anywhere in the article.

5) Keyword Density:

Your keyword density should be around 1.5% percent with a mix of LSI keywords. You need to keep one thing in priority that your first and last paragraph should contain your main keyword.

6) Meta Tags:

Your each web page must need to have unique and relevant meta description because that is one of the most effective On-page SEO. Along with search engines' pick up on keywords, user’s click on the post is equally important. Your meta descriptions need to be more user-friendly and relevant to the post.

7) Images:

Attractive and relevant Images are effective part to drive traffic to your post from image searches. To make your blog post more focused and targeted, you can add keywords in the “image title” and the “alt text” too. As much as your image can stick more users around you, that is more liking to increase your overall rank.

8) Original Content:

Your content should be original and use your main keywords in your content. Not over-optimized the content and take care of keyword density, keyword proximity, keyword prominence.

9) Internal liking:

To make your reader spend more time on your blog, you can generate interlinking of blog posts and it can also lead other pages of your site to the high rank. Internal links that are relevant to the original post show search engines that you are providing extra information beyond what is being displayed in the content.

10) External Linking:

Along with internal linking, external linking is also a great idea for generating more traffic to your website. You are only supported to generate external link building when the external website is relevant to your post. Always choose the trusted website for external linking.

11) XML and Html sitemaps: 

The XML Site map is used to identify our web site pages are index or not. XML site map google understand but does not understand the user. User understandable site map is HTML site map.

12) Robots.txt: 

Robots main aim is to read our website data and stored in the search engine database. When search engine crawlers come to your site it will be looking for some special file. i.e, call roboat.txt file. This file tells to search engine spiders which pages of your site should be index and which pages of your site should be ignored.

13) Move to HTTPS:

Move to HTTPS due to security reason and Google also considers it as a ranking factor and give you the better rankings to competitive keywords early.

14) Mobile Friendly:

This time is mobile time so your website should be mobile friendly and open easily on mobile. So make sure website should be mobile friendly.

15) Fast Loading Speed:

Your website should be loading fast. Because the user likes a fast loading website. If your website loading fast then you can gain more visitors. If you want to check your speed then use tools like GTMetrix, Google Developer tools.

16) Google analytics and webmasters:


Google analytics main aim is a track record of website like how many visitors visit from the site by using which keyword, which landing page and also identify what type of users visits from the site linkage group, gender etc and also identify which country of user visit from the site like USA, Canada, India etc.

Google Webmasters is used to checking crawl errors, index status searches queries and also identify how many backlinks to your site, internal links to your sites and also identify search queries, clicks, impressions etc.

10 Best OFF Page SEO Techniques 2019

Latest OFF Page SEO Activities


Off-page SEO indicates all the things that you do directly to your website to help you rank higher, such as social networking, article submission, forum, blogging, community creation & blog marketing, etc.
Here are some most effective off-page activities which help you to increase your page ranking :
Off Page SEO Activities

1) Social Networking Sites:

Social networking sites are becoming more acceptable these days! Social networking sites allow you to extend your online network by connecting and interacting with your friends and other interested people, to share things with each other, and most importantly to promote your website/blog and help build your online reputation. There are some top social networking sites -be it Facebook, Twitter, Instagram, Pinterest, google+, etc.

2) Blogging:

A blog represents your work, services. Blogging also helps search engines to crawl your site more frequently, as they have to update your latest blog post entries, which ultimately helps you rank higher in search engine results pages (SERPs).

3) Blog Marketing:

Posting comments on other blogs within the same niche as yours, Where you can add a link in the comments section. These links will be crawled by search engines, benefitting point for them towards your site.

4) Forum Marketing:

Make a list of forums online, that are related to your sites niche and get involved with that community. Take participation in the community and reply to threads, answer peoples questions, offer advice, etc. This involvement can help you to build up your online reputation.

5) Social bookmarking:

Bookmark your site and blog to promote your website on social bookmarking sites. You can Submit your latest blog posts and pages to the most popular bookmarking sites, like StumbleUpon, Digg, Delicious, Reddit, etc.

6) Article Submission:

Here you need to make articles about your website and submit them to high PR Article Submission Sites like; Ezine, Go Articles, Now Public, etc. You can also give links to your site.

7) Business Reviews and Rating sites:

You can submit reviews about other businesses or ask your friends/clients to write a review of your business in major business review sites like Glassdoor, Mouthshoot, RateitAll, Shvoong, Kaboodle, Stylefeeder, etc.

8) Infographics Submission:

Infographics are the most appropriating way of presentation! Where you can make and submit your infographics on infographics submission websites and also give reference links to your web page or blog.

9) Image And Video Submission:

If you want to make your videos and images popular, head to popular video and image submission sites. Give a proper title, description, title tags, and reference links. Using this way of submission you can get quality backlinks because all video and image submission websites have high PR.

10) Question And Answer:

Question and Answers is one of the most effective ways to get more traffic to your website. Your answers to the relevant questions can help you to build up an online reputation of your website. You can also place a link to your website so that people can easily find your website.

Saturday, January 12, 2019

How to do SEO For E-Commerce Website?

A Beginners Guides to Optimization of an E-Commerce website

SEO: Search Engine Optimization

SEO Strategy

Search Engine Optimization, every websites backbone, is the tool that can make or break any website. Optimization of an e-commerce website is more critical and complicated than doing SEO for any other website. It is because your e-commerce site can have many more hundreds or even thousands of product listings that require you to follow best practices ensuring the performance of your website at an optimum level.

Strategy

Forgetting to the top of Google search results there should be little margin or room for errors while conducting SEO for your e-commerce website. It is because ideally, you must be looking to be within top three positions to tremendously increase the traffic for your website.
The number one ranked result receives the search of 31.24 clicks. The number two gets half of it around 14.04 clicks and so on coming down for rest three ranked searches. These statistics show the importance of time spend and resource utilization required for your eCommerce website to win the SEO battle on Google ranking.

Auditing

SEO Audit

You need proper research and study for the audit of your website to identify the SEO loopholes of your website. Pay keen attention to your product listing by unfolding the pages while analyzing your eCommerce site. This is the area where most of the mistakes occur and it’s the most vital feature of your website’s performance. Use the effective tools to ascertain the errors, duplicate content, missing tags and many more errors impacting the SEO performance of your site.

Keyword Research

Keyword Research
This is the most important aspect of the SEO puzzle and wins over it. Wrong keyword search can lead you to low-quality traffic and minimal sales of your product. By strategically working on right keywords implementation on your product pages can reap you in attracting immense reputed consumers with huge sales targets achieved altogether. Perform on creating long-tail keywords (searches containing three or more words) research depicting an eye catchy relevance of the products. This eventually generates high feasibility of attracting and converting a consumer to buy your product which in turn gives you a solid reputation and higher ranking.

Internal Linking

The next step is internal linking. You might not have heard of this before, but I’m sure you know what it is. This is when you link pages of your website to other pages on your website.
Internal linking in seo

Mobile Version of Website

Do you know how hot mobile shopping is becoming? Many people are not only browsing the web, but also making purchases through mobile devices, which means it’s really important to have a mobile-friendly version of your site.

Customer Reviews

According to Internet Retailer, you can increase your e-commerce conversion rate by 14-76% by adding product reviews to your online store. Jupiter Research also found that 77% of consumers read reviews before purchasing online.

To Obtain more Customer Review

In addition to increasing conversions, customer reviews also positively impact your SEO because more reviews = more content, and frequent reviews = fresh content, which Google loves to see.

To obtain more customer reviews, you can use a reward-based plugin like WooTheme’s Review for a Discount option.

You also can send an email out a few days after you know a customer has received a product asking if they need any assistance, and, if not, would they please leave a review. Simple tricks like this will really help your SEO!


Track of Other Websites

seo competitor analysis

Always keep your eyes and ears open in evaluating and compiling the list of keyword search your counterpart sites seems to use in their SEO strategy. And then insight about which keyword is providing the best quality output. Figure out by trying to reach out to the best one by researching yourself. Focus on the product page review of the other websites to give yourself a better idea of organizing your SEO navigation search.

Thursday, January 10, 2019

10 Difference between C++ and C# Programming Language

What is the Difference Between C++ and C#?

difference between C++ and C# | C++ vs C sharp




No.
C++
C#

1.
C++ is a low-level language.
C# is a High-level Language.

2.
It supports the multiple inheritances.
It does not support multiple inheritances.

3.
In C++, you require to manage memory manually.
C# automatically manages Memory.

4.
In C++, after compiling code changed into machine code.
In C#, after compiling code is changed into an intermediate language code.

5.
C++ used for developed console applications.
C# programming used for Windows, mobile, and console applications.

6.
for Each loop is not supported in C++.
for Each loop support in C#.

7.
C++ does not support garbage collection.
C# supports garbage collection.

8.
C++ Does not support bound checking of arrays.

C# Support bound checking of arrays.
9.
Using this language can create a standalone application.

Using this language cannot create a standalone application.
10.
In C++, you can use pointer anywhere in the programme.

In C#, Only in Unsafe mode, you can use a pointer.