Saturday, 13 February 2016

tybca slip49

import java.sql.*;


class slip49
{

 Connection con;


 Statement stm;

 ResultSet rs;



    slip49()
  {

  try
  {

   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

   con=DriverManager.getConnection("jdbc:odbc:emp");

   stm=con.createStatement();


  int i=stm.executeUpdate("create table moblie(mno number,cname varchar(10),price number,color varchar(10))");


  System.out.print("\n Table is created Succefully");


   i=stm.executeUpdate("insert into moblie values(9579797175,'Lenovo',7500,'black')");


  System.out.print("\n Record inserted  Succefully");


 
    rs=stm.executeQuery("select * from moblie");



    while(rs.next())
   {



 System.out.print("\n\t"+rs.getString("mno")+"\t"+rs.getString("cname")+"\t"+rs.getString("price")+"\t"+rs.getString("color"));








   }



    con.close();


     stm.close();



    }


 catch(Exception e)
 {


 System.out.print(e.getMessage());

  }


}



public static void main(String args[])
 {

slip49 ob=new slip49();



 }

}




















 
 

0 comments:

Post a Comment

Note: only a member of this blog may post a comment.

 
Copyright © 2013. BloggerSpice.com - All Rights Reserved
Author: MohammadFazle Rabbi | Powered by: Blogger
Designed by: Blogger Spice
^