import java.sql.*;
import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.io.*;
import java.util.Vector;
public class jdbc3 {
public static void main (String args[]){
JFrame.setDefaultLookAndFeelDecorated(true);
JDialog.setDefaultLookAndFeelDecorated(true);
pencere p1 = new pencere();
p1.setVisible (true);
p1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
}
class pencere extends JFrame{
JTextArea sonuc;
JScrollPane scsonuc;
Container cont;
Toolkit kit;
Dimension dim;
int sw,sh;
ust ust1;
giris giris1;
Statement stat;
ResultSet rset;
public pencere(){
setTitle("JDBC Version 1.0");
cont = this.getContentPane();
kit = this.getToolkit();
dim = kit.getScreenSize();
sw =dim.width;sh=dim.height;
this.setSize(sw-100,sh-100);
this.setLocation(50,50);
giris1= new giris(this);//JDialog ornegi
ust1=new ust(this);//panel ornegi
sonuc= new JTextArea();
scsonuc=new JScrollPane(sonuc);
cont.add(ust1,BorderLayout.NORTH);
cont.add(scsonuc,BorderLayout.CENTER);
}
public void getir(){//statement ve ilk resultset
try {
Statement stat = giris1.con.createStatement();
this.ust1.tabloz();//tablo isimlerini alan metot
}
catch (Exception e){System.out.print("Error");
}
giris1.setVisible(false);//dialog gizlenir
}
}
class ust extends JPanel{//ust kisim
JComboBox tablo;
JList sutun;
JScrollPane scp,sctext;
JTextArea sorgu;
JButton submit,reset,login;
Vector sutunlar=new Vector();
pencere pen;//ana pencere ile iliski kuruluyor
public ust(pencere vpen){
this.pen = vpen;//iliski kuruldu
this.setLayout(new FlowLayout());
tablo = new JComboBox();
tablo.addItemListener(new ItemListener(){//sutun isimleri geliyor
public void itemStateChanged(ItemEvent ie){
String tablomuz=tablo.getSelectedItem().toString();
String sql="select * from "+tablomuz;
sutunlar.clear();//ilk önce temizlik
try{
Statement stat2=pen.giris1.con.createStatement();
ResultSet sutset = stat2.executeQuery(sql);
ResultSetMetaData rsmd = sutset.getMetaData();
for (int i=1;i<=rsmd.getColumnCount();++i){
sutunlar.add(rsmd.getColumnName(i));
}
sutun.setListData(sutunlar);//sutun isimleri eklendi
stat2.close();
}catch (Exception e){System.out.println("Invalid Column");}
}
});
sutun = new JList(sutunlar);
sutun.setFixedCellWidth(120);
sutun.setVisibleRowCount(3);
sutun.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
sutun.addListSelectionListener(new ListSelectionListener(){//sql ifadesi hazirlaniyor
public void valueChanged(ListSelectionEvent le){
Object sutunlar[]=sutun.getSelectedValues();
String sutunlarim="";
for(int i=0;i<sutunlar.length;i++){
String sutunisim=sutunlar[i].toString();
if(sutunisim.indexOf(" ")>0)
sutunisim="["+sutunisim+"]";
sutunlarim+=sutunisim;
if(i!=sutunlar.length-1)
sutunlarim+=" , ";
}
sorgu.setText("select "+ sutunlarim +" from "
+tablo.getSelectedItem().toString());
}
});
scp = new JScrollPane(sutun);
sorgu = new JTextArea(3,15);
sorgu.setLineWrap(true);
sctext=new JScrollPane(sorgu);
submit = new JButton("Submit");
submit.addActionListener(new ActionListener(){//sougulama
public void actionPerformed(ActionEvent ae){
String sqlim=sorgu.getText();
pen.sonuc.setText("");
try{
Statement stat3=pen.giris1.con.createStatement();
ResultSet sorguset=stat3.executeQuery(sqlim);
ResultSetMetaData sorgursmd=sorguset.getMetaData();
int sutunsayi=sorgursmd.getColumnCount();
for(int i=1;i<=sutunsayi;i++){
pen.sonuc.append(sorgursmd.getColumnName(i)+"\t");
}
pen.sonuc.append("\n");
for(int i=1;i<=sutunsayi;i++){
pen.sonuc.append("-------------\t");
}
pen.sonuc.append("\n");
while(sorguset.next()){
for(int i=1;i<=sutunsayi;i++){
pen.sonuc.append(sorguset.getString(i)+"\t");
}
pen.sonuc.append("\n");
}
}catch(Exception e){System.out.println("OLMAZZZZ");}
}
});
reset = new JButton("Reset");//temizleme
reset.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae){
sorgu.setText("");
pen.sonuc.setText("");
}
});
login = new JButton("Login");
login.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
pen.giris1.setVisible(true);
}
});
add(login);add(tablo);add(scp);add(sctext);add(submit);add(reset);
}
public void tabloz(){//tablolar bulunuyor
try{
DatabaseMetaData dbmd = pen.giris1.con.getMetaData();
ResultSet tabloset = dbmd.getTables(null, null, null ,null);
while(tabloset.next()){
String tablename = tabloset.getString("TABLE_NAME");
String tabletype = tabloset.getString("TABLE_TYPE");
if(tabletype.equals("TABLE"))
tablo.addItem(tablename);
}
tabloset.close();
}
catch (Exception e){System.out.println("Invalid Table");}
}
}
class giris extends JDialog{
JLabel login,password;
JTextField log;
JPasswordField pass;
JButton enter,cancel;
Container dicont;
pencere pen;
Connection con;
public giris(pencere vpen){
this.pen = vpen;
this.setSize(250,150);
this.setTitle("Enter Login and Password");
login = new JLabel("Login");
password = new JLabel("Password");
log = new JTextField(12);
pass = new JPasswordField(12);
enter = new JButton("Enter");
enter.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con= DriverManager.getConnection("jdbc:odbc:John",log.getText()
,pass.getText());
pen.getir();
}
catch (Exception e){JOptionPane.showMessageDialog(pen,
"Invalid Login",
"Warning",
JOptionPane.WARNING_MESSAGE);
giris.this.setVisible(true);
}
}
});
cancel = new JButton("Cancel");
cancel.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae)
{
giris.this.setVisible(false);
}
});
dicont= this.getContentPane();
dicont.setLayout(new GridLayout(3,2));
dicont.add(login);dicont.add(log);dicont.add(password);dicont.add(pass);
dicont.add(enter);dicont.add(cancel);
this.setLocationRelativeTo(pen);
}
}
Unsolved 
