JSP Database Connectivity with MySQL

Hi Folks,


Steps for Creating Connection with MySQL and JSP


1- Download MySQL Driver Jar file and paste it to:

                                   > c:\Program Files\java\jre1.8.0\lib\ext\ 'driver'.jar


                                  > Tomcat_Server_Location\lib\ 'driver'.jar

2- Write your code to connect


3- Output


and thats all. you are set to go.

Note: Here in step 2 image, i wrote code for displaying data on the console but you can write you own code to display data on the webpage.



Comments

Post a Comment

Popular posts from this blog

Print emojis using python (😀, 👍, ...)

Image
Hello World, Everyone of us usage the emojis at some point, because its quiet expressive. and when you are a programmer then it becomes more curious to print emoji characters out. I thought of printing emojis out for the logs , most of the time when I used to print the logs specially for the errors or exception message then I always try to express the message with more expression .  Well, you can print emojis using python as well. For that we can follow one of the following things: 1- Unicodes 2- Library 1- Unicodes: There are unicodes for every single character that is going to be printed out and that's why there are unicodes for the emojis too. For example : Unicode for thumbs up is "U+1F44D" which in python is going be be as "U0001F44D". As you have noticed that we are replacing "+" with "000", and not only that we also append "\" in front of this unicode while printing. So finally the thumb up emoji can be printed with : print(...
Read more

Scraping with Python

Hello World, There is more information on the Internet than any human can absorb in a lifetime. What you need is not access to that information, but a scalable way to collect, organize, and analyze it.  Then, You need web scraping.   So let's discuss this scrapping thing. Now, the Scrap Means: to take out something from somewhere and If we add 'web' to it, then it means to take out something from the web resources.  Web scraping automatically extracts data and presents it in a format you can easily make sense of. In this tutorial, we’ll focus on its applications in the webpage data extraction, but web scraping can be used in a wide variety of situations. Roadmap for this blog: - Setup with the tools and library - Basic of the HTML DOM - Scrapping Rule - Coding part Pre-Requisite: - A basic understanding of programming concept in python ---------------------------------------------------------- Getting Started with the tool...
Read more

Html Status Code

Basic Html Status Code Types          1- 1XX [Informational]  2- 2XX [Success]  3- 3XX [Redirect]       4- 4XX [Client Error]        5- 5XX [Server Error] ----------------------------------------------------------------------------------------------------------------------- 1xx Informational a- 100 Continue b- 101 Switching Protocols c- 102 Processing 2xx Success This class of status codes indicates the action requested by the client was received, understood, accepted and processed successfully. 200 OK 201 Created 202 Accepted 203 Non-Authoritative Information (since HTTP/1.1) 204 No Content 205 Reset Content 206 Partial Content 207 Multi-Status (WebDAV; RFC 4918) 208 Already Reported (WebDAV; RFC 5842) 226 IM Used (RFC 3229) 3xx Redirection This class of status code indicates the client must take additional action to complete the request. Many of these status codes are use...
Read more