EX 10 DBMS LAB

COMMAND PROMPT: 

Microsoft Windows 2000 [Version 5.00.2195]

(C) Copyright 1985-2000 Microsoft Corp. 

C:\Documents and Settings\2910043>cd .. 

C:\Documents and Settings>cd .. 

C:\>cd jdk1.3\bin 

C:\jdk1.3\bin>javac dsql.java 

C:\jdk1.3\bin>java dsql

DB connected

1.insert

2.display

3.exit

1

enter employee id

101

enter employee name

Angel

enter address

Madurai

1.insert

2.display

3.exit

1

enter employee id

102

enter employee name

Ammu

enter address

Madurai

1.insert

2.display

3.exit

1

enter employee id

103

enter employee name

Geetha

enter address

Madurai

1.insert

2.display

3.exit

2 

empid   name    address 

101     Angel   Madurai

102     Ammu    Madurai

103     Geetha  Madurai

1.insert

2.display

3.exit

3 

C:\jdk1.3\bin>

 

NOTEPAD: 

import java.io.*;

import java.sql.*;

class dsql

{

  public static void main(String s[]) throws Exception

{

   Connection con;

   Statement st;

   ResultSet rs;

   PreparedStatement ps,ps1;

  int ch;

   try

      {

      DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());

      con=DriverManager.getConnection("jdbc:odbc:ex10","cs2910043","cs2910043");

      BufferedReader br=new BufferedReader(new InputStreamReader(System.in));

      System.out.println("DB connected");

      while(true)

         {

          

        System.out.println("1.insert\n2.display\n3.exit");

      ch=Integer.parseInt(br.readLine());

      switch(ch)

      {

    case 1:

        System.out.println("enter employee id");

            int empid=Integer.parseInt(br.readLine());

            System.out.println("enter employee name");

            String name=br.readLine();

    System.out.println("enter address");

            String address=br.readLine();

            ps=con.prepareStatement("insert into ex10 values(?,?,?)");

            ps1=con.prepareStatement("commit");

            ps.setInt(1,empid);

            ps.setString(2,name);

            ps.setString(3,address);

            ps.executeUpdate();

            ps1.execute();

            break; 

      case 2:

            st=con.createStatement();

            rs=st.executeQuery("select * from ex10");

            System.out.println("\nempid\tname\taddress\n");

            while(rs.next())

            {

            System.out.print(rs.getInt(1)+"\t");

            System.out.print(rs.getString(2)+"\t");

            System.out.print(rs.getString(3)+"\t");

            System.out.println();

            }

st.close();

break;

case 3:

      System.exit(0);

      break;

      default:

      break;

      }

      }

   }

catch(Exception e)

{

   System.out.println(e);

  }

}

}




 

ORACLE: 

SQL> create table ex10(empid number(3),empname varchar(15),address varchar(15)); 

Table created. 

SQL> commit; 

Commit complete.