Java and MySQL - How To Connect Java To MySQL And Dsiplay Data In NetBeans

__________________________________________________________________________

In This Java Tutorial We Will See How To Connect Java To MySQL DataBase Using NetBeans.

Project Source Code:

downloads connector:  http://dev.mysql.com/downloads/connector/j

package javadb_001;
import java.sql.*;

public class JavaDB_001 {

    public static void main(String[] args) {
     
     try{
         Connection con = DriverManager.getConnection("jdbc:mysql://localhost/test_db","root","");
         Statement st = con.createStatement();
         ResultSet rs = st.executeQuery("select * from users");
         while(rs.next())
         {
             System.out.println(rs.getString(1));
             System.out.println(rs.getString(2));
             System.out.println(rs.getString(3));
             System.out.println(rs.getString(4));
             System.out.println("----------------------");
         }
         
     }catch(Exception e)
     {
         System.out.println(e.getMessage());
     }
    }
}

---

More JAVA

➜ Java Courses

➜ Java Projects

C# and MySQL - How To Connect C# To MySQL And Display Data

                                                                                                                                         

In This C# Tutorials We Will See How To Connect CSharp  To MySQL DataBase .

                                              
                                                        1 - Connect To MySQL 

2 - Connect And Show Data In Datagridview

Project Source Code:

1 - Connect

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace Csharp_And_MySQL
{
    public partial class Csharp_Connect_To_MySQL_Database : Form
    {
        public Csharp_Connect_To_MySQL_Database()
        {
            InitializeComponent();
        }
        MySqlConnection connection;
        private void Csharp_Connect_To_MySQL_Database_Load(object sender, EventArgs e)
        {
            try
            {
                connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=");
                connection.Open();
                if(connection.State == ConnectionState.Open)
                {
                    label1.Text = "Connected";
                    label1.ForeColor = Color.Green;
                }
                else
                {
                    label1.Text = "Not Connected";
                    label1.ForeColor = Color.Red;
                }
            }catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            if (connection.State == ConnectionState.Open)
            {
                connection.Close();
                label1.Text = "Not Connected";
                label1.ForeColor = Color.Red;
            }
        }
        private void button2_Click(object sender, EventArgs e)
        {
            if (connection.State == ConnectionState.Closed)
            {
                connection.Open();
                label1.Text = "Connected";
                label1.ForeColor = Color.Green;
            }
        }
    }

}

=> OUTPUT :

2 - Connect And Display

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace Csharp_And_MySQL
{
    public partial class Csharp_Display_Data_From_Mysql_Into_Datagridview : Form
    {
        public Csharp_Display_Data_From_Mysql_Into_Datagridview()
        {
            InitializeComponent();
        }
        private void Csharp_Display_Data_From_Mysql_Into_Datagridview_Load(object sender, EventArgs e)
        {
            
            try
            {
                MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=");
                MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT * FROM test_db.users", connection);
                connection.Open();
                DataSet ds = new DataSet();
                adapter.Fill(ds, "users");
                dataGridView1.DataSource = ds.Tables["users"];
                connection.Close();
            }catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            
        }
    }

}

=> OUTPUT :

---

More C#

➜ C# Courses

➜ C# Projects

JAVA - How to set background image in Java for a JFrame

How to set background image in Java for a JFrame

__________________________________________________________________________

In This Java Code We Will See How You Can Make A BackGround Image For Your JFrame In Java Using A JLabel Programming Language.

Method 1: image from Desktop.

Source Code: 

package learn;

import java.awt.FlowLayout;

import javax.swing.*;

import java.io.IOException;

import java.io.*;

import javax.imageio.*;

public class Test2 extends JFrame{

    

    public Test2(){

    super("window");

    this.setLocationRelativeTo(null);

    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

    try{

        setContentPane(new JLabel(new ImageIcon(ImageIO.read(new File("C:\\Users\\samsng\\Documents\\NetBeansProjects\\Learn\\src\\learn\\images\\sparta.jpg")))));

    

    }catch(IOException e)

    {

        e.printStackTrace();

       

    }

    this.setLayout(new FlowLayout());

    this.setResizable(false);

    this.pack();

    this.setVisible(true);

    }

