import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemListener;
import java.sql.*;

import javax.swing.BoxLayout;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.io.*;
import java.net.*;


public class newCl extends JDialog {

	private JButton query = new JButton("Query");
	private JLabel selectColumn = new JLabel("Select Query Column");
	private JLabel enterKeyword = new JLabel("Enter Keyword");
	private JComboBox comboBox = new JComboBox();
	private JTextField textField = new JTextField();
	private JPanel queryPanelLeft = new JPanel();
	private JPanel queryPanelRight = new JPanel();
	private JPanel queryPanel = new JPanel();
	private int queryColumn = -1;
	private String queryCriteria = null;
	private String queryString = null;
	private String resultString=null;
	private String[] org_DataV=null;
	private ResultDialog dialog = null;
	
	
	public newCl() {
		
	}


	public void init() {

		comboBox.setPreferredSize(new Dimension(200, 25));
		comboBox.addActionListener(new ComboListener());
		fillCombo();
		query.addActionListener(new ButtonListener());
		textField.setPreferredSize(new Dimension(200, 25));
		selectColumn.setPreferredSize(new Dimension(150, 25));
		enterKeyword.setPreferredSize(new Dimension(150, 25));

		queryPanelLeft.setLayout(new FlowLayout());
		queryPanelLeft.add(selectColumn);
		queryPanelLeft.add(comboBox);
		queryPanelLeft.add(new JLabel());

		queryPanelRight.setLayout(new FlowLayout());
		queryPanelRight.add(enterKeyword);
		queryPanelRight.add(textField);
		queryPanelRight.add(new JLabel());

		queryPanel.setLayout(new FlowLayout());
		queryPanel.add(queryPanelLeft);
		queryPanel.add(queryPanelRight);
		queryPanel.add(query);

		this.add(queryPanel);
		this.setSize(400, 200);
		this.setResizable(false);
		this.setModal(true);
		this.setTitle("Query Dialog");
		this.setVisible(true);
	}

	private void fillCombo() {
		comboBox.addItem("Choose");
		comboBox.addItem("SEHIR");
		comboBox.addItem("BTS ADI");
		comboBox.addItem("RL TIPI");
		comboBox.addItem("ANTEN CAPI");
		comboBox.addItem("RL KARSILIGI");
		comboBox.addItem("RL FREKANSI");
		comboBox.addItem("KULE");
		comboBox.addItem("HEIGHT");
		comboBox.addItem("AZIMUTH");
		comboBox.addItem("DISTANCE");
		comboBox.addItem("TRANSMISSION CONNECTION");
		comboBox.addItem("STATUS");
		comboBox.addItem("ON AIR TARIHI");
	}

	public static void main(String args[]) {
		newCl dialog = new newCl();
		dialog.init();
	}

	public int getQueryColumn() {
		return queryColumn;
	}

	public void setQueryColumn(int queryColumn) {
		this.queryColumn = queryColumn;
	}



	private class ButtonListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {
				resultString="";
				queryCriteria = textField.getText();
				resultString+=getQueryColumn()+":";
			
				String resp_D[] = queryCriteria.split(" ");
				for(int ff=0;ff<resp_D.length;ff++)
					 resultString+=resp_D[ff]+":";
				String host="172.28.118.135";	
				
				try{
				
					Socket socket = new Socket(host,9876);
					BufferedReader from_server =
							new BufferedReader(new InputStreamReader(socket.getInputStream()));
					PrintWriter to_server = new PrintWriter(socket.getOutputStream());

					to_server.println(resultString); 
					to_server.flush();

					int count=0;
					String line;
					while ((line = from_server.readLine()) != null) {
						if (line.equals("error")) {
						System.out.println("Sorguya uygun kayit bulunamadi.");
						System.exit(1);
					} 
					else{
						if(count==0){
			  				String first_V[]=line.split("QQTQQ");	
			  				int member_No=Integer.parseInt(first_V[0]);
			  				org_DataV=new String[member_No];
			  				org_DataV[count]=first_V[1];}
						else
							org_DataV[count]=line; 
			
							count++;
						} 
					}
					
					dialog = new ResultDialog();
					dialog.getTableModel().setData(readyTableData(org_DataV,org_DataV.length,27));
					dialog.setVisible(true);
					dialog.repaint();

					//for(int p=0;p<org_DataV.length;p++)
					//	print_allDs(org_DataV[p]);
	
	
				}
	
