Please find the below article which describes the sample connection string coding in JSP in Java Reseller Hosting Plan.<\/p>\n\n\n\n
You can also refer the below sample jsp coding,<\/p>\n\n\n\n
\n<%@ page import=”java.sql.*” %>\n<%@ page import=”java.io.*” %>\n<\/p>\n\n\n\n
\n\nConnection with mysql database\n
\n<\/p>\n\n\n\n
<%
\ntry {
\n\/* Create string of connection url within specified format with machine name,
\nport number and database name. Here machine name id localhost and
\ndatabase name is usermaster. *\/
\nString connectionURL = “jdbc:mysql:\/\/localhost:3306\/username_DBname”;<\/p>\n\n\n\n
\/\/ declare a connection by using Connection interface
\nConnection connection = null;<\/p>\n\n\n\n
\/\/ Load JBBC driver “com.mysql.jdbc.Driver”
\nClass.forName(“com.mysql.jdbc.Driver”).newInstance();<\/p>\n\n\n\n
\/* Create a connection by using getConnection() method that takes parameters of
\nstring type connection url, user name and password to connect to database. *\/
\nconnection = DriverManager.getConnection(connectionURL, “username_DBusername”, “password”);<\/p>\n\n\n\n
\/\/ check weather connection is established or not by isClosed() method
\nif(!connection.isClosed())
\n%>
\n\n<%\nout.println(“Successfully connected to ” + “MySQL server using TCP\/IP\u2026”);\nconnection.close();\n}\ncatch(Exception ex){\n%>\n
\n\n<%\nout.println(“Unable to connect to database.”);\n}\n%>\n
\n
\n<\/p>\n\n\n\n
In this coding you have to replace the username_DBname and username_DBusername with your DBname and DBusername in Java Reseller Hosting Plan. <\/p>\n\n\n\n
Kindly check the below url to confirm whether the connection string is working or not.<\/p>\n\n\n\n It will show the result as “Successfully Connected”<\/p>\n\n\n\n Hope this will be useful for you to check the JSP connection string.<\/p>\n","protected":false},"excerpt":{"rendered":" Please find the below article which describes the sample connection string coding in JSP in Java Reseller Hosting Plan. You<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,1],"tags":[],"class_list":["post-6593","post","type-post","status-publish","format-standard","hentry","category-linux-reseller-web-hosting","category-windows"],"yoast_head":"\n