oracle programming n.
Download
Skip this Video
Download Presentation
Oracle Programming

Loading in 2 Seconds...

play fullscreen
1 / 14

Oracle Programming - PowerPoint PPT Presentation


  • 114 Views
  • Uploaded on

Oracle Programming. Instructor: Xintao Wu. architecture. JDBC (Java Database Connectivity ). JDBC enables programmers to use SQL queries from within java programs to access databases. JDBC provides transparent access to relational databases from different vendors. JDBC. JDBC steps.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle Programming' - lorimer


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
oracle programming

Oracle Programming

Instructor: Xintao Wu

Xintao Wu

architecture
architecture

Xintao Wu

jdbc java database connectivity
JDBC (Java Database Connectivity )
  • JDBC enables programmers to use SQL queries from within java programs to access databases.
  • JDBC provides transparent access to relational databases from different vendors.

Xintao Wu

slide4
JDBC

Xintao Wu

jdbc steps
JDBC steps
  • Create the database in your dbms
  • Register the database as a data source
  • Import java.sql.* at the beginning of your java file.
  • Connect to a JDBC source
    • Connection con = DriverManager.getConnection(“jdbc:oracle:thin:@cci-ora02.uncc.edu:1521:class”,”user”,”passwd”)
  • Create an SQL statement
    • Statement stmt = con.createStatement();
    • stmt.executeUpdate("INSERT INTO sailor VALUES(22,'dustin',7,45.0)");

Xintao Wu

jdbc step
JDBC Step
  • Execute the statement
    • ResultSet rs = stmt.executeQuery(“Select * from …”)
  • Parse the result
    • rs.next(), rs.getFloat
    • ResultSetMetaData contains the information about column
  • Close the statement and connection
    • stmt.close()
    • con.close

Xintao Wu

useful resources
Useful resources
  • JDBC tutorial http://java.sun.com/docs/books/tutorial/jdbc/index.html
  • UNCC COIT

https://cci-wiki01.uncc.edu/servlets

  • Example http://www.sis.uncc.edu/~xwu/WEB-INF/classes/SampleJDBC.java

Xintao Wu

java servlets
Java Servlets
  • Web servers understand requests for pages in http and return their response in HTML format
  • Static html vs. dynamic html
    • The webpage is based on data submitted by the user
    • The data changes frequently (a weather-report)
    • Web pages uses information from a database(stock)
    • Maintain separate data about each client for personalization purposes(cookies).
  • Java servlets are programs that extend the functionality of a web server and useful for building dynamic web pages on the fly.

Xintao Wu

java servlet advantage
Java Servlet Advantage
  • Works as a lightweight thread directly with the JVM rather than create a new process
  • Load once to memory and used by all threads
  • Share data among each other

Xintao Wu

how to run servlets
How to run servlets
  • Your machine, Java servlet development kit(JSDK)
  • COIT
    • consult the webpage

https://cci-wiki01.uncc.edu/servlets

    • Consult TA

Xintao Wu

examples
Examples
  • HelloWorld
    • http://coit-servlet02.uncc.edu:8080/xwu/HelloWorld
    • http://www.sis.uncc.edu/~xwu/WEB-INF/classes/HelloWorld.java
  • More examples
    • DBServlet
    • http://coit-servlet02.uncc.edu:8080/xwu/DBServlet.html
    • http://www.sis.uncc.edu/~xwu/WEB-INF/classes/DBServlet.java

Xintao Wu

jdbc and servlet
JDBC and Servlet
  • Summary:
  • 1. Download PUTTY and WinSCP
  • 2. Download HelloWorld, SampleJDBC and DBServlet source code
  • 3. Modify them and upload to your own space
  • 4. Compile and run it

Xintao Wu

some links
Some links
  • https://cci-wiki01.uncc.edu/servlets
  • http://www.sis.uncc.edu/~xwu/5160/JDBC-Servlet.doc

Xintao Wu

summary
Summary
  • 3-tire architecture
  • APIs such as JDBC and ODBC introduce a layer of abstraction between application and DBMS
  • Choose your language from JSP, Servlet, ASP, VC++, VB.

Xintao Wu