Write a JDBC application using swing for the following:

By
Accept Query in TextField For
1. Create Table
2. Alter Table
3. Drop Table

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)
                        {
                                    try{
                                                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                                Connection cn=DriverManager.getConnection("jdbc:odbc:dsn","","");
                                                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:dsn","","");
                                                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:dsn","","");
                                                Statement st=cn.createStatement();
                                                String str1=t1.getText();
                                                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();
            }
}

Comments

Post a Comment

Popular posts from this blog

Write a java program to create Teacher table(TNo.TName, Sal, Desg) and insert a record in it.

By
import java.io.*; import java.sql.*; public class CreateTeacherTable {            static Connection cn;             static Statement st;             public static void main(String args[])             {                    try                  {                                 int tno,sal;                         String tname,desg;                         BufferedReader br=new BufferedReader(new InputStreamReader(System.in));                         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    ...
Read more

Create a JSP page to accept a number from an user and display it in words: Example: 123 – One Two Three. The output should be in red color.

By
NumberWord.html <html> <body> <form method=get action="NumberWord.jsp"> Enter Any Number : <input type=text name=num><br><br> <input type=submit value="Display"> </form> <body> </html> NumberWord.jsp <html> <body> <font color=red> <%! int i,n;        String s1; %> <%   s1=request.getParameter("num");          n=s1.length();          i=0;          do          {            char ch=s1.charAt(i);            switch(ch)             {                 case '0': out.println("Zero...
Read more

Write a JSP program to accept the details of Account (ANo, Type, Bal) and store it into database and display it in tabular form. (Use PreparedStatement interface)

By
SaveAccount.html <html> <body> <form method=get action="saveAccount.jsp"> Enter Account No. : <input type=text name=ano><br><br> Enter Account Type:<input type=text name=type><br><br> Enter Balance : <input type=text name=bal><br><br> <input type=submit value="Save"> </form> </body> </html> saveAccount.jsp <html> <body> <%@ page import="java.sql.*;" %> <%! int ano,bal;        String type;  %> <%       ano=Integer.parseInt(request.getParameter("ano"));       type=request.getParameter("type");       bal=Integer.parseInt(request.getParameter("bal"));       try{             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");           ...
Read more