connection of jdbc with jframe

[Nahhyan jugal]

How to connect JDBC(MySQL) with JPanel.I have a login page or login panel and i want to connect jdbc(MySQL) with that lagin panel for which i can login a person by checking id and password...

[Leonardo Jose Gomes da Silva]

Nahhyan jugal wrote:

How to connect JDBC(MySQL) with JPanel.I have a login page or login panel and i want to connect jdbc(MySQL) with that lagin panel for which i can login a person by checking id and password...

Hey man!

You can use a specific class and method responsible for that, look a sample example:

package br.com.cadastro.model.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DaoFactory {

	private static final String USER 		= "user";
	private static final String PASSWORD 	= "password"
	private static final String DB 			= "database";
	private static final String LOCAL 		= "localhost";
	private static final String PORT 		= "3306";
	
	public static Connection getCurrentConnection() throws SQLException{
		return newConnection();
	}
	
	private static Connection newConnection() throws SQLException{
		//jdbc:mysql://localhost:porta/banco","user","user"
		String url = "jdbc:mysql://"+LOCAL+":"+PORT+"/"+DB;
		Connection conn = DriverManager.getConnection(url, USER, PASSWORD);
		return conn;
	}
	
}

And you call the method when you need to user, like:

	
	public static void main(String[] args) throws SQLException{
		System.out.println(newConnection());
	}

Hugs