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();
}
}
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.