Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    Final Database

    Uploaded by

    Archana Kathirvel
    This document contains 3 Java programs that connect to a database and perform operations: 1) Connect establishes a connection to the database and prints a success message. 2) Connect1 builds on Connect by creating a table in the database. 3) Connect2 builds on the previous programs by inserting values from command line arguments into the newly created table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Final Database

    Uploaded by

    Archana Kathirvel
    11 views5 pages
    This document contains 3 Java programs that connect to a database and perform operations: 1) Connect establishes a connection to the database and prints a success message. 2) Connect1 builds on Connect by creating a table in the database. 3) Connect2 builds on the previous programs by inserting values from command line arguments into the newly created table.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains 3 Java programs that connect to a database and perform operations: 1) Connect establishes a connection to the database and prints a success message. 2) Connect1 builds on Connect by creating a table in the database. 3) Connect2 builds on the previous programs by inserting values from command line arguments into the newly created table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    11 views5 pages

    Final Database

    Uploaded by

    Archana Kathirvel
    This document contains 3 Java programs that connect to a database and perform operations: 1) Connect establishes a connection to the database and prints a success message. 2) Connect1 builds on Connect by creating a table in the database. 3) Connect2 builds on the previous programs by inserting values from command line arguments into the newly created table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    PROGRAM Connect

    import java.sql.*; class Connect { public static void main(String s[]) { Connection co=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); co=DriverManager.getConnection("Jdbc:Odbc:abi"," ", " "); System.out.println("Connection successful"); co.close(); } catch(Exception e) { System.out.println(" "+e); } } }

    Connect1.java
    import java.sql.*; class Connect1 { public static void main(String s[]) { Connection co=null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); co=DriverManager.getConnection("Jdbc:Odbc:abi"," ", " "); Statement st=co.createStatement(); int res=st.executeUpdate("create table db(name varchar(20),rollno varchar(20),dept varchar(20),year varchar(5),percentage varchar(5))"); System.out .println("Table Created"); st.close(); co.close(); } catch(Exception e) { System.out.println(" "+e); } }}

    Connect2.java
    import java.sql.*; class Connect2 { public static void main(String s[]) { Connection co=null; String s1=s[0]; String s2=s[1]; String s3=s[2]; String s4=s[3]; String s5=s[4]; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); co=DriverManager.getConnection("Jdbc:Odbc:abi"," ", " "); Statement st=co.createStatement(); int result=st.executeUpdate("insert into db values('"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"')"); System.out .println("values inserted in the table"); st.close(); co.close(); } catch(Exception e) { System.out.println(" "+e);

    } } }

    OUTPUT

    You might also like