				catch (Exception e1) { // report any exceptions
					System.err.println("Exception occurred: " + e1);
				} 
					 
		}
	}


	private class ComboListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {
			int temp = ((JComboBox) e.getSource()).getSelectedIndex();
			switch (temp) {
			case 1:
				setQueryColumn(3);
				break;
			case 2:
				setQueryColumn(5);
				break;
			case 3:
				setQueryColumn(6);
				break;
			case 4:
				setQueryColumn(10);
				break;
			case 5:
				setQueryColumn(11);
				break;
			case 6:
				setQueryColumn(12);
				break;
			case 7:
				setQueryColumn(13);
				break;
			case 8:
				setQueryColumn(14);
				break;
			case 9:
				setQueryColumn(15);
				break;
			case 10:
				setQueryColumn(16);
				break;
			case 11:
				setQueryColumn(19);
				break;
			case 12:
				setQueryColumn(22);
				break;
			case 13:
				setQueryColumn(23);
				break;
			default:
				break;
			}
			
		}
	}
	
	private void print_allDs(String data_Str){
		String dvec[]=data_Str.split("www");
  		String normal_D=dvec[0];
  		String colour_D=dvec[1];
  		
  		String resp_D[] = normal_D.split(":");
		for(int ff=0;ff<resp_D.length;ff++){
			System.out.println(resp_D[ff]);} //sonu bos olanlar 26 uzunlugunda tabele
		
		String resp_C[] = colour_D.split("D");
		for(int f=0;f<resp_C.length;f++){
			System.out.println(resp_C[f]);}
	}
	
	private String[][] readyTableData(String[] incomingV,int rowsNo,int colsNo){
		String[][] interArr=new String[rowsNo][colsNo];
		boolean length_Check=false;
		int limit=colsNo;
		
		for(int r=0;r<incomingV.length;r++){
			String splitted[]=incomingV[r].split("www");
			String d_SplitV[]=splitted[0].split(":");
			if(d_SplitV.length<27){
				int	remainder=colsNo-d_SplitV.length;
				for(int i=0;i<remainder;i++)
					interArr[r][colsNo-1-i]=null;
				limit=colsNo-remainder;}
			for(int c=0;c<limit;c++)
				interArr[r][c]=d_SplitV[c];
		}
			
		return interArr;	
		
	}



}








import javax.swing.table.AbstractTableModel;


public class ResultTableModel 
	extends AbstractTableModel {
	    private String[] columnNames={"ELLIPSE GİRİŞİ","SAP GİRİŞİ","BÖLGE VE SAP DURUMU","SEHIR","SITE NO","BTS ADI",
	    		"RL TİPİ","MEVCUT RL KAPASİTESİ","PLANLANAN RL KAPASİTESİ","YEDEK","ANTEN CAPI","RL KARŞILIĞI",
	    		"RL FREKANSI","KULE","HEIGHT","AZIMUTH","DISTANCE","RX INPUT","TX OUTPUT","TRANSMISSION CONNECTION", 
	    		"FAR END CONNECTION NAME","RAPOR TARIHI","STATUS","ON-AIR TARIHI","SİTE TİPİ","RL KARŞILIK TİPİ",
	    		"RADYO FREKANSI"};
	    
	    private Object[][] data=null;

	    public Object[][] getData() {
			return data;
		}

		public void setData(Object[][] data) {
			this.data = data;
		}

		public int getColumnCount() {
	        return columnNames.length;
	    }

	    public int getRowCount() {
	        return data.length;
	    }

	    public String getColumnName(int col) {
	        return columnNames[col];
	    }

	    public Object getValueAt(int row, int col) {
	        return data[row][col];
	    }

	    /*public Class getColumnClass(int c) {
	        return getValueAt(0, c).getClass();
	    }*/

	    /*
	     * Don't need to implement this method unless your table's
	     * editable.
	     */
	    public boolean isCellEditable(int row, int col) {
	        //Note that the data/cell address is constant,
	        //no matter where the cell appears onscreen.
	        if (col < 2) {
	            return false;
	        } else {
	            return true;
	        }
	    }

	    /*
	     * Don't need to implement this method unless your table's
	     * data can change.
	     */
	    public void setValueAt(Object value, int row, int col) {
	        data[row][col] = value;
	        fireTableCellUpdated(row, col);
	    }
}








import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;


public class ResultDialog extends JDialog{
	JTextArea textArea=new JTextArea();
	JButton button=new JButton("Close");
	JPanel panel=new JPanel();
	JScrollPane scrollPane=new JScrollPane();
	String result=null;
	ResultTableModel tableModel=new ResultTableModel();
	JTable table=new JTable(tableModel);
	
	public ResultDialog(){
		init();
	}
	
	public void init(){		
		scrollPane.setPreferredSize(new Dimension(450,150));
		panel.setLayout(new BorderLayout());
		
		//scrollPane.getViewport().add(textArea);
		scrollPane.getViewport().add(table);
		
		panel.add(scrollPane,BorderLayout.CENTER);		
		panel.add(button,BorderLayout.SOUTH);
		
		button.addActionListener(new BListener());						
		table.setEnabled(false);		
		this.add(panel);
		this.setTitle("Result Dialog");
		//this.setResizable(false);
		this.setModal(true);
		this.setSize(700,300);
	}
	
	public void setResult(String res){
		result=res;
		textArea.setText(result);
	}
	
	public String getResult(){
		return result;
	}
	
	private class BListener implements ActionListener {
		public void actionPerformed(ActionEvent e) {
			setVisible(false);
		}
	}

	public ResultTableModel getTableModel() {
		return tableModel;
	}

	public void setTableModel(ResultTableModel tableModel) {
		this.tableModel = tableModel;
	}
}