...TUTORIAL KONEKSI JAVA KE ORACLE Yufis Azhar, S.Kom – Teknik Informatika – UMM Untuk mengkoneksikan java ke oracle dibutuhkan suatu lib tambahan yaitu “ojdbc14.jar” yang bisa didapatkan di folder “C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib”. Import lib ini di project Anda atau letakkan lib tersebut di folder jdk yg terinstal di computer Anda. Misal copykan lib tadi di folder “C:\Program Files\Java\jdk1.6.0_20\jre\lib\ext”. Pertama-tama buatlah sebuah database di oracle dg nama “praktikum”. Kemudian buat sebuah table dengan nama mahasiswa beserta atribut-atributnya seperti gambar di bawah : Mahasiswa NIM char(8) Nama varchar(50) Tgl_lahir date Alamat varchar(100) Koneksi java ke oracle bisa dilakukan dengan GUI (melalui editor semacam netbeans) atau dengan menggunakan code. Untuk tutorial kali ini kita akan menggunakan kode agar lebih fleksibel (tidak tergantung editor yg digunakan). Untuk itu,buatlah sebuah file dengan nama “koneksi_database.java” kemudian tuliskan list code berikut : import java.sql.*; public class koneksi_database { String db = "jdbc:oracle:thin:@localhost:1521:praktikum"; String user = "sys"; String pass = "bismillah"; Connection c = null; Statement s = null; public koneksi_database(){} public Statement koneksi(){ try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { c = DriverManager.getConnection(db,user,pass); ...
Words: 575 - Pages: 3
...Business Intelligence Applications Paul Villela CSCI 4304:Database Systems Dr. Carolyn W. Green 2 December 2014 Business Intelligence Applications On the May 4th, 2014 episode of Mad Men (appropriately entitled “The Monolith”, a clever nod to the iconic black monolith which provides the impetus for the evolutionary leap from beast to man in Arthur C Clarke’s novel “2001: A Space Odyssey”) Sterling Cooper & Partners, the fictional ad agency around which the show revolves, purchases and installs a brand new IBM 360 computer. While the vast majority of the office greets the massive, expensive machine with much apprehension (“What man lay on his back counting stars and thought about a number?” asks Don Draper, head of the Creative Department (played by John Hamm)) (Stevenson, 2014), Senior Partner and visionary Jim Cutler (played by Harry Hamlin) understands the power and potential of just such a machine, particularly in the field of advertising. Sterling Cooper & Partners gain an edge that their competition would not have for several more years, as well as a service they can offer their customers, one many of whom would not provide for themselves for even longer. What Jim Cutler was envisioning was a strategic idea currently referred to as Business Intelligence. A Brief History of Business Intelligence The concept of Business Intelligence (BI) began as a direct descendent of an information system called the Decision Support System (DSS), a system used for complex...
Words: 2993 - Pages: 12
...Getting Started with Oracle This is a small tutorial for Oracle 8i to teach the basics of SQL. Follow the steps and Oracle will be fun for you. Step 1: Click the Start button, select Programs, then select SecureCRT 3.x. This will open up the quickconnect dialog box of SecureCRT. Select 1. Protocol as: SSH2 2. Hostname: babbage2.cs.iit.edu 3. SSH Server: Standard As depicted in figure below. On clicking connect at this point will bring up another dialog. Select “Accept and Save” to bring up a window asking username and password for Unix. Upon entering valid username and password, you should now see unix bash prompt. Now type just “sqlplus” at bash prompt to connect to Oracle. It will prompt for username and password for oracle. Upon entering valid username and password, you should now see SQL prompt as: SQL> 1 You are now connected to oracle through SQLPlus client installed on Unix Machine (babbage2.cs.iit.edu). Have fun. Also, if you want to find more information on installing oracle on your personal machine, go to www.oracle.com. Remember at SQL> prompt, after every sql command, don’t forget to put a semicolon(;). A SQL statement is the statement that complies with the syntax rule of SQL. A list of SQL statements such as create, delete, insert, select, and update will be frequently used. The SQL*PLUS commands are the auxiliary set of commands that may be only recognized by ORACLE SQL*PLUS. Frequently used commands in ORACLE SQL*PLUS interface are clear, describe, edit...
Words: 1881 - Pages: 8
...SQL Tutorial SQL TUTORIAL Simply Easy Learning by tutorialspoint.com tutorialspoint.com i ABOUT THE TUTORIAL SQL Tutorial SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. Audience This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages. Prerequisites Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. Copyright & Disclaimer Notice All the content and graphics on this tutorial are the property of tutorialspoint.com. Any content from tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the accuracy of the site or its contents including this tutorial. If you discover that the tutorialspoint.com site or this tutorial content contains some errors, please contact us at webmaster@tutorialspoint.com TUTORIALS POINT Simply Easy Learning Table of Content SQL Tutorial .................................................................
Words: 39505 - Pages: 159
...course tutorials visit www.tutorialrank.com DBM 502 Individual Assignment: Implementing an Enterprise DBMS DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 DBM 502 Individual Assignment: Data Dictionary DBM 502 Individual Assignment: Database Security DBM 502 Learning Team Assignment: DBMS Implementation Plan ---------------------------------------------------------------------------- DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 (UOP) For more course tutorials visit www.tutorialrank.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses Refer to “Standards for Written Work” and “Standards•your results. for Presentations” in your Program Handbook, which can be accessed through the student Web site. ------------------------------------------------------------------- DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 (UOP) For more course tutorials visit www.tutorialrank.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2...
Words: 548 - Pages: 3
...SQL Tutorial SQL TUTORIAL Simply Easy Learning by tutorialspoint.com tutorialspoint.com i ABOUT THE TUTORIAL SQL Tutorial SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language. This tutorial will give you quick start with SQL. Audience This reference has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages. Prerequisites Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. Copyright & Disclaimer Notice All the content and graphics on this tutorial are the property of tutorialspoint.com. Any content from tutorialspoint.com or this tutorial may not be redistributed or reproduced in any way, shape, or form without the written permission of tutorialspoint.com. Failure to do so is a violation of copyright laws. This tutorial may contain inaccuracies or errors and tutorialspoint provides no guarantee regarding the accuracy of the site or its contents including this tutorial. If you discover that the tutorialspoint.com site or this tutorial content contains some errors, please contact us at webmaster@tutorialspoint.com TUTORIALS POINT Simply Easy Learning Table of Content SQL Tutorial ......................................
Words: 38789 - Pages: 156
...Systems Design, Operating Systems, Programming, Network Project Management, Software Development Life Cycle, Information Technology Systems, Expert Systems & Artificial Intelligence, Computer And Cyber Forensics, Internet Enabled Application System. PROFESSIONAL CERTIFICATIONS Oracle Database SQL Certificate 2014 Oracle Database 11g Certified Associate Administrator 2015 Cisco Certified Network Associate 2015 TRAINING CERTIFICATIONS 2014 Certificate in PC Support and Maintenance Certificate in Linux &Oracle Database Administration (NIIT) Certificate in Information Technology Infrastructure Library INNOCENT COMPREHENSIVE HIGH SCHOOL 2008 West Africa Senior Secondary Certificate Examination (WASSCE) WORK EXPERIENCE 1. Teaching (NYSC) August (2014) – August (2015), Community Secondary School Amalla, Enugu/Nigeria * Taught computer science * Took the initiative to develop the appreciation to information technology among students in the school 2. Teaching (Lecturing) Assistant, June–August (2012), Valley View University, Ghana. * Facilitate a discussion section or tutorial; assisting in conducting research * Hold weekly office hours; grade assignments and exam scripts; * Keep records of lecture attendance, and prepare answer keys or supplementary notes. LEADERSHIP and HONOURS * Organizer, Valley view University Computer Science Association (VVU...
Words: 360 - Pages: 2
...Review Guide Table of Contents OOPS ................................................................................................................................................................................................. 2 JAVA .................................................................................................................................................................................................. 3 C#....................................................................................................................................................................................................... 4 Database/SQL ................................................................................................................................................................................... 6 Web Development............................................................................................................................................................................ 7 SDLC................................................................................................................................................................................................... 9 UML ................................................................................................................................................................................................. 11 1 Review Guide OOPS Resources: http://en.wikipedia...
Words: 2407 - Pages: 10
...Introduction to Structured Query Language This page is a introductory tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. The SQL used in this document is "ANSI", or standard SQL, and no SQL features of specific database management systems will be discussed until the "Nonstandard SQL" section. It is recommended that you print this page, so that you can easily refer back to previous examples. Also, you may be interested in joining the new SQL Club on Yahoo!, where you can read or enter messages in a SQL forum. Table of Contents Basics of the SELECT Statement Conditional Selection Relational Operators Compound Conditions IN & BETWEEN Using LIKE Joins Keys Performing a Join Eliminating Duplicates Aliases & In/Subqueries Aggregate Functions Views Creating New Tables Altering Tables Adding Data Deleting Data Updating Data Indexes GROUP BY & HAVING More Subqueries EXISTS & ALL UNION & Outer Joins Embedded SQL Common SQL Questions Nonstandard SQL Syntax Summary Exercises Important Links Basics of the SELECT...
Words: 11641 - Pages: 47
...MS SQL? It is a relational web hosting database that is used to store web site information like blog posts or user information. MS SQL is the most popular type of database on Windows servers. It is not free but it has many advanced features that make it suitable for businesses. What is MS SQL capable of? In basic terms, an MS SQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, most versions of MS SQL have the following features: • Buffer management • Logging and Transaction • Concurrency and locking • Replication services • Analysis services • Notification services • Integration services • Full text search service • Stored procedures • Triggers • Views • Sub-SELECTs (i.e. nested SELECTs) What is MS SQL used for? MS SQL is the database of choice for web applications on a Windows platform (using .NET or ASP). These languages make is extremely easy to connect to a MS SQL database. It is also used for many popular content management systems and other scripts. Learn more about what is MS SQL on its official website. They have comprehensive learning material. You should also check out the SQL tutorial on W3Schools and some articles on the SQL Community Server blog. If you are looking for a web host that supports MS SQL, look at our comparison of the best MS SQL Web...
Words: 2647 - Pages: 11
...STRUCTURED QUERY LANGUAGE (SQL) STRUCTURED QUERY LANGUAGE: SQL is a language used for getting information when used from a database and even updating the information from a database. SQL is certified by both American National Standard Institute and ISO standard and much of the database products support SQL. It is a Data Sub Language and used by a combination of two languages. They are: Data Definition Language (DDL) and Data Manipulation Language (DML) and the main way to access data are by using a DML command. SQL language was created in the IBM laboratories where new software was created and it is called System R. So in order to manage the entire data which is stored in System R the SQL language was created. Before SQL was named as SEQUEL and later it was renamed it as SQL. SQL widely supports users who are using distributed databases because it can run on different computer networks. SQL serves both industry and academic needs. With more advancement of the database technology SQL applications are used for their regular use. For example: MySQL, SQLite, PostgreSQL and Oracle. SQL developers develop some commands to the corresponding database management systems and it is usually executed by a SQL command-line interface (CLI). It uses a set of commands like Insert, select, update, delete, create and drop. SELECT COMMAND: The SQL SELECT command is used to select data from a given SQL DATABASE. It is used to retrieve...
Words: 1156 - Pages: 5
...WEB 407 Complete Course Material(UOP) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 3 Times, Rating: A+ WEB 407 Week 1 DQs WEB 407 Week 1 Individual Assignment / Encrypted Login Page WEB 407 Week 2 DQs WEB 407 Week 2 Individual Assignment Database WEB 407 Week 3 DQs WEB 407 Week 3 Individual Assignment Database Justification Memo WEB 407 Week 4 DQs WEB 407 Week 5 DQs WEB 407 Week 5 Learning Team Assignment Web Application -------------------------------------------------------- WEB 407 Week 1 DQs(UOP) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 0 Times, Rating: No Rating What is the importance of cookies on security, page lifecycle management, and usability? Write a 200- to 300-word short-answer response to the following: Why is it important to use standards such as Secure Sockets Layer (SSL) when managing secure data on the Internet? What do SSL and other security measures provide to users and organizations? ------------------------------------------------------ WEB 407 Week 1 Individual Assignment / Encrypted Login Page(UOP) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 2 Times, Rating: A+ Create a well-designed and aesthetically-pleasing login page. You may use a login page that you have created in a prior course. Alternatively, you may add your own basic CSS to the Login Page template provided on the student website. Apply a basic client side JavaScript®...
Words: 534 - Pages: 3
...systems are web-based to facilitate "anytime, anywhere" access to learning content and administration. Convenient tools for student LMS usually is allowed student to tracking e-learning course and content, registration, group discussion, get the latest notice from lecturer and may allow for the management of instructor-led training classes. Example, student can simply log in to LMS check the group to see whether there have any new notice or new note to download or not. Interact tools LMS may also provide student with the ability to interact with each other by video conferencing, threaded discussion, and discussion forum. Example, lecturer can make a tutorial class in LMS with the convenient of video conferencing so that student will need not to step out from their house but just access to LMS and attend the tutorial class. Publish courses LMS also let the management to publish course and place them in an online catelog or assign courses to learner. Learner can log in to LMS by using a browser and launch the course.It provides online reports for each course and learner. Performance management systems LMS is not only make for student but also suitable for an organization. LMS provider include "performance management systems" which include employee appraisal, competency management , succession planning, and multi-rater assessments example like 360 degree review. Some of the commercial market also include the recruitment and reward function. LMS normally are...
Words: 324 - Pages: 2
...Oracle Forms 10g : Demos, Tips and Techniques Oracle Forms 10g release 2 : Demos, Tips and Techniques Home page 1. Introduction Here is a collection of Oracle Forms 10g sample dialogs extracted from a complete Oracle Forms tutorial. This tutorial has been written in French and it would be too time consuming to translate it all in English. This is the reason why I have only extracted and translated these sample dialogs. The purpose of this article is not to teach how to build a new form from scratch. It intends to show some of the main advanced features of the product. To clearly understand in details how these dialogs work, you will have to open them in the Forms Builder and examine them thoroughly. However, in this article, I am going to explain the best I can the most important mechanisms of each sample. These sample have been tested with an Oracle Forms 10g release 10.1.2.0.2 on an Oracle Database 10g Express Edition Release 10.2.0.1.0. 2. Description of the sample dialogs 2.1 Main screen TUTO_FORMS.FMB This dialog is the entry point of the samples. Click on a button to start the corresponding dialog. file:///D|/Cours/tuto_forms/paper/PDFtutoforms10g.htm (1 sur 24)29/05/2006 23:09:57 Oracle Forms 10g : Demos, Tips and Techniques 2.2 Canvases TEST_CANVAS.FMB This sample shows three types of canvas : § § § The content canvas (light green) The stacked canvas (white) The tab canvas (dark green) Stacked canvas A stacked canvas is displayed atop—or stacked on—the content...
Words: 3526 - Pages: 15
...is also available as a concatenated page, suitable for printing or saving as a PDF for offline viewing. MET CS669 Database Design and Implementation for Business This course uses the latest database tools and techniques for persistent data and object-modeling and management. Students gain extensive hands-on experience with exercises and a term project using Oracle, SQL Server, and other leading database management systems. Students learn to model persistent data using the standard Entity-Relationship model (ERM) and how to diagram those models using EntityRelationship Diagrams (ERDs), Extended Entity-Relationship Diagrams (EERDs), and UML diagrams. Students learn the standards-based Structured Query Language (SQL) and the extensions to the SQL standards implemented in Oracle and SQL Server. Students learn the basics of database programming, and write simple stored procedures and triggers. The Role of this Course in the MSCIS Online Curriculum This is a core course in the MSCIS online curriculum. It provides students with an understanding and experience with database technology, database design, SQL, and the roles of databases in enterprises. This course is a prerequisite for the three additional database courses in the MSCIS online curriculum, which are CS674 Database Security, CS699 Data Mining and Business Intelligence and CS779 Advanced Database Management. By taking these three courses you can obtain the Concentration in Database Management and Business...
Words: 10777 - Pages: 44
