TY_BCA_2015_ADV_JAVA_15MARKS_SLIP13

SLIP13:  Write a java program to create a Mobile (Model_No, Company_Name, Price, Color) table.

import java.sql.*;

class Slip13_1

{

            public static void main(String a[])

            {

                        Connection con;

                        Statement stmt;                     

                        try

                        {

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

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

                                    if(con==null)

                                    {

                                                System.out.println("Connection Failed");

                                                System.exit(1);          

                                    }

                                    System.out.println("Connection Established....");

                                    stmt=con.createStatement();

                                    String sql="create table mobile"+"(Model_No int,"+"Company_Name varchar(20),"+"price float(6,2),"+"color varchar(20))";

                                    stmt.executeUpdate(sql);

                                    System.out.println("Table Created sucessfully...");   

                                    con.close();

                        }

                        catch(Exception e)

                        {

                                    System.out.println(e);

                        }          

            }

}