How to use : Java GUI JTable - Alternate Rows/Background Color

table = new JTable()
 {
	@Override
	public Component prepareRenderer(TableCellRenderer renderer, int row, int column) {
		Component comp = super.prepareRenderer(renderer, row, column);
		comp.setBackground(row % 2 == 0 ? Color.white : Color.orange);
		return comp;
	}
};

CREATE TABLE `customer` (
  `CustomerID` varchar(4) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `CountryCode` varchar(2) NOT NULL,
  `Budget` double NOT NULL,
  `Used` double NOT NULL,
  PRIMARY KEY  (`CustomerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- dump ตาราง `customer`
-- 

INSERT INTO `customer` VALUES ('C001', 'Win Weerachai', '[email protected]', 'TH', 1000000, 600000);
INSERT INTO `customer` VALUES ('C002', 'John  Smith', '[email protected]', 'UK', 2000000, 800000);
INSERT INTO `customer` VALUES ('C003', 'Jame Born', '[email protected]', 'US', 3000000, 600000);
INSERT INTO `customer` VALUES ('C004', 'Chalee Angel', '[email protected]', 'US', 4000000, 100000);

package com.java.myapp;

import java.awt.Color;
import java.awt.Component;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;

public class MyForm extends JFrame {

	private JTable table;
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				MyForm frame = new MyForm();
				frame.setVisible(true);
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public MyForm() {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 580, 242);
		setTitle("ThaiCreate.Com Java GUI Tutorial");
		getContentPane().setLayout(null);
		
		// ScrollPane
		JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(64, 44, 440, 89);
		getContentPane().add(scrollPane);
		
		// Table
		table = new JTable()
		 {
            @Override
            public Component prepareRenderer(TableCellRenderer renderer, int row, int column) {
                Component comp = super.prepareRenderer(renderer, row, column);
                comp.setBackground(row % 2 == 0 ? Color.white : Color.orange);
                return comp;
            }
        };

		scrollPane.setViewportView(table);
		
		// Windows Loaded
		addWindowListener(new WindowAdapter() {
			@Override
			public void windowOpened(WindowEvent e) {
				PopulateData();
			}
		});
	}
	
	private void PopulateData()
	{
		// Model for Table
				DefaultTableModel model = (DefaultTableModel)table.getModel();
				model.addColumn("CustomerID");
				model.addColumn("Name");
				model.addColumn("Email");
				model.addColumn("CountryCode");
				model.addColumn("Budget");
				model.addColumn("Used");
				
				Connection connect = null;
				Statement s = null;
				
				try {
					Class.forName("com.mysql.jdbc.Driver");

					connect =  DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
							"?user=root&password=root");
					
					s = connect.createStatement();
					
					String sql = "SELECT * FROM  customer ORDER BY CustomerID ASC";
					
					ResultSet rec = s.executeQuery(sql);
					int row = 0;
					while((rec!=null) && (rec.next()))
		            {			
						model.addRow(new Object[0]);
						model.setValueAt(rec.getString("CustomerID"), row, 0);
						model.setValueAt(rec.getString("Name"), row, 1);
						model.setValueAt(rec.getString("Email"), row, 2);
						model.setValueAt(rec.getString("CountryCode"), row, 3);
						model.setValueAt(rec.getFloat("Budget"), row, 4);
						model.setValueAt(rec.getFloat("Used"), row, 5);
						row++;
		            }

					rec.close();
		             
				} catch (Exception e) {
					// TODO Auto-generated catch block
					JOptionPane.showMessageDialog(null, e.getMessage());
					e.printStackTrace();
				}
				
				try {
					if(s != null) {
						s.close();
						connect.close();
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
	}
}

package com.java.myapp;

import java.awt.Color;
import java.awt.Component;
import java.awt.EventQueue;
import java.awt.Font;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Map;

import javax.swing.BorderFactory;
import javax.swing.JComponent;
import javax.swing.JOptionPane;
import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableCellRenderer;

import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.awt.font.TextAttribute;

public class MyForm extends JFrame {

	private JTable table;
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				MyForm frame = new MyForm();
				frame.setVisible(true);
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public MyForm() {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 580, 242);
		setTitle("ThaiCreate.Com Java GUI Tutorial");
		getContentPane().setLayout(null);
		
		// ScrollPane
		JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBounds(64, 44, 440, 89);
		getContentPane().add(scrollPane);
		
		// Table
		table = new JTable()
		 {

            @Override
            public Component prepareRenderer(TableCellRenderer renderer, int row, int column) {
                Component comp = super.prepareRenderer(renderer, row, column);
                JComponent jc = (JComponent) comp;
                Map attributes = (new Font("Serif", Font.PLAIN, 12)).getAttributes();
                attributes.put(TextAttribute.STRIKETHROUGH, TextAttribute.STRIKETHROUGH_ON);
                if (!isRowSelected(row)) {
                    comp.setForeground(Color.black);
                    comp.setBackground(row % 2 == 0 ? Color.white : Color.orange);
                    int modelRow = convertRowIndexToModel(row);
                    String type = (String) getModel().getValueAt(modelRow, 0);
                    comp.setFont(new Font("Serif", Font.BOLD, 12));
                } else {
                    comp.setFont(table.getFont());
                }
                jc.setBorder(BorderFactory.createCompoundBorder(jc.getBorder(), BorderFactory.createEmptyBorder(0, 0, 0, 5)));
                return comp;
            }
        };
        table.setPreferredScrollableViewportSize(table.getPreferredSize());


		scrollPane.setViewportView(table);
		
		// Windows Loaded
		addWindowListener(new WindowAdapter() {
			@Override
			public void windowOpened(WindowEvent e) {
				PopulateData();
			}
		});
	}
	
	private void PopulateData()
	{
		// Model for Table
				DefaultTableModel model = (DefaultTableModel)table.getModel();
				model.addColumn("CustomerID");
				model.addColumn("Name");
				model.addColumn("Email");
				model.addColumn("CountryCode");
				model.addColumn("Budget");
				model.addColumn("Used");
				
				Connection connect = null;
				Statement s = null;
				
				try {
					Class.forName("com.mysql.jdbc.Driver");

					connect =  DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
							"?user=root&password=root");
					
					s = connect.createStatement();
					
					String sql = "SELECT * FROM  customer ORDER BY CustomerID ASC";
					
					ResultSet rec = s.executeQuery(sql);
					int row = 0;
					while((rec!=null) && (rec.next()))
		            {			
						model.addRow(new Object[0]);
						model.setValueAt(rec.getString("CustomerID"), row, 0);
						model.setValueAt(rec.getString("Name"), row, 1);
						model.setValueAt(rec.getString("Email"), row, 2);
						model.setValueAt(rec.getString("CountryCode"), row, 3);
						model.setValueAt(rec.getFloat("Budget"), row, 4);
						model.setValueAt(rec.getFloat("Used"), row, 5);
						row++;
		            }

					rec.close();
		             
				} catch (Exception e) {
					// TODO Auto-generated catch block
					JOptionPane.showMessageDialog(null, e.getMessage());
					e.printStackTrace();
				}
				
				try {
					if(s != null) {
						s.close();
						connect.close();
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
	}
}