import java.io.
*;
import java.sql.*;
public class data {
static void myLine(){
for (int i=1;i<=80;i++)
System.out.print("*");
System.out.println();
public static void main(String[] args) {
Connection con;
Statement st;
BufferedReader bin;
ResultSet rs;
ResultSetMetaData rm;
String sno1, sname1, sco1;
int ch, nof;
try
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:mydsn");
st = con.createStatement();
bin = new BufferedReader(new InputStreamReader(System.in));
while(true){
System.out.println("Choose Option");
System.out.println("1. Select");
System.out.println("2. Insert");
System.out.println("3. Update");
System.out.println("4. Delete");
System.out.println("0. Exit");
ch = Integer.parseInt(bin.readLine());
if (ch==1)
rs = st.executeQuery("select * from ta");
rm = rs.getMetaData();
nof = rm.getColumnCount();
myLine();
for(int i=1; i<=nof; i++)
System.out.print(rm.getColumnName(i)+"\t\t");
System.out.println();
myLine();
while(rs.next())
for(int i=1; i<=nof; i++)
{
System.out.print(rs.getString(i) +"\t\t");
System.out.println();
myLine();
else if(ch==2)
do
System.out.println("Enter Student No :");
sno1 = bin.readLine();
System.out.println("Enter Student Name");
sname1 = bin.readLine();
System.out.println("Enter Course");
sco1 = bin.readLine();
st.execute("insert into ta values("+sno1+",'"+sname1+"','"+sco1+"')");
System.out.println("1 Record inserted");
System.out.println("Continue ? [y/n]");
sno1 = bin.readLine();
}while(sno1.equalsIgnoreCase("y"));
else if(ch==3)
{
System.out.println("Enter SNo. to Edit :");
sno1 = bin.readLine();
System.out.println("Enter Name");
sname1 = bin.readLine();
System.out.println("Enter Course");
sco1 = bin.readLine();
st.execute("update ta set sname='"+sname1+"', sco='"+sco1+"' where sno ="+sno1);
System.out.println("1 Record Updated");
else if(ch==4)
System.out.println("Enter SNo. to Delete :");
sno1 = bin.readLine();
st.execute("delete from ta where sno ="+sno1);
System.out.println("Record Deleted");
else if(ch==0)
bin.close();
con.close();
System.exit(0);
}
}
catch(Exception e)
System.out.println("Error :"+e.getMessage());
//program 2
/*Java Program to Demonstrate a Basic Calculator using Applet*/
import java.awt.*;
import java.applet.*;
import java.awt.event.*;
public class cal extends Applet implements ActionListener
TextField inp;
//Function to add features to the frame
public void init()
setBackground(Color.white);
setLayout(null);
int i;
inp = new TextField();
inp.setBounds(150,100,270,50);
this.add(inp);
Button button[] = new Button[10];
for(i=0;i<10;i++)
button[i] = new Button(String.valueOf(9-i));
button[i].setBounds(150+((i%3)*50),150+((i/3)*50),50,50);
this.add(button[i]);
button[i].addActionListener(this);
Button dec=new Button(".");
dec.setBounds(200,300,50,50);
this.add(dec);
dec.addActionListener(this);
Button clr=new Button("C");
clr.setBounds(250,300,50,50);
this.add(clr);
clr.addActionListener(this);
Button operator[] = new Button[5];
operator[0]=new Button("/");
operator[1]=new Button("*");
operator[2]=new Button("-");
operator[3]=new Button("+");
operator[4]=new Button("=");
for(i=0;i<4;i++)
operator[i].setBounds(300,150+(i*50),50,50);
this.add(operator[i]);
operator[i].addActionListener(this);
operator[4].setBounds(350,300,70,50);
this.add(operator[4]);
operator[4].addActionListener(this);
String num1="";
String op="";
String num2="";
//Function to calculate the expression
public void actionPerformed(ActionEvent e)
String button = e.getActionCommand();
char ch = button.charAt(0);
if(ch>='0' && ch<='9'|| ch=='.')
if (!op.equals(""))
num2 = num2 + button;
else
num1 = num1 + button;
inp.setText(num1+op+num2);
}
else if(ch=='C')
num1 = op = num2 = "";
inp.setText("");
else if (ch =='=')
if(!num1.equals("") && !num2.equals(""))
double temp;
double n1=Double.parseDouble(num1);
double n2=Double.parseDouble(num2);
if(n2==0 && op.equals("/"))
inp.setText(num1+op+num2+" = Zero Division Error");
num1 = op = num2 = "";
else
if (op.equals("+"))
temp = n1 + n2;
else if (op.equals("-"))
temp = n1 - n2;
else if (op.equals("/"))
temp = n1/n2;
else
temp = n1*n2;
inp.setText(num1+op+num2+" = "+temp);
num1 = Double.toString(temp);
op = num2 = "";
else
num1 = op = num2 = "";
inp.setText("");
else
if (op.equals("") || num2.equals(""))
op = button;
else
double temp;
double n1=Double.parseDouble(num1);
double n2=Double.parseDouble(num2);
if(n2==0 && op.equals("/"))
{
inp.setText(num1+op+num2+" = Zero Division Error");
num1 = op = num2 = "";
else
if (op.equals("+"))
temp = n1 + n2;
else if (op.equals("-"))
temp = n1 - n2;
else if (op.equals("/"))
temp = n1/n2;
else
temp = n1*n2;
num1 = Double.toString(temp);
op = button;
num2 = "";
inp.setText(num1+op+num2);
/*
<applet code = cal.class width=600 height=600>
</applet>
*/
