Introduction to Java Programming By Y. Daniel Liang

This supplement covers the following topics: • Starting and Stopping MySQL Server • Connecting to MySQL • Creating User Accounts • Using MySQL • MySQL Administration • Accessing MySQL using Java NOTE: Please use MySQL 4.1 or high with this tutorial. 0 Introduction MySQL is a popular database with more than 4 million users. It is one of the fastest relational databases in the market. Many

companies are using it to support their websites, data warehouses, and business applications. MySQL was developed by a Swedish company named MySQL AB. The product is distributed under GNU General Public License (GPL). It can support multiple users concurrently on the network. Students can connect to a MySQL database server standalone on their own computer or from the network. You can download it free from http://dev.mysql.com/downloads/mysql/4.1.html. MySQL runs on Windows, Linux and Solaris. This tutorial demonstrates using MySQL from the Windows operating system. 1 Starting and Stopping MySQL Server If your database server is not started, you can start it by typing “net start mysql” from the MySQL bin directory as shown in Figure 1.1. You can stop it by typing the command net stop mysql. Start MySQL Stop MySQL Figure 1.1 © Copyright Y. Daniel Liang, 2005 8 You need to start MySQL only once after the installation. NOTE Your system may be set up to start MySQL automatically. In this case, you don’t have to restart it. NOTE By default, MySQL 4.1 is installed under c:Program FilesMySQL directory. If it is installed elsewhere on your system, please use an...

Website: cs.armstrong.edu | Filesize: 129kb
No of Page(s): 7
download: http://cs.armstrong.edu/liang/intro6e/supplement/Supplement4bMySQL.pdf

Introduction to Database Programming using PHP and MySQL

Introduction to Database Programming using PHP and MySQL Revision 1.1 June 14, 2010 by Aloysius Indrayanto (C) 2010 AnemoneSoft.com This document is multi-licensed under the Creative Commons Attribution Share-Alike (CC-BY-SA) license version 3.0 and the GNU Free Documentation License (GNU FDL) version 1.3 or later. Introduction to Database Programming using PHP and MySQL Page 1 of 12 1. Introduction LAMP (an acronym for Linux, Apache, MySQL, and PHP) is basically the most popular solution stack to deliver a general-purpose web

and application server. A solution stack is a full set of software components bundled together to provide a specific solution. Basically, the exact combination of software included in LAMP can be modified, depending on the need of the developer. For example, PHP can be replaced with Python, Perl, or other scripting language. In MS Windows, the package is called WAMP. In Mac OS, it is called MAMP. In Solaris, it is called SAMP. In OpenBSD it is called OpAMP, etc. PHP: Hypertext Preprocessor was invented by Rasmus Lerdorf in 1995. PHP is both a general-purpose programming language and a scripting language. PHP can be used to develop general-purpose applications (with and without graphical interface) as well as dynamic web pages or web applications. PHP is an interpreted language. Currently, PHP is maintained by The PHP Group. PHP is free and open source. MySQL Community Server is a free and open source RDBMS (Relational Database Management System) that runs as a server to provide a multi-user database system. The original MySQL was developed by Michael Widenius. Currently, MySQL is owned and sponsored by Sun Microsystems, a subsidiary of Oracle Corporation. MySQL has been used in large-scale products, such as Wikipedia, Google,...

Website: anemonesoft.com | Filesize: 147kb
No of Page(s): 13
download: http://anemonesoft.com/files/tutorial/idpm-handout-en.pdf

MySQL Tutorial - University of Ibadan

This tutorial is inspired by the examples of this book : MySQL™ The definitive guide to using, programming, and administering MySQL 4.1 and 5.0 Third Edition By Paul DuBois – SAMS March 2005 Design & Conception: P.K helped by A.D, L.W & S.S. A MySQL Tutorial Basic Database Terminology Many relational database concepts are really quite simple. In fact, much of the appeal of relational databases stems from the simplicity of their foundational concepts. Structural Terminology Within the database world,

