how_to_use.java

Connection con = DBConnect.getConnecttion();
String sql = "insert into category value(?,?,?)";
PreparedStatement ps;
try {
	ps = (PreparedStatement) con.prepareStatement(sql);
	ps.setInt(1, 0);
	ps.setString(2, "Abc");
	ps.setString(3, "Def");
	ps.executeUpdate();
	con.close();
} catch (SQLException e) {
	e.printStackTrace();
}

mysql_connect_java.java

package dao;

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

public class DBConnect {

	public static Connection getConnecttion() {
		Connection cons = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			cons = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/image-gallery", "root", "");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return cons;
	}
	
	public static void main(String[] args) {
		System.out.println(getConnecttion());
	}

}