Java Connect Database on Site

Question

Hi guy i want to connect to my database on my website using java. i wonder what should i put in URL:

cnt=DriverManager.getConnection(DB_URL, DB_UID,DB_PWD);

Can you guy give me an example how to connect Mysql Database on website using java?

i have try to use:

import java.sql.*;

public class CreateConnect {


public final static String DB_DRIVER="com.mysql.jdbc.Driver";
public final static String SEVER_HOST="mysite";
public final static String PORT_NUM="3306";

public final static String DB_NAME="studentdb";
public final static String DB_UID="root";
public final static String DB_PWD="root";

public final static String DB_URL="jdbc:mysql://"+SEVER_HOST+":"+PORT_NUM+"/"+DB_NAME;

private static Connection cnt;

public static Connection getConnection()
{

    try
    {

        cnt=DriverManager.getConnection(DB_URL, DB_UID,DB_PWD);
        System.out.println("Connection Successfully");
    }
    catch(SQLException e)
    {
        System.out.println("Connection ERROR");
        e.printStackTrace();
    }

    return cnt;
}

do u want to connect to database were u hosted ur website.am i right? — Arun
– Arun, Commented Dec 24, 2013 at 12:50
Is it not problem that driver class is not loaded. I do not see use of DB_DRIVER. Something like Class.forName(DB_DRIVER) or it is done somewhere else? If you would like to use this code on web with many threads you can have problem. — JosefN
– JosefN, Commented Dec 24, 2013 at 13:01
in between u did not add Class.forName() for initializing the driver? — Arun
– Arun, Commented Dec 24, 2013 at 13:09

Helios · Accepted Answer · 2013-12-24 13:04:02Z

1

I guess I understood your problem but if you could tell me the error that would have been more helpful to debug.

Add this line before calling getConnection method.

Class.forName ("com.mysql.jdbc.Driver").newInstance ();

I hope it should work now.

answered Dec 24, 2013 at 13:04

Helios

8612 gold badges7 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:03:44Z

0

The below reference can help you connect to the database which is hosted.you have to provide the IPaddress of the site and port number 3306 to connect to the database.

JDBC: connect to remote mySQL database?

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Dec 24, 2013 at 12:56

Arun

1059 bronze badges

3 Comments

JosefN Over a year ago

port 3306 is used in the code, SEVER_HOST should be changed to a real hostname of server running my sql

Arun Over a year ago

SERVER_HOST should contain the IP address of the host.

JosefN Over a year ago

preciselly ip or DNS name (hostname) if DNS work on the server that runs the java code

Collectives™ on Stack Overflow

Java Connect Database on Site

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related