MySQL is classified as a relational database management system (RDBMS). That phrase breaks down as follows: • The database (the "DB" in RDBMS) is the repository for the information you want to store, structured in a simple, regular fashion: o The collection of data in a database is organized into tables. o Each table is organized into rows and columns. o Each row in a table is a record. o Records can contain several pieces of information; each column in a table corresponds to one of those pieces. • The management system (the "MS") is the software that lets you use your data by allowing you to insert, retrieve, modify, or delete records. • The word "relational" (the "R") indicates a particular kind of DBMS, one that is very good at relating (that is, matching up) information stored in one table to information stored in another by looking for elements common to each of them. The power of a relational DBMS lies in its capability to pull data from those tables conveniently and to join information from related tables to produce answers to questions that can't be answered from individual tables alone. Here's an example that shows how a relational...

Website: ui-n2.loria.fr | Filesize: 453kb
No of Page(s): 58
download

PHP/MySQL Tutorial by Graeme Merrall

Unless you've been living on Mars for the last six to eight months, you've heard of open source software (OSS). This movement has got so much momentum that even the big boys are taking notice. Companies like Oracle, Informix, and a host of others are releasing their flagship database products for that poster child of the OSS movement, Linux. Having a massively complex RDBMS (relational database management system) is all well and good if you know what to do with it. But perhaps you are just getting into the world of databases. You've read Jay's article and you want to put up your own data-driven Web site. But you find you don't have the resources or desire for an ASP server or some pricey database. You want something free, and you want it to work with Unix. Enter PHP and MySQL. These two make up what must be the best combination for data-driven Web sites on the planet. You needn't take my word for it. An unofficial Netcraft survey shows that PHP usage has jumped from 7,500 hosts in June 1998 to 410,000 in March 1999. That's not bad. The combination was also awarded Database of the Year at Webcon98, where it received a lovely tiara. MySQL is a small, compact database server ideal for small - and not so small - applications. In addition to supporting standard SQL (ANSI), it compiles on a number of platforms and has multithreading abilities on Unix servers, which make for great performance. For non-Unix people, MySQL can be run as a service on Windows NT and as a normal process in Windows 95/98 machines. PHP is a server-side...

Website: www.robertobandini.it | Filesize: 175kb
No of Page(s): 9
download

Database Programming (JDBC) Slide Tutorial