    public static void main(String[] args) {

        Test2 t = new Test2();

    }

}

Method 1: image from Resource.

Step 1: create a new package.

Step 2: add an image to the package.

Source Code: 

package learn;
import javax.swing.*;

public class Test extends JFrame{
    
    public Test(){
    super("window");
    this.setLocationRelativeTo(null);
    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    JPanel pan = new JPanel();
    JLabel jlb = new JLabel();
     jlb.setIcon(new ImageIcon(getClass().getResource("images//sparta.jpg")));
     
   pan.add(jlb);

    this.setContentPane(jlb);
    this.setResizable(false);
    this.pack();
    this.setVisible(true);
    }
    public static void main(String[] args) {Test t = new Test();}
}

---

More JAVA

➜ Java Courses

➜ Java Projects

JAVA - How To Bind Data In JTable In Netbeans

JAVA - How To Fill Data In JTable In Java Netbeans.

__________________________________________________________________________

In This Java Code We Will See How To Populate  A  JTable  Using  In   Java   NetBeans Programming Language.

Source Code: 

package javadb_001;

import javax.swing.*;

public class To_JTable extends JFrame  {

    Object row[][] = {{"A","B","C"},{"D","E","F"},{"J","H","I"},{"G","K","L"},

                      {"D","E","F"},{"J","H","I"},{"G","K","L"},

                      {"D","E","F"},{"J","H","I"},{"G","K","L"},

                      {"D","E","F"},{"J","H","I"},{"G","K","L"},

                      {"A","B","C"},{"D","E","F"},{"J","H","I"},{"G","K","L"},

                      {"A","B","C"},{"D","E","F"},{"J","H","I"},{"G","K","L"},

                      };

    Object column[] = {"1","1","3"};

    JTable jt;

    JScrollPane js;

    public Mysql_To_JTable()

    {

       super("Mysql TO JTable");

       this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

       jt = new JTable(row, column);

       js = new JScrollPane(jt);

       this.setSize(500, 300);

       this.setLocationRelativeTo(null);

       this.add(js);

       this.setVisible(true);

    }

    public static void main(String[] args)

    {

        new To_JTable();

    }

}

---

More JAVA

➜ Java Courses

➜ Java Projects

How to set background image in Java for a JFrame using a JLabel

__________________________________________________________________________

In This Java Code We Will See How You Can Make A BackGround Image For Your JFrame In Java Using A JLabel Programming Language.

Project Source Code:

package learn;
import java.awt.FlowLayout;
import javax.swing.*;
import java.io.IOException;
import java.io.*;
import javax.imageio.*;

public class Test extends JFrame{
 
    public Test(){
    super("window");
    this.setLocationRelativeTo(null);
    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    try{
        setContentPane(new JLabel(new ImageIcon(ImageIO.read(new File("C:\\Users\\samsng\\Documents\\NetBeansProjects\\images\\image.jpg")))));
 
    }catch(IOException e)
    {
        e.printStackTrace();
     
    }
    this.setLayout(new FlowLayout());
    this.setResizable(false);
    this.pack();
    this.setVisible(true);
    }

public static void main(String[] args) {

       Test t = new Test();

    }
}

---

More JAVA

➜ Java Courses

➜ Java Projects

C# - How To Get Your Address IP Using C#

                                                                                                                                  

In This C# Tutorial We Will See How To Show Your IP Address In A Label Using CSharp Programming Language .

Source Code :

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Net;

using System.Net.Sockets;

namespace WindowsFormsApplication1

{

    public partial class Get_Ip_Address : Form

    {

        public Get_Ip_Address()

        {

            InitializeComponent();

        }

        private void Get_Ip_Address_Load(object sender, EventArgs e)

        {

            IPHostEntry iph;

            string myip = "";

            iph = Dns.GetHostEntry(Dns.GetHostName());

            foreach(IPAddress ip in iph.AddressList)

            {

                if(ip.AddressFamily == AddressFamily.InterNetwork)

                {

                    myip = ip.ToString();

                }

            }

            label1.Text = myip.ToString();

        }

    }

}

---

More C#

➜ C# Courses

➜ C# Projects