|
Description:
Using this program you can access the database directly from the applet. You can access MS ACCESS, Oracle and MY-SQL database from the applet. Without changing anything on the coding you can give data source name to the corresponding database. If the username and password are needed to connect with the database, then you can specify it. After giving these details as correct, you can perform the following SQL operations on the database. You can Create or alter the table. You can insert the data, update the data and Delete the data from the table. You can view the data in the table and also the structure of the table using Select and Structure Query.
The Impl class has the dbcreate (), dbinsert (), dbalter () methods to perform SQL operations on the specified table.
Query Processo Using Java:
/*Impl*/
import java.rmi.*;
import java.rmi.server.*;
import java.sql.*;
import javax.swing.*;
import java.util.*;
public class Impl
{
public String dbcreate(String url,String userid,String pwd,String query)throws RemoteException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
st1.executeUpdate(query);
st1.close();
conn.close();
return "successfully created";
}
catch(Exception e)
{
System.out.println(" "+e);
return ""+e;
}
}
public String dbinsert(String url,String userid,String pwd,String query)throws RemoteException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
st1.executeUpdate(query);
st1.close();
conn.close();
return "successfully inserted";
}
catch(Exception e)
{
System.out.println(" "+e);
return ""+e;
}
}
public String dbupdate(String url,String userid,String pwd,String query)throws RemoteException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
st1.executeUpdate(query);
st1.close();
conn.close();
return "successfully updated";
}
catch(Exception e)
{
System.out.println(" "+e);
return ""+e;
}
}
public String dbdelete(String url,String userid,String pwd,String query)throws RemoteException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
st1.executeUpdate(query);
st1.close();
conn.close();
return "successfully Deleted";
}
catch(Exception e)
{
System.out.println(" "+e);
return ""+e;
}
}
public String dbalter(String url,String userid,String pwd,String query)throws RemoteException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
st1.executeUpdate(query);
st1.close();
conn.close();
return "successfully Altered";
}
catch(Exception e)
{
System.out.println(" "+e);
return ""+e;
}
}
public ArrayList dbselect(String url,String userid,String pwd,String query)throws RemoteException
{
ArrayList al=new ArrayList();
ArrayList al1=new ArrayList();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
ResultSet rs=st1.executeQuery(query);
ResultSetMetaData ms=rs.getMetaData();
int ccount=ms.getColumnCount();
al.add(new Integer(ccount));
for(int i=1;i<=ccount;i++)
al.add(""+ms.getColumnName(i));
int rcount=0;
while(rs.next())
{
for(int i=1;i<=ccount;i++)
{
al.add(""+rs.getString(i));
}
rcount++;
}
//String str=""+rcount;
//al.add(str);
//al.add(str+" Row[s] Selected");
rs.close();
st1.close();
conn.close();
return al;
}
catch(Exception e)
{
System.out.println(" "+e);
al1.add(""+e);
return al1;
}
}
public ArrayList dbstruct(String url,String userid,String pwd,String query)throws RemoteException
{
ArrayList al=new ArrayList();
ArrayList al1=new ArrayList();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url,userid,pwd);
Statement st1=conn.createStatement();
ResultSet rs=st1.executeQuery(query);
ResultSetMetaData ms=rs.getMetaData();
int ccount=ms.getColumnCount();
for(int i=1;i<=ccount;i++)
al.add(""+ms.getColumnName(i)+"\t\t"+ms.getColumnTypeName(i));
rs.close();
st1.close();
conn.close();
return al;
}
catch(Exception e)
{
System.out.println(" "+e);
al1.add(""+e);
return al1;
}
}
}
/*Main.java*/
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.io.*;
import java.sql.*;
import java.rmi.*;
// CLIENT SIDE MODULE
public class Main extends Frame implements ActionListener
{
public void init()
{
setTitle("ODDB Main Window");
setVisible(true);
setLayout(null);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(650,500);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 25));
JLabel1.setBounds(84,48,420,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(132,120,120,36);
add(JButton2);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(300,120,100,30);
c1.setBackground(new java.awt.Color(253,225,248));
c1.setFont(new Font("Dialog", Font.BOLD, 12));
c1.setBounds(400,120,120,36);
add(c1);
c1.addItem("ORACLE");
c1.addItem("MS ACCESS");
c1.addItem("SQL SERVER");
add(JLabel3);
JLabel3.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel3.setBounds(300,180,100,37);
txt3.setBackground(new java.awt.Color(253,225,248));
txt3.setFont(new Font("Dialog", Font.BOLD, 12));
txt3.setBounds(400,180,121,37);
add(txt3);
/*c2.addItem("aaa");
c2.addItem("orb1");
c2.addItem("bbb");
c2.addItem("ccc");
c2.addItem("reg");*/
JButton2.setBackground(new java.awt.Color(253,225,248));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(132,180,121,37);
add(JButton3);
JButton3.setBackground(new java.awt.Color(253,225,248));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(132,240,122,35);
add(JLabel4);
JLabel4.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel4.setBounds(300,240,100,37);
txt1.setBackground(new java.awt.Color(253,250,248));
txt1.setFont(new Font("Dialog", Font.BOLD, 12));
txt1.setBounds(400,240,100,35);
txt1.setBackground(new java.awt.Color(253,225,248));
add(txt1);
add(JLabel5);
JLabel5.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel5.setBounds(300,300,100,37);
//txt2.setBackground(new java.awt.Color(253,250,248));
txt2.setFont(new Font("Dialog", Font.BOLD, 12));
txt2.setBounds(400,300,100,35);
txt2.setEchoChar('*');
txt2.setBackground(new java.awt.Color(253,250,248));
add(txt2);
add(JButton4);
JButton4.setBackground(new java.awt.Color(253,225,248));
JButton4.setFont(new Font("Dialog", Font.BOLD, 12));
JButton4.setBounds(132,300,121,35);
add(JButton5);
JButton5.setBackground(new java.awt.Color(253,225,248));
JButton5.setFont(new Font("Dialog", Font.BOLD, 12));
JButton5.setBounds(132,360,121,35);
/*add(JButton6);
JButton6.setBackground(new java.awt.Color(253,225,248));
JButton6.setFont(new Font("Dialog", Font.BOLD, 12));
JButton6.setBounds(336,240,158,37);*/
add(JButton7);
JButton7.setBackground(new java.awt.Color(253,225,248));
JButton7.setFont(new Font("Dialog", Font.BOLD, 12));
JButton7.setBounds(336,360,158,37);
add(JButton8);
JButton8.setBackground(new java.awt.Color(253,225,248));
JButton8.setFont(new Font("Dialog", Font.BOLD, 12));
JButton8.setBounds(336,420,158,37);
add(JButton9);
JButton9.setBackground(new java.awt.Color(253,225,248));
JButton9.setFont(new Font("Dialog", Font.BOLD, 12));
JButton9.setBounds(132,420,158,37);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
JButton4.addActionListener(this);
JButton5.addActionListener(this);
//JButton6.addActionListener(this);
JButton7.addActionListener(this);
JButton8.addActionListener(this);
JButton9.addActionListener(this);
//JButton6.setVisible(false);
}
public static String getValues()
{
String t1,t2,db,dsn;
t1=txt1.getText();
t2=txt2.getText();
db=c1.getSelectedItem();
dsn=txt3.getText();
//val=db+","+dsn+","+t1+","+t2;
if(t1.equals("")&&t2.equals(""))
{
val=db+","+dsn+","+" "+","+" ";
}
else
{
val=db+","+dsn+","+t1+","+t2;
}
return val;
}
Label JLabel1 = new Label("Open Distributed Data Base(ODDB)");
Label JLabel2 = new Label("Select DB");
Label JLabel3 = new Label("Select DSN");
Label JLabel4=new Label("User Name");
Label JLabel5=new Label("Password");
public static Choice c1=new Choice();
public static Choice c2=new Choice();
public static TextField txt1=new TextField();
public static TextField txt2=new TextField();
public static TextField txt3=new TextField();
Button JButton1 = new Button("Create");
Button JButton2 = new Button("Insert");
Button JButton3 = new Button("Select");
Button JButton4 = new Button("Update");
Button JButton5 = new Button("Delete");
//Button JButton6 = new Button("Remote Info");
Button JButton7 = new Button("Exit");
Button JButton8 = new Button("Alter");
Button JButton9 = new Button("Structure");
public static String arg[];
public static String val;
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("Create"))
{
Create c=new Create(arg);
c.init1();
String c1=getValues();
System.out.println(c1);
}
if(e.getActionCommand().equals("Insert"))
{
Insert i=new Insert(arg);
i.init2();
String c2=getValues();
System.out.println(c2);
}
if(e.getActionCommand().equals("Select"))
{
Select s=new Select(arg);
s.init3();
String c3=getValues();
System.out.println(c3);
}
if(e.getActionCommand().equals("Update"))
{
Update u=new Update(arg);
u.init4();
String c4=getValues();
System.out.println(c4);
}
if(e.getActionCommand().equals("Delete"))
{
Delete d=new Delete(arg);
d.init5();
String c5=getValues();
System.out.println(c5);
}
if(e.getActionCommand().equals("Structure"))
{
Structure s=new Structure(arg);
s.init8();
}
/*if(e.getActionCommand().equals("Remote Info"))
{
RemoteInfo r=new RemoteInfo();
r.init6();
}*/
if(e.getActionCommand().equals("Alter"))
{
Alter a=new Alter(arg);
a.init7();
}
if(e.getActionCommand().equals("Exit"))
{
System.exit(0);
setVisible(false);
}
}
public static void main(String args[])
{
arg=args;
Main m=new Main();
m.init();
}
}
//TABLE CREATE
class Create extends Frame implements ActionListener
{
public Create(String arg1[])
{
args=arg1;
System.out.println("Value"+arg1);
}
public void init1()
{
setTitle("Create Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(567,451);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,459,120);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(300,396,120,34);
add(JButton3);
JButton3.setBackground(new java.awt.Color(248,218,237));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(150,396,120,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
}
public static String[] args;
Label JLabel1 = new Label("Create New Table Wizard");
Button JButton1 = new Button("Create");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea();
Button JButton2 = new Button("Exit");
Button JButton3=new Button("Next>>");
Label Query = new Label("Enter your create query");
Label JLabel2 = new Label("Table Status ");
public void actionPerformed(ActionEvent e1)
{
if(e1.getActionCommand().equals("Create"))
{
String qcreate=JTextField1.getText();
String data1="your Query is";
if(qcreate.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
try{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
/*System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);*/
Impl asi=new Impl();
String a=asi.dbcreate(url,uname,pass,qcreate);
JTextArea1.setText("Your Query is"+"\n\n"+qcreate+"\n\n"+a);
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed.getMessage());
ed.printStackTrace(System.out);
}
}
}
if(e1.getActionCommand().equals("Next>>"))
{
setVisible(false);
Insert i1=new Insert(args);
i1.init2();
}
if(e1.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
//VALUE INSERT
class Insert extends Frame implements ActionListener
{
public Insert(String ar2[])
{
args=ar2;
}
public void init2()
{
setTitle("Insert Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(567,451);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,459,120);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(300,396,120,34);
add(JButton3);
JButton3.setBackground(new java.awt.Color(248,218,237));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(150,396,120,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
}
Label JLabel1 = new Label("Insert values into Table Wizard");
Button JButton1 = new Button("Insert");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea();
Button JButton2 = new Button("Exit");
Button JButton3=new Button("Next>>");
Label Query = new Label("Enter your Insert query");
Label JLabel2 = new Label("Table Status ");
public static String[] args;
public void actionPerformed(ActionEvent e2)
{
if(e2.getActionCommand().equals("Insert"))
{
String qinsert=JTextField1.getText();
String data1="your Query is";
if(qinsert.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
try{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);
Impl asi=new Impl();
String a=asi.dbinsert(url,uname,pass,qinsert);
JTextArea1.setText("Your Query is"+"\n\n"+qinsert+"\n\n"+a);
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed);
ed.printStackTrace(System.out);
}
}
}
if(e2.getActionCommand().equals("Next>>"))
{
setVisible(false);
Select s1=new Select(args);
s1.init3();
}
if(e2.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
//TABLE SELECTION
class Select extends Frame implements ActionListener
{
public Select(String a[])
{
args=a;
}
public void init3()
{
setTitle("Select Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(650,550);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,600,220);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(300,500,120,34); //396
add(JButton3);
JButton3.setBackground(new java.awt.Color(248,218,237));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(150,500,120,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
}
Label JLabel1 = new Label("Select Wizard");
Button JButton1 = new Button("Select");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea(20,20);
Button JButton2 = new Button("Exit");
Button JButton3=new Button("Next>>");
Label Query = new Label("Enter your Select query");
Label JLabel2 = new Label("Table values ");
public static String args[];
public static StringBuffer k;
public static String data;
public Vector v;
public static String a;
public void actionPerformed(ActionEvent e3)
{
if(e3.getActionCommand().equals("Select"))
{
String qselect=JTextField1.getText();
String data1="your Query is";
if(qselect.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
try{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);
Impl asi=new Impl();
ArrayList al=asi.dbselect(url,uname,pass,qselect);
System.out.println(al);
Iterator itr=al.iterator();
Integer obj=(Integer)itr.next();
int ccount= obj.intValue();
System.out.println(ccount);
int s=al.size();
System.out.println(s);
k=new StringBuffer();
int count=0;
while(itr.hasNext())
{
for(int i=1;i<=ccount;i++)
{
String str=(String)itr.next();
while(str.length()<25)
{
str=str+" ";
}
k.append(str);
k.append("\t");
}
count++;
k.append("\n");
}
//k.setLength(25);
JTextArea1.setText("Your Query is"+"\n\n"+qselect+"\n\n"+k.toString()+"\n\n"+(count-1)+" Row[s] successfully selected");
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed);
ed.printStackTrace(System.out);
}
}
}
if(e3.getActionCommand().equals("Next>>"))
{
setVisible(false);
Update u1=new Update(args);
u1.init4();
}
if(e3.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
//TABLE UPDATE
class Update extends Frame implements ActionListener
{
public Update(String h[])
{
args=h;
}
public void init4()
{
setTitle("Update Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(567,451);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
//JLabel1.setBackground(new java.awt.Color(045,221,110));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,459,120);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(300,396,120,34);
add(JButton3);
JButton3.setBackground(new java.awt.Color(248,218,237));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(150,396,120,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
}
Label JLabel1 = new Label("Update Table Wizard");
Button JButton1 = new Button("Update");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea();
Button JButton2 = new Button("Exit");
Button JButton3=new Button("Next>>");
Label Query = new Label("Enter your Update Data");
Label JLabel2 = new Label("Table Status ");
public static String args[];
public void actionPerformed(ActionEvent e4)
{
if(e4.getActionCommand().equals("Update"))
{
String qupdate=JTextField1.getText();
String data1="your Query is";
if(qupdate.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
JTextArea1.setText("Your Query is"+"\n\n"+qupdate);
try
{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);
Impl asi=new Impl();
String a=asi.dbupdate(url,uname,pass,qupdate);
System.out.println(a);
JTextArea1.setText("Your Query is"+"\n\n"+qupdate+"\n\n"+a);
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed);
ed.printStackTrace(System.out);
}
}
}
if(e4.getActionCommand().equals("Next>>"))
{
setVisible(false);
Delete d1=new Delete(args);
d1.init5();
}
if(e4.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
//ROW DELETE
class Delete extends Frame implements ActionListener
{
public Delete(String d[])
{
args=d;
}
public void init5()
{
setTitle("Delete Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(567,451);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,459,120);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(192,396,139,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
}
Label JLabel1 = new Label("Delete values into Table Wizard");
Button JButton1 = new Button("Delete");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea();
Button JButton2 = new Button("Exit");
Label Query = new Label("Enter your Delete query");
Label JLabel2 = new Label("Table Status ");
public static String args[];
public void actionPerformed(ActionEvent e5)
{
if(e5.getActionCommand().equals("Delete"))
{
String qdelete=JTextField1.getText();
String data1="your Query is";
if(qdelete.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
JTextArea1.setText("Your Query is"+"\n\n"+qdelete);
try{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);
Impl asi=new Impl();
String a=asi.dbdelete(url,uname,pass,qdelete);
JTextArea1.setText("Your Query is"+"\n\n"+qdelete+"\n\n"+a);
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed);
ed.printStackTrace(System.out);
}
}
}
if(e5.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
//TABLE STRUCTURE
class Structure extends Frame implements ActionListener
{
public Structure(String a[])
{
args=a;
}
public void init8()
{
setTitle("Structure Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(650,550);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,600,220);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(300,500,120,34); //396
add(JButton3);
JButton3.setBackground(new java.awt.Color(248,218,237));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(150,500,120,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
}
Label JLabel1 = new Label("Structure Wizard");
Button JButton1 = new Button("Show");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea(20,20);
Button JButton2 = new Button("Exit");
Button JButton3=new Button("Next>>");
Label Query = new Label("Enter your table name");
Label JLabel2 = new Label("Table Structure ");
public static String args[];
public static StringBuffer k;
public static String data;
public Vector v;
public static String a;
public void actionPerformed(ActionEvent e3)
{
if(e3.getActionCommand().equals("Show"))
{
/* String select="select * from" ;*/
String qselect="select * from "+JTextField1.getText();
String data1="your Query is";
if(qselect.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
try{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);
Impl asi=new Impl();
ArrayList al=asi.dbstruct(url,uname,pass,qselect);
k=new StringBuffer();
System.out.println(al);
Iterator itr=al.iterator();
while(itr.hasNext())
{
String str=(String)itr.next();
while(str.length()<25)
{
str=str+" ";
}
k.append(str);
k.append("\n");
}
JTextArea1.setText("Table Structure is"+"\n\n"+k.toString());
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed);
ed.printStackTrace(System.out);
}
}
}
if(e3.getActionCommand().equals("Next>>"))
{
setVisible(false);
Update u1=new Update(args);
u1.init4();
}
if(e3.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
//TABLE ALTER
class Alter extends Frame implements ActionListener
{
public Alter(String h[])
{
args=h;
}
public void init7()
{
setTitle("Alter Window");
setLayout(null);
setVisible(true);
setBackground(new java.awt.Color(197,221,250));
setFont(new Font("Dialog", Font.PLAIN, 12));
setSize(567,451);
add(JLabel1);
JLabel1.setFont(new Font("Dialog", Font.BOLD, 12));
//JLabel1.setBackground(new java.awt.Color(045,221,110));
JLabel1.setBounds(72,48,425,37);
add(JButton1);
JButton1.setBackground(new java.awt.Color(253,225,248));
JButton1.setFont(new Font("Dialog", Font.BOLD, 12));
JButton1.setBounds(372,156,120,36);
add(JTextField1);
JTextField1.setBounds(36,156,314,32);
add(JTextArea1);
JTextArea1.setBounds(36,252,459,120);
add(JButton2);
JButton2.setBackground(new java.awt.Color(248,218,237));
JButton2.setFont(new Font("Dialog", Font.BOLD, 12));
JButton2.setBounds(300,396,120,34);
add(JButton3);
JButton3.setBackground(new java.awt.Color(248,218,237));
JButton3.setFont(new Font("Dialog", Font.BOLD, 12));
JButton3.setBounds(150,396,120,34);
add(Query);
Query.setFont(new Font("Dialog", Font.BOLD, 12));
Query.setBounds(36,120,240,36);
add(JLabel2);
JLabel2.setFont(new Font("Dialog", Font.BOLD, 12));
JLabel2.setBounds(36,228,310,22);
JButton1.addActionListener(this);
JButton2.addActionListener(this);
JButton3.addActionListener(this);
}
Label JLabel1 = new Label("Alter Table Wizard");
Button JButton1 = new Button("Alter");
TextField JTextField1 = new TextField();
TextArea JTextArea1 = new TextArea();
Button JButton2 = new Button("Exit");
Button JButton3=new Button("Next>>");
Label Query = new Label("Enter your Alter data");
Label JLabel2 = new Label("Table Status ");
public static String args[];
public void actionPerformed(ActionEvent e4)
{
if(e4.getActionCommand().equals("Alter"))
{
String qalter=JTextField1.getText();
String data1="your Query is";
if(qalter.equals(""))
{
JTextArea1.setText("You must Entered the query");
}
else
{
JTextArea1.setText("Your Query is"+"\n\n"+qalter);
try{
String db,dsn,uname,pass,url;
System.out.println("one");
String auth=Main.getValues();
System.out.println("auth:"+auth);
StringTokenizer st=new StringTokenizer(auth,",");
db=st.nextToken();
dsn=st.nextToken();
uname=st.nextToken();
pass=st.nextToken();
url="jdbc:odbc:"+dsn;
System.out.println("DB"+db);
System.out.println("DSN"+dsn);
System.out.println("UNAME"+uname);
System.out.println("PASS"+pass);
Impl asi=new Impl();
String a=asi.dbalter(url,uname,pass,qalter);
JTextArea1.setText("Your Query is"+"\n\n"+qalter+"\n\n"+a);
}
catch(Exception ed)
{
System.out.println("ERROR : " + ed);
JTextArea1.setText(data1+"\n\n"+"Error:"+ed);
ed.printStackTrace(System.out);
}
}
}
if(e4.getActionCommand().equals("Next>>"))
{
setVisible(false);
Delete d1=new Delete(args);
d1.init5();
}
if(e4.getActionCommand().equals("Exit"))
{
setVisible(false);
}
}
}
Sample ScreenShot:
|
