Java program to connect to mysql database
This tutorial shows a Simple java program to connect to MySql database and do a basic select operation from the table.
- Project Structure in Ecllipse IDE.
- This project uses MySql Connector jar. You have to download it and add to class path.
Download Mysql Connector jar here. - DB_Connection.java
package com.chillyfacts.com; import java.sql.Connection; import java.sql.DriverManager; public class DB_Connection { public static void main(String[] args) { DB_Connection obj_DB_Connection=new DB_Connection(); Connection connection=null; connection=obj_DB_Connection.get_connection(); System.out.println(connection); } public Connection get_connection(){ Connection connection=null; try{ Class.forName("com.mysql.jdbc.Driver"); connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root"); }catch (Exception e) { System.out.println(e); } return connection; } }
- If you run the above class as ‘Run as Java Application’. You will get a output as shown which means the connection to MySql is successful. If the out put is null that means connection to Database is not successful.
- This DAO.java class is a program to select a data from table and show it in console.
DAO.javapackage com.chillyfacts.com; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; public class DAO { public static void main(String[] args) { DAO obj_DAO=new DAO(); obj_DAO.Check_Data(); } public void Check_Data(){ DB_Connection obj_DB_Connection=new DB_Connection(); Connection connection=obj_DB_Connection.get_connection(); PreparedStatement ps=null; try { String query="select * from categories"; ps=connection.prepareStatement(query); ResultSet rs=ps.executeQuery(); while(rs.next()){ System.out.println("Catagory- "+rs.getString("category_name")); } } catch (Exception e) { System.out.println(e); } } }
- If you run the DAO.java class as Run as Java Application, You will get the below output.
- Download the project Here.
Download ConnectMysql.rar
0 Comments
Comments
Leave a Comment