dealercar.java

package finalproject;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.table.*;
import javax.swing.border.*;

public class dealercar{
	
	static JFrame f;
	Box b;
	JTable j ;
	String id;
	Connection c;
	Statement s;
	
	dealercar(String username){
		id=username;
		f = new JFrame("Second Hand Cars");
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		f.setExtendedState(JFrame.MAXIMIZED_BOTH); 
		f.getContentPane().setBackground(new Color(137, 209, 194));
		f.setLayout(new BorderLayout(15,15));
		//Heading
		b = Box.createVerticalBox();
		JLabel title = new JLabel("DEALERS CARS");
		title.setFont(new Font("Verdana", Font.BOLD, 24));
		title.setForeground(new Color(248, 151, 29)); 
		title.setAlignmentX( Box.CENTER_ALIGNMENT);
		title.setAlignmentY(80);
		
		b.add(title); // adding label to box
		f.add(b);
		
		
		setConnection();
		display();
		
		f.setVisible(true);
	}

	
	
	public void setConnection() {
		try {
			Class.forName("org.postgresql.Driver");
			c = DriverManager.getConnection
					("jdbc:postgresql://localhost:5432/automobileCompany","postgres","subbu0456");
		}
		catch(Exception e) {
			e.printStackTrace();
			System.err.println(e.getClass().getName()+": "+e.getMessage());
			System.exit(0);
		}
	}
	
	public void display() {
		try {
			
			String[] cName = 
				{"SI NO","VEHICLE ID","BRAND","MODEL","TYPE","GEAR","FEUL","AGE","SEATS","PRICE"}; 
			s = c.createStatement();
			
			ResultSet rs = s.executeQuery("select count(vehicle_id) from vehicle where d_id='"+id+"';");
			rs.next();
			int count = rs.getInt(1);
			
			String [][] data = new String[count+1][15];
			
			ResultSet r = s.executeQuery
			("select vehicle_id, brandname,modelname,typename,colour,gear_type,fuel,seat,age,price  from vehicle where d_id='"+id+"';");
			data[0][0] = "SI NO";
			data[0][1] = "VEHICLE ID"; 
			data[0][2] = "BRAND";
			data[0][3] = "MODEL";
			data[0][4] = "TYPE";	
			data[0][5] = "COLOUR";
			data[0][6] = "GEAR TYPE";
			data[0][7] = "FUEL";
			data[0][8] = "SEATS";
			data[0][9] = "PRICE";
			data[0][10] = "AGE";
			int i = 1;
			
			while(r.next()) {
					
				String c_id = r.getString("vehicle_id");
				String brand = r.getString("brandname");
				String type = r.getString("typename");
				String model = r.getString("modelname");
				String colour = r.getString("colour");
				String gear = r.getString("gear_type");
				String fuel = r.getString("fuel");
				int seat = r.getInt("seat");
				float price = r.getFloat("price");
				int age = r.getInt("age");

				String sprice = Float. toString(price);
				String sage =Integer.toString(age);
				String sseat = Integer.toString(seat);
				String ii = Integer.toString(i);
				
				data[i][0] = ii; 
				data[i][1] = c_id; 
				data[i][2] = brand;
				data[i][3] = type;
				data[i][4] = model;
				data[i][5] = colour;	
				data[i][6] = gear;
				data[i][7] = fuel;
				data[i][8] = sage;				
				data[i][9] = sseat;
				data[i][10] = sprice;
				i++;
				
			}
			
			j = new JTable(data, cName); 
	        j.setBounds(30, 40, 20, 40); 
	        j.setRowHeight(j.getRowHeight() + 20);
	        
	       
	        
	        b.add(Box.createRigidArea(new Dimension(50,70)));
	        
	        
	        DefaultTableCellRenderer cellRenderer = new DefaultTableCellRenderer();
	        cellRenderer.setHorizontalAlignment(JLabel.CENTER);
	        j.getColumnModel().getColumn(0).setCellRenderer(cellRenderer);
	        j.getColumnModel().getColumn(1).setCellRenderer(cellRenderer);
	        j.getColumnModel().getColumn(2).setCellRenderer(cellRenderer);
	        j.getColumnModel().getColumn(3).setCellRenderer(cellRenderer);
	        j.getColumnModel().getColumn(4).setCellRenderer(cellRenderer);
	        j.getColumnModel().getColumn(5).setCellRenderer(cellRenderer);
	       JTableHeader jh = j.getTableHeader();
	       jh.setBackground(Color.black);
	       jh.setForeground(Color.white);
	       jh.setFont(new Font("Verdana", Font.PLAIN, 18));
	       jh.setPreferredSize(
	    		     new Dimension(400,j.getRowHeight()+20));
	       j.setShowGrid(false);
	       j.setForeground(Color.white);
	       j.setBackground(new Color(248, 151, 29));
	       j.setFont(new Font("Verdana", Font.PLAIN, 18));	 
	       JButton returnbtn = new JButton(" Return");
	        returnbtn.setFont(new Font("Verdana", Font.BOLD, 18));
	        returnbtn.setBorder(null);
	        returnbtn.addActionListener(new ActionListener() {
	        public void actionPerformed(ActionEvent e) {
	        DealerPage dp= new DealerPage(id);
	        dp.setVisible(true);
	        f.dispose();;
	        }
	        });
	        returnbtn.setBounds(0, 60, 95, 33);
	        returnbtn.setBackground(new Color(248, 151, 29));
	        JPanel jp = new JPanel();
	        jp.add(returnbtn);
	        jp.setBackground(new Color(137, 209, 194));
	        f.add(jp,BorderLayout.NORTH);
	        b.add(j); 
	        rs.close();
	        r.close();
			s.close();
			c.close();
		}
		
		catch(Exception e) {
			e.printStackTrace();
			System.err.println(e.getClass().getName()+": "+e.getMessage());
			System.exit(0);
		}
	}



//	@Override
//	public void actionPerformed(ActionEvent e) {
//		// TODO Auto-generated method stub
//		
//	}
	
}