Scribd Logo
Upload

Welcome to Scribd!

  • 66 views

    JDBC

    Uploaded by

    Mitali
    The document provides code to perform the following tasks in JDBC: 1. Establish a connection to a database 2. Insert records into database tables using prepared statements 3. Query the database to select specific records 4. Update and delete records in database tables The code examples connect to databases, insert, update, delete, and retrieve data from tables to demonstrate basic CRUD operations in JDBC.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    JDBC

    Uploaded by

    Mitali
    66 views7 pages
    The document provides code to perform the following tasks in JDBC: 1. Establish a connection to a database 2. Insert records into database tables using prepared statements 3. Query the database to select specific records 4. Update and delete records in database tables The code examples connect to databases, insert, update, delete, and retrieve data from tables to demonstrate basic CRUD operations in JDBC.

    Original Description:

    jdbc

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides code to perform the following tasks in JDBC: 1. Establish a connection to a database 2. Insert records into database tables using prepared statements 3. Query the database to select specific records 4. Update and delete records in database tables The code examples connect to databases, insert, update, delete, and retrieve data from tables to demonstrate basic CRUD operations in JDBC.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    66 views7 pages

    JDBC

    Uploaded by

    Mitali
    The document provides code to perform the following tasks in JDBC: 1. Establish a connection to a database 2. Insert records into database tables using prepared statements 3. Query the database to select specific records 4. Update and delete records in database tables The code examples connect to databases, insert, update, delete, and retrieve data from tables to demonstrate basic CRUD operations in JDBC.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 7

    Q.

    To develop a program in JDBC to perform following task


    1. To establish a connection to a given database.
    2. To insert a record into the given database table name stud table.
    3. To change the name of student as John whose roll no. is 2 in the table stud
    table.
    4. To delete current record.
    5. Display the whole contents of database.
    //This program is little complicated. If you get easier solution, please refer that.
    A) Creating a Database(For More Information, please refer the presentation)

    B) Creating A Connection To Database :

    Control Panel -->

    -->

    import java.sql.*;
    import java.io.*;
    public class StudentTable
    {
    public static void main(String args[])
    {
    try
    {
    String sql;
    ResultSet results;
    //a) Connection To A Database
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    System.out.println("Driver Loaded");
    String URL = "jdbc:odbc:Student";
    Connection con = DriverManager.getConnection(URL);
    System.out.println("Connection to database created.");
    Statement state = con.createStatement();
    System.out.println("Statement Object Created.");
    //b) Insert a Record
    sql = "insert into StudTable values(6, 'XYZ')";
    state.executeUpdate(sql);
    System.out.println("Entry Inserted.");
    //c) Change name as John where Roll No. is 2
    sql = "update StudTable set StudentName = 'John' where Roll = 2";
    state.executeUpdate(sql);

    System.out.println("Entry Updated.");
    //d) Delete Current Record
    sql = "delete * from StudTable where Roll = 4";
    state.executeUpdate(sql);
    System.out.println("Entry Deleted.");
    //e) Display whole contents of Database.
    sql = "select Roll, StudentName from StudTable";
    results = state.executeQuery(sql);
    String text = "" ;
    while(results.next())
    {
    text += results.getInt(1) + "\t" + results.getString(2) + "\n";
    }
    System.out.println("\nROLL\tNAME");
    System.out.println(text);
    results.close();
    state.close();
    con.close();
    }
    catch(Exception e)
    {
    System.out.println(e);
    }
    }
    }

    Q. To develop a program in JDBC to perform following task


    1. To establish a connection to a given database.
    2. To insert a employee record into the database employee by using prepared
    statement
    3. To select all the entries related to employee Ramesh from the database.
    4. To delete the record of the database.
    //This program is completely based on PreparedStatement. If you get easy solution, please
    refer that.

    import java.sql.*;
    public class EmployeeTableUpdate
    {
    public static void main(String args[])
    {
    try
    {
    String sql;
    ResultSet results;
    PreparedStatement state;
    String text;
    //a) Establish Connection To Database.
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    System.out.println("Driver Loaded");
    String URL = "jdbc:odbc:EmployeeDatabase";
    Connection con = DriverManager.getConnection(URL);
    System.out.println("Connection to database created.");
    //b) Insert Record Using PreparedStatement
    sql = "insert into Employee values(?, ?)";
    state = con.prepareStatement(sql);
    state.setString(1, "XYZ");
    state.setInt(2, 21);
    state.executeUpdate();
    System.out.println("\nRecord Inserted.");
    //c) Select All Entries Related to "Ramesh"
    sql = "select * from Employee where Name = ?";
    state = con.prepareStatement(sql);
    state.setString(1, "Ramesh");
    results = state.executeQuery();
    text = "" ;
    while(results.next())
    {
    text += results.getString(1) + "\t" + results.getInt(2) + "\n";
    }
    System.out.println("\nEntries Related To Ramesh.");
    System.out.println("NAME\tAGE");
    System.out.println(text);
    //d) To delete the record of Database
    sql = "delete * from Employee where Name = ?";
    state = con.prepareStatement(sql);
    state.setString(1, "ABC");
    state.executeUpdate();
    System.out.println("\nEntry Deleted.");

    System.out.println("\nContents Of Database :");


    sql = "select * from Employee";
    state = con.prepareStatement(sql);
    results = state.executeQuery();
    text = "" ;
    while(results.next())
    {
    text += results.getString(1) + "\t" + results.getInt(2) + "\n";
    }
    System.out.println("NAME\tAGE");
    System.out.println(text);
    results.close();
    state.close();
    con.close();
    }
    catch(Exception e)
    {
    System.out.println(e);
    }
    }
    }

    You might also like