Database Programming (JDBC) Lecture 5 2 Outline •Jav DB Conectivity (JDBC) overview •JDBC API Reading: Embeded SQL •Direct SQL (= ad-hoc SQL) is rarely used •In practie: SQL is embeded in some aliction code –user interaction, devices, programing logic •SQL code is embeded into a host language using special syntax 4 JDBC (Jav DB Conectivity) Java application { ... "SELECT ... FROM ... WHERE" ... } DBMS 5 xDBC •JDBC: standard for Jav language •OB: Open DataBase Conectivity –Language bindings for /+ 6 JDBC in Practise Java client code JDBC Database server (Postgres, Oracle, MySQL, SQL Server) SQL statements 7 JDBC Drivers Jav aplication JDBC- Driver manger Native Protcol driver JDBC- Net-driver Native API-driver JDBC-ODBC bridge DB Client libray DB- Midleware ODBC DB Client libray JDBC-API 8 Runing a JDBC Aplication Phase Task Relvant jav.sql clases Initialisation Procesing Termination Load river Create conection Generate SQL statements Proces result dat Terminate conection Relase dat structures DriverManger Conectio Statement ResultSet etc. Conection Statemet etc. 9 A Simple JDBC Aplication loadDriver getConection createStatement excute(SQL) Result handling More results ? closeStatement closeConection no yes import jav.sql.*; public las jdbctest { public static void main(String args[]){ try{ DriverManger.egisterDriver(new com.ysql.jdbc.Driver( ); Clas.forName(“com.mysql.jdbc.Driver”) onection con = DriverManger.getConection ("jdbc:mysql:/lsir-cis-pc1:306/is01", user", "paswd"); Statement stt = con.createStatement(); ResultSet rs = stmt.excuteQuery (”SELCT nae, number FROM pcmtable WHER number < 2"); while(rs.next() System.out.printl(rs.getString(1) + " ( + rs.getInt(2) + ")); stmt.close() con.close(); } catch(Exception e){ System.er.printl(e); } 10 Loading of Driver •Create an istance of the driver •Register driver in the driver manger •Explicit loading Class.forName(“com.mysql.jdbc.Driver”) •Sevral drivers can be loade and rgister 1 Example: Oracle and JDBC Class.forName("oracle.jdbc.driver.OracleDriver ”) Connection con = DriverManager.getConnection( "jdbc:oracle:thin:@dbaprod1:1544:SHR1_PRD", username, passwd);...

Website: lsirwww.epfl.ch | Filesize: 387kb
No of Page(s): 15
Download: http://lsirwww.epfl.ch/courses/iis/2009ss/slides/slides-5-JDBC.pdf

Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Application developers who are new to MySQL Connector/C++ but not to C++ programming and MySQL database, are the target audience of this tutorial. Listed below are the tools and technologies used to compile, build and run the examples in this tutorial. Database MySQL Server 5.1.24-rc C++ Driver MySQL Connector/C++ 1.0.5 MySQL Client Library MySQL Connector/C 6.0 Compiler Sun Studio 12 C++ compiler Make CMake 2.6.3 Operating System OpenSolaris 2008.11 32-bit CPU / ISA Intel Centrino / x86 Hardware Toshiba Tecra M2 Laptop Contents • MySQL C++ Driver Based on JDBC 4.0 Specification • Installing MySQL Connector/C++ • Runtime Dependencies • IDE for Developing C++ Applications • Create the City Table in the test Database for Code Examples • Testing the MySQL Database Connectivity With the Connector/C++ • Using Prepared Statements • Using Transactions • Accessing Result Set Metadata • Accessing Database Metadata • Accessing Parameter Metadata from a PreparedStatement Object • Catching Exceptions • Debug Tracing with MySQL Connector/C++ • For More Information • About the author • Appendix I: Installing MySQL Connector/C++ from Source Copyright © 2009 MySQL • Reprint by permission only 2 MySQL C++ Driver Based on JDBC 4.0 Specification MySQL Connector/C++ is one of the latest...

Website: docs.huihoo.com | Filesize: 320kb
No of Page(s): 36
Download: http://docs.huihoo.com/mysql/mysql-apps-using-connector-and-cpp.pdf

Linux to Solaris Administrators Guide

The aim of the Linux to Solaris Administrator Guide is to give Linux administrators the information and guidance they'll need to make a successful transition to using Solaris 10. The Linux to Solaris Administrators Guide is not intended for a first time system administrator. The guide assumes a certain amount of background administering a Linux system.
While similar in many respects there are still quite a few differences between a Linux and Solaris machine including commands, file systems and heritage.
These differences can be as simple as a renamed configuration file to the more complicated alternate meanings for command line arguments.
This chapter presents an overview of some of the differences between Linux and Solaris.
Topics Covered: Architectural Similarities and Differences, File System Organization, Locations of Common used Commands, Location of Configuration Files, Location of Log Files, Script Migration, Architectural Similarities and Di?erences
While similar in many respects there are fundamental differences between the Solaris and Linux operating environments.
Throughout the development of Solaris the focus has been on compatibility. Compatibility with previous releases (binaries compiled on Solaris 8 will run on Solaris 10) and compatibility with de jure standards such as POSIX. Linux has had the freedom to establish new de facto standards (such as extended command line syntax, with a strong consistency among commands). However, judicious use of the included GNU utilities, the proper command line settings, downloads of additional utilities, and some acquired knowledge such as this guide and sites such as the Rosetta Stone1 will mitigate most differences.
Many of the system similarities can be attributed to the implementation of different system standards. These standards make it a lot easier to move applications between Operating Systems. Solaris conforms to the POSIX, SVID and XPG standards.
Although many commands may have the same name, the implementation and command line options may have changed. The man pages should be consulted to verify the functionality of commands.

download: http://www.sun.com/software/solaris/sysadmin_guide.pdf