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

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

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());
     }
    }
}



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

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 :

How To Connect C# To MySQL Database


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 :

populate datagridview from mysql database in c#




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

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();}
}






JAVA - How To Bind Data In JTable In Netbeans

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();
    }
}





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

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

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();

    }
}




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

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

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();
        }
    }
}