Java database Programming

Document Sample
Java database Programming Powered By Docstoc
					Java database Programming
   JDBC
       Trademarked name of a Java API that
        supports Java programs that access relational
        databases
       Stand for Java DataBase Connectivity
       Provides Java programmers with a uniform
        interface for accessing and manipulating a
        wide range of relational databases
                  Java Program

                   JDBC API


 mySQL JDBC        Oracle JDBC      JDBC-ODBC
    Driver            Driver        Bridge Driver

                                     Microsoft
                                    ODBC Driver


Local or remote   Local or remote   MicroSoft Access
  Mysql DB          Oracle DB          Database
Developing Database Application
Using JDBC
   JDBC API is a Java Program interface to generic
    SQL database that enables Java developers to
    develop DBMS-independent Java application
    using a uniform interface
   JDBC API consists of classes and interfaces for
    establishing connections with database, sending
    SQL statements to databases, processing the
    results of the SQL statements
   Four key interfaces: Driver, Connection,
    Statement, and ResultSet
   Loading drivers
       Class.forName(“JDBCDriverClass”);
       Access: sun.jdbc.odbc.JdbcOdbcDriver
       Mysql: com.mysql.jdbc.Driver
       Oracle: oracle.jdbc.Driver.OracleDriver
   Establishing connection
       Connect conn =
        DriverManager.getConnection(databseURL);
       Access:jdbc:odbc:dataSource
       Mysql: jdbc:mysql://hostname/dbname
       Oracle:jdbc:oracle:thin:@hostname:port#:oracleDSSID
   Creating statements
       Statement st = conn.createStatement();
   Executing statement
       St.executeUpdate(String sql)
       St.executeQuery(String sql) return result in
        ResultSet
       ResultSet rs = st.executeQuery(“select
        firstName from Student where lastName
        =„Smith‟ “);
   Processing ResultSet. The resultSet
    maintains a table whose current row can be
    retrieved.
   Res.next() move to the next row
   Various methods to retrieve values
   Res.getString(1)
   Res.getString(“firstName”)
Servlet and JSP (java Server Page)
   Are Java program that run on a web server
   Can be used to process client request or produce dynamic
    web pages.
   public class SomeServlet extends HttpServlet {
   public void doGet(HttpServletRequest request,
    HttpServletResponse response) throws ServletException,
    IOException { // Use "request" to read incoming HTTP
    headers (e.g. cookies) // and HTML form data (e.g. data
    the user entered and submitted) // Use "response" to
    specify the HTTP response line and headers // (e.g.
    specifying the content type, setting cookies). PrintWriter
    out = response.getWriter(); // Use "out" to send content to
    browser } }
Multimedia
   Playing audio
       With Java 2, you can play sound files in the
        .wav, .aiff, .midi, .au and .rmf format
   Running audio on a separate thread
   Displaying images