jdbc

Overview

Three Tiers For J2ee
Three Tiers For J2se
The Case Study
Design Patterns
Domain And Service Models
Database And SQL Fundamentals

What Is Database?

What Is JDBC?

How To Start Oracle10g

How To Install Oracle Express Edition

Relational Databases And SQL
Database, Schema, Tables, Columns And Rows
DDL-Creating And Managing Database Objects
DML-Retrieving And Managing Data
Sequences , Stored Procedures
Using SQL Terminals
JDBC Fundamentals

Starting JDBC Ppt

JDBC Workflow

ODBC (Open Data Base Connectivity)

Explain How JDBC Client Getting Connected To Database Server?

Uuderstanding The JDBC Driver

Type -1 Driver

JDBC Type -2 Driver

Type -4 Driver

Type 3 Driver

What Is JDBC Is JDBC Api?

Using JDBC In The Project (Project Architecture)

Where Do We Use Dao Design Pattern

Introduction To Driver Manager

Java SQL Packages

Driver Class Ppt

Driver Manager Class Ppt

Class Ppt

Connection Interface Ppt

Making A Connection
Creating And Executing A Statement

JDBC Program To Create A Table In Mysql

JDBC Program For Inserting The Values Into The Table

Different Ways To Connecting To The Database Ppt

Inserting Into The Table Using Url

Inserting The Values Connecting To The Db Using User Id And Password In Mysql
Retrieving Values From A Resultset

JDBC Example Program For Resultset Object Using Normal Statement

JDBC Program For Retrieving The Values (Data) From The Database Using Mysql

Resultsetmetadata

JDBC Program For Using Resultsetmetadata

JDBC Program For Using Resultsetmetadata(Getdata Ppt)

Example To Demonstrate Scrollable Resultset

Scrollable Resultset:JDBC Program For Adding A New Record

Properties Class
SQL And Java Datatypes
Creating And Updating Tables

JDBC Program For Updating The Record (One Field)

JDBC Program Removing The Record

JDBC Program For Deleting A Record

Handling SQL Exceptions And Proper Cleanup

Handling SQL Warning

Advanced JDBC

SQL Escape Syntax

Conditional (If) Statements

Using Prepared Statements

JDBC Program Using Preparedstatement

Using Callable Statements

Callable Statement Ppt

What Is Resultset?

Resultsets Ppt

Scrollable Result Sets

Updatable Result Sets

Transactions , Commits, Rollbacks, And Savepoints

Batch Processing

JDBC Program For Batchupdate Using Prepared Statement

JDBC Program Far Batchupdates Ex2

JDBC Program For Reading The Data From Excel Sheet

Reading Data From The Excel Sheet Ppt

JDBC Program For Reading The Content From The Note Pad File

Blob:

JDBC Program For Inserting The Image File Into The Database

Joining

JDBC Program By Using Joins

Indexing Ppt

Resultsetmetadata Interface

Database Metadata

Databasemetadata Interface Ppt

Introduction To Row Sets

Row Sets In Gui And J2ee Programming

Advantages Of Rowsets , Rowset Specializations

Use Of Cachedrowsets

JDBC Classes And The Java.Sql

Drivermanager And Datasource Connection

Statement,

Preparedstatement,

Callablestatement

Callablestatement Ppt

Resultset

Javax.Sql Package

Rowsets

Connecting To Databases

Connection Pool Ppt

Selecting And Installing A Database Driver

Connecting To The Database Via A Network Address

Connecting To The Database Based On Information Supplied By Jndi (The Java Naming And Directory Interface)

Using The Java.Sql.Datasource Class

Increasing Performance With Connection Pooling

Exception In JDBC

Opening And Closing The Connection

Handling Classnotfoundexception And SQLexception

JDBC Design Patterns

Overview Of Client Tier, Presentation Tier, Business Tier, And Resource Tier Patterns

The Data Access Object Pattern

The Value Object Pattern

The Model-View-Controller Pattern

Write a java program to insert a record in dept database by accepting the data from keyboard at runtime using dynamic queries?
import java.sql.*;
import java.io.*;
class InsertRecRun {
public static void main(String[] args) {
   try {
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    System.out.println("DRIVERS LOADED...");
    Connection con =
    DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:
     BudDinu "," scott "," tiger ");
     System.out.println("CONNECTION OBTAINED...");
     PreparedStatement ps = con.prepareStatement("insert into dept values
    (?,?,?)");
     DataInputStream dis = new DataInputStream(System.in);
     System.out.println("ENTER DEPARTMENT NUMBER : ");
     String s1 = dis.readLine();
     int dno = Integer.parseInt(s1);
     System.out.println("ENTER DEPARTMENT NAME : ");
     String dname = dis.readLine();
     System.out.println("ENTER LOCATION NAME : ");
     String loc = dis.readLine(); ps.setInt(1, dno);
     ps.setString(2, dname);
     ps.setString(3, loc);
     int i = ps.executeUpdate();
     System.out.println(i + "ROW(s) INSERTED...");
     con.close();
    } catch (Exception e) {
     e.printStackTrace();
    }
   } // main
} // InsertRecRun

jdbc

OTHER BLOGS

Sunday 11 December 2016

Syllabus

Friday 3 June 2016

Write a java program to insert a record in dept database by accepting the data from keyboard at runtime using dynamic queries?

Wednesday 11 December 2013

VIEWS PPT

Starting JDBC PPT

Properties class

Java sql packages

CallableStatement ppt