Mysql-database

03:32
Java-Examples

                                                                                                                                                                                                                    Show all | Close all

  • Introduction

    • What is java

      Java is a programming language originally developed by James Gosling at Sun Microsystems (which has since merged into Oracle Corporation) and released in 1995 as a core component of Sun Microsystems' Java platform. The language derives much of its syntax from C and C++, but it has fewer low-level facilities than either of them. Java applications are typically compiled to bytecode (class file) that can run on any Java virtual machine (JVM) regardless of computer architecture. Java is a general-purpose, concurrent, class-based, object-oriented language that is specifically designed to have as few implementation dependencies as possible. It is intended to let application developers "write once, run anywhere" (WORA), meaning that code that runs on one platform does not need to be recompiled to run on another. Java is as of 2012 one of the most popular programming languages in use, particularly for client-server web applications, with a reported 10 million users.[10][11] The original and reference implementation Java compilers, virtual machines, and class libraries were developed by Sun from 1991 and first released in 1995. As of May 2007, in compliance with the specifications of the Java Community Process, Sun relicensed most of its Java technologies under the GNU General Public License. Others have also developed alternative implementations of these Sun technologies, such as the GNU Compiler for Java and GNU Classpath.

    • why we use java

      Java is a programming language and computing platform first released by Sun Microsystems in 1995. It is the underlying technology that powers state-of-the-art programs including utilities, games, and business applications. Java runs on more than 850 million personal computers worldwide, and on billions of devices worldwide, including mobile and TV devices.
      Why do I need Java?
      There are lots of applications and websites that won't work unless you have Java installed, and more are created every day. Java is fast, secure, and reliable. From laptops to datacenters, game consoles to scientific supercomputers, cell phones to the Internet, Java is everywhere!

    • Usage

      Java technology is a high-level programming and a platform independent language. Java is designed to work in the distributed environment on the Internet. Java has a GUI features that provides you better "look and feel" over the C++ language, moreover it is easier to use than C++ and works on the concept of object-oriented programming model. Java enable us to play online games, video, audio, chat with people around the world, Banking Application, view 3D image and Shopping Cart. Java find its extensive use in the intranet applications and other e-business solutions that are the grassroots of corporate computing. Java , regarded as the most well described and planned language to develop an applications for the Web. Java is a well known technology which allows you for software designed and written only once for an "virtual machine" to run on a different computers, supports various Operating System like Windows PCs, Macintoshes, and Unix computers. On the web aspect, Java is popular on web servers, used by many of the largest interactive websites. Java is used to create standalone applications which may run on a single computer or in distributed network. It is also be used to create a small application program based on applet, which is further used for Web page. Applets make easy and possible to interact with the Web page.

  • Introduction to mysql

    SQL or Structured Query Language) is a special-purpose programming language designed for managing data in relational database management systems (RDBMS). Originally based upon relational algebra and tuple relational calculus,[4] its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

    SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper, "A Relational Model of Data for Large Shared Data Banks".[5] Despite not adhering to the relational model as described by Codd, it became the most widely used database language.[6][7] Although SQL is often described as, and to a great extent is, a declarative language, it also includes procedural elements. SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standards (ISO) in 1987. Since then, the standard has been enhanced several times with added features. However, issues of SQL code portability between major RDBMS products still exist due to lack of full compliance with, or different interpretations of, the standard. Among the reasons mentioned are the large size and incomplete specification of the standard, as well as vendor lock-in.

  • Histroy

    SQL was initially developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM's original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.[8] The acronym SEQUEL was later changed to SQL because "SEQUEL" was a trademark of the UK-based Hawker Siddeley aircraft company.[9] In the late 1970s, Relational Software, Inc. (now Oracle Corporation) saw the potential of the concepts described by Codd, Chamberlin, and Boyce and developed their own SQL-based RDBMS with aspirations of selling it to the U.S. Navy, Central Intelligence Agency, and other U.S. government agencies. In June 1979, Relational Software, Inc. introduced the first commercially available implementation of SQL, Oracle V2 (Version2) for VAX computers. After testing SQL at customer test sites to determine the usefulness and practicality of the system, IBM began developing commercial products based on their System R prototype including System/38, SQL/DS, and DB2, which were commercially available in 1979, 1981, and 1983, respectively.

  • platform dependancy

    MySQL works on many different system platforms, including AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux, Mac OS X, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and Tru64. A port of MySQL to OpenVMS also exists.[30] MySQL is written in C and C++. Its SQL parser is written in yacc, and a home-brewed lexical analyzer.[31] Many programming languages with language-specific APIs include libraries for accessing MySQL databases. These include MySQL Connector/Net for integration with Microsoft's Visual Studio (languages such as C# and VB are most commonly used) and the JDBC driver for Java. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The HTSQL - URL-based query method also ships with a MySQL adapter, allowing direct interaction between a MySQL database and any web client via structured URLs.

  • Limitations

    Like other SQL databases, MySQL does not currently comply with the full SQL standard for some of the implemented functionality, including foreign key references when using some storage engines other than the 'standard' InnoDB.
    Triggers are currently limited to one per action / timing, i.e. maximum one after insert and one before insert on the same table.[38] There are no triggers on views.

    MySQL, like most other transactional relational databases, is strongly limited by hard disk performance. This is especially true in terms of write latency.[39] Given the recent appearance of very affordable consumer grade SATA interface Solid-state drives that offer zero mechanical latency, a fivefold speedup over even an eight drive RAID array can be had for a smaller investment.

  • Deployment

    MySQL can be built and installed manually from source code, but this can be tedious so it is more commonly installed from a binary package unless special customizations are required. On most Linux distributions the package management system can download and install MySQL with minimal effort, though further configuration is often required to adjust security and optimization settings.
    Though MySQL began as a low-end alternative to more powerful proprietary databases, it has gradually evolved to support higher-scale needs as well. It is still most commonly used in small to medium scale single-server deployments, either as a component in a LAMP-based web application or as a standalone database server. Much of MySQL's appeal originates in its relative simplicity and ease of use, which is enabled by an ecosystem of open source tools such as phpMyAdmin. In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.
    There are however limits to how far performance can scale on a single server, so on larger scales, multi-server MySQL deployments are required to provide improved performance and reliability. A typical high-end configuration can include a powerful master database which handles data write operations and is replicated to multiple slaves that handle all read operations.[42] The master server synchronizes continually with its slaves so in the event of failure a slave can be promoted to become the new master, minimizing downtime. Further improvements in performance can be achieved by caching the results from database queries in memory using memcached, or breaking down a database into smaller chunks called shards which can be spread across a number of distributed server clusters

  • How to install mysql

    Install MySQL

    This tutorial will show you how to install MySQL on Windows XP. So, go to the MySQL website and download the MySQL Community Server you must register on the site to download the file.
    File to download: Windows (x86, 32-bit), MSI Installer Essentials - Recommended if your operating system is a windows XP 64bit version use the Windows (x86, 64-bit), MSI Installer
    I will not list all the steps but the most important.
    On the downloaded MySQL double click and this will start the installation of MySQL and follow the instructions.
    Step1
    Select "I accept terms in the licence agreement" and click next: -
    Step2

    select the "custom" icon to change the path of the installation.
    Step3
    Now browse or navigate to the folder C:\server\mysql we want to install the files in this folder.
    Step4
    After the change press ok.
    Step 5
    Press install.
    step6
    Select a standerd configuration press next.
    step
    To install the mysql service, press next.
    step
    We need a password for MySQL database please enter a password, please remember the login name in most cases is root and the password your choosing, in my case I choose admin471.
    step
    It will execute all the commands we enter so press "execute"
    Step
    Now MySql database is finally installed.
    The final and last step is you need to do is to open php.ini file located in C:\server\php and uncomment the line.
    extension=php_mysql.dll
    by removing semicolon ; at the beginning. Save the file and close it.
    Restart the apache server by clicking on the apache icon in your taskbar.
    Useful tool is MySQL administrator and system tray monitor from MySQL GUI and you can download it from there website.
    Setup Mysql GUI:-
    Go to programs menu (MySQL) click on "MySQL Administrator" Login into your database as localhost - username and password go to "service control" and click on the tab "configure service" and change the path of the my.ini file to the correct location:
    C:\server\mysql\my.ini and click apply.
    guitools
    Running MySQL in command prompt:
    All commands are run from the command line and directory - "C:\server\mysql\bin\
    To stop MySQL Running:
    NET STOP MySQL
    To start MySQL Running:
    NET START MySQL
    Uninstall the MySQL Service:
    "C:\server\mysql\bin\mysqld" --remove

     

  • Advantages of mysql


    Reliability and Performance

    MySQL is very reliable and high performance relational database management system. It can used to store many GB's of data into database.
    Availability of Source


    MySQL source code is available that's why now you can recompile the source code. Cross-Platform support


    MySQL supports more then twenty different platform including the major Linux distribution .Mac OS X ,Unix and Microsoft windows. Large pool of Trained and Certified Developers


    MySQL is very popular and it is world most popular open source Database. So it is easy to find high quality staff around the world.
    Powerful Uncomplicated software

    The MySQL has most capabilities to handle most corporate database application and used to very easy and fast

  • Download Mysql

    Click here to download mysql installer
    Click Here to download latest version of mysql