import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
class DDL extends JFrame implements ActionListener
{
JLabel l1;
JButton b1,b2,b3;
JTextArea t1;
DDL()
{
setLayout(null);
l1=new JLabel("Type DDL Query");
b1=new JButton("Create Table");
b2=new JButton("Alter Table");
b3=new JButton("Drop Table");
t1=new JTextArea();
l1.setBounds(20,30,100,20);
t1.setBounds(150,30,250,150);
b1.setBounds(10,250,120,20);
b2.setBounds(130,250,120,20);
b3.setBounds(250,250,120,20);
add(l1);
add(t1);
add(b1);
add(b2);
add(b3);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
setSize(440,350);
}
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==b1)
{
10 try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:BCA");
Statement st=cn.createStatement();
String str=t1.getText();
st.executeUpdate(str);
JOptionPane.showMessageDialog(null,"Table created");
cn.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
if(ae.getSource()==b2)
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:BCA");
Statement st=cn.createStatement();
String str1=t1.getText();
st.executeUpdate(str1);
JOptionPane.showMessageDialog(null,"Table altered");
cn.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
if(ae.getSource()==b3)
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:BCA");
Statement st=cn.createStatement();
String str1=t1.getText();
11 st.executeUpdate(str1);
JOptionPane.showMessageDialog(null,"Table droped");
cn.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
public static void main(String args[])
{
new DDL().show();
}
}
Search
Blog Archive
-
▼
2017
(64)
-
▼
March
(44)
- Write a Socket program in java in which client acc...
- Write a Socket program in java for chatting applic...
- Create a JSP page to accept a number from an user ...
- Write a JSP script to check whether given mail ID ...
- Write a JSP script to accept the details of Studen...
- Write a JSP script to accept username, store it in...
- Write a SERVLET program in java to accept details ...
- Write a SERVLET program that provides information ...
- Write a SERVLET program which counts how many time...
- Write a Multithreading program in java to convert ...
- Write a java program which will display name and p...
- Write a Multithreading program in java to display ...
- Write a java program using multithreading to execu...
- Write a Multithreading program in java using Runna...
- Write a java program to simulate traffic signal us...
- Write a menu driven java program for the following
- Write a java program to accept the details of coll...
- Write a JDBC application using swing for the follo...
- Write a JDBC program in java to display details of...
- Write a JDBC program to delete the records of empl...
- Write a JDBC program to accept the details of cust...
- Don't Quit Inspiring Poem..
- Something Very useful information
- C++ Program.Write a program to display area of squ...
- C++ Program. Write a program to display area of tr...
- C++ Program .Write a program convert fharenhite to...
- C++ Program .Write a program to display simple int...
- C++ Program .Write a program to input an integer n...
- C++ Program .Write a program to print factorial us...
- C++ Program .Write a program to print following pa...
- C++ Program .Write a program to nested structure
- C++ Program .Write a program to open file for reading
- C++ Program .Write a program to append the content...
- C++ Program .Write a program to create new file an...
- C++ Program .Write a program to accept n book deta...
- C++ Program Write a ‘C’ Program to count the numbe...
- C++Write menu driven program to convert decimal nu...
- C++ program to check whether given number is Palin...
- Write a C program to accept three integers as com...
- Write a program, which accepts a number n and disp...
- Write a menu driven program in C to create a stru...
- Write a C program to accept n different numbers a...
- Write a C program to calculate sum of digits till...
- Write a C program to swap two numbers using bitwis...
-
▼
March
(44)
Popular Posts
-
Emp.html <html> <body> <form method="POST" action="Lic.php"> Enter EMP No : <input ty...
-
class SortCity { public static void main(String arg[]) { String name[]=new Stri...
-
#include<stdio.h> #include<conio.h> main() { int num,rem=0,digit; clrscr(); printf("Enter number="...
-
Program to accept Book details of ‘n’ books as book_title, author, publisher and cost. Assign the accession number to each book in incre...
-
<?php interface Cyl { function area(); functi...
Categories
- BCA Sem VI Advance Java Slips Solution
- Ebooks
- FYBCA ( Sem–II) Assignment No.2 Decision making and looping.(solved assignment)
- FYBCA ( Sem–II) Assignment No.3 using function.(solved assignment)
- FYBCA ( Sem–II) Assignment No.4 Array program.(solved assignment)
- INFORMATION ABOUT TALLY.ERP 9
- RDBMS Assignment
- RDBMS ASSIGNMENT
- TYBCA (Sem IV) Java Programs
- TYBCA (Sem VI) Adv Java Programs
- TYBCA PHP Assignment