how to connect mysql with JDBC

package library.code;

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

/**
* @author SIRI Technologies
*/
public class DbConnection {

Connection connection = null;
Connection connectDB() {


try {
Class.forName("com.mysql.jdbc.Driver");
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/YourDatabaseName e.g employee", "root", "");
}catch (Exception e) {
e.printStackTrace();
}
return connection;
}
public static void main(String args[]) {
DbConnection db =new DbConnection();
db.connectDB();
}
}

Thanks
Rajanikant

Hi friend,


To mysql connect using JDBC .


Create a dabase "jdbctutorial"

Create a Table "employee"


To connect with database

Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db, user, pass);


Example to Display record from database using Jdbc:

import java.sql.*;

public class GetAllRows{
public static void main(String[] args) {
System.out.println("Getting All Rows from a table!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "jdbctutorial";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url+db, user, pass);
try{
Statement st = con.createStatement();
ResultSet res = st.executeQuery("SELECT * FROM employee");
System.out.println("Emp_code: " + "\t" + "Emp_name: ");
while (res.next()) {
int i = res.getInt("Emp_code");
String s = res.getString("Emp_name");
System.out.println(i + "\t\t" + s);
}
con.close();
}
catch (SQLException s){
System.out.println("SQL code does not execute.");
}
}
catch (Exception e){
e.printStackTrace();
}

For read in details JdBC to visit....

http://www.roseindia.net/jdbc/jdbc.shtml

Thanks