Wednesday, August 26, 2009

JAVA Prelude

JAVA
At the beginning Java was designed to control electronic devices remotely, then it has been taken again to make it good programming language for the network. It is interpreted and compiled at the same time. It can be used both for applet (small Java applications embedded in html documents) development or general application development.
Java code is designed for a virtual machine ( a machine that doesn' t exist ) based in the POSIX specification, although some Java processors are being designed that will able to run Java code directly.



The advantage of using a virtual machine is that you can design it as simple as you want. Then implementing interpreters for several machines you can run the same code over different platforms , one of the best things of this language.
Java code (bytecodes) are really small, ideal for transmission over the network.



The System class embeds some of the virtual machine specifications, while Runtime class has the specific-platform behavior.






Applet design is only one of the possible applications of Java.
Java applets are, basically, Java programs embedded in a Internet browser page.
The program can be as complicated as you want, but there are some security restrictions, for example it is impossible to write to the local drive, or get the user name of the system (thing that you can do in a local, not applet, Java application ).

JavaScript vs Java.
JavaScript can be used to add simple programs and functions to HTML pages. It's not compiled, so the performance is not very high.
Another difference is that JavaScript has to be embedded with the html page, the code has to be inside the same file, Java applets are in different .class files.
JavaScript has a limited amount of API functions, too far in complexity and extension from the Java API.
How to begin to work with Java.
First you need two things :
-The Java development kit for your platform, provided by JavaSoft.
-Some kind of graphical environment to work with, like JPAD or Kawa.
( JDK is only a command oriented, and really difficult to work with in a medium o large size project. )
Then you should read the documentation about the Java language and the Java API, in order to begin to write Java code.

MYSQL Info

  1. 1. Basics Of MySQL
  2. 2. * What is MySQL? MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.
  3. 3. * Installing MySQL on Windows In this section you will learn how to install MySQL 5.0 on windows system. The MySQL 3.21 was the first version for the windows. Windows installer of MySQL includes auto installer with Configuration Wizard that support for easy installation.
  4. 4. * MySQL Configuration In this lesson you will read about the configuration of MySQL . The MySQL server configuration normally started during installation process .
  5. 5. * Creating account, changing root password and deleting anonymous accounts This MySQL provide the new creating account or you want to change the password then make new user .This lesson you learn how to create new password.
  6. 6. * Understanding various MySQL Executable files This lesson you learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".
  7. 7. * MySQL User Interfaces In this section you will read how to define the function Interface, Create function syntax , Drop function Syntax. You can add function with the help of UDF (user defined function) interface. These are complied as object files. After that they can be added to and removed from the server dynamically by using create and Drop function statements.
  8. 8. * MySQL Monitoring In this section you can learn how to monitor the MySQL Database. MySQL system store the all of the critical data and easy to maintenance in every cases. It is very popular database and make quick easy to store or its access, and update Data. Working with MySQL Database
  9. 9. * Creating/Deleting databases In this section you will learn how to create and delete the database in MySQL. MySQL provides the both commands. In this section you can learn the following things : Creation and Selection of database, Creation of table, Load the data into the table.
  10. 10. * MySQL Column type database In this session you will learn how to support number of column in MySQL . MySQL supports the numeric type , Date and time type, and String type (char) database.
  11. 11. * Database Designing There are some rules are available for designing the database. These are : MySQL use the alpha numeric character, MySQL limited the 64 characters, MySQL use the underscore (_) to separate word, MySQL is entirely lowercase word, MySQL use the plural table name to indicate multiple value store and singular column names. In this section you will also learn about the Normalization.
  12. 12. * Identifiers & Qualifiers In this section you will learn about describing the allowable syntax for identifiers in MySQL. The identifiers are Database, table, index, column and alias name. The following table describes the maximum length for each type of identifier.
  13. 13. * Operators & Functions In this section we are describing the function and operators, which are allowed for writing expressions in MySQL. If any expression, which contains NULL then it always produce a NULL value unless else indicated in the documentation for a particular function or operator.
  14. 14. * MYSQL String function In this section you can learn about the uses of MySQL String functions. These functions can be used to manipulate the string data. Here we have compiled the almost all String functions that you can use to learn more about string functions supported by MySQL. MySQL Queries
  15. 15. * SELECT Statement In this lesson you will be learn how to use SELECT statement in MySQL and you can also learn how to use SELECT statement with WHERE clause. The SELECT statement is used to retrieve the records from the table.
  16. 16. * Selecting All columns or specific columns In this section you will be learn how to create database and create a specific columns in MySQL. And you can also learn about Evaluation and Writing Expression.
  17. 17. * Data Definition Statements In this section we will describe you the syntax of most of the Data Definition statements supported by MySQL like CREATE DATABASE, CREATE TABLE, ALTER DATABASE, ALTER TABLE etc...
  18. 18. * Data Manipulation Statements Data Manipulation Statement is used to retrieve, insert, update and delete the records in a database. All database users will use these commands during routine operation of the database. In this section we are describing the all Data Manipulation Statements :
  19. 19. * Joins When you select the data from more than one table this is known as Joining. A join is a SQL query that is used to select the data from more than one table or views. When you define multiple tables or views in the FROM clause of a query the MySQL performs a join that linking the rows from multiple tables together.
  20. 20. * Views VIEW is a virtual table, which acts like a table but actually it contains no data. That is based on the result set of a SELECT statement. A VIEW consists rows and columns from one or more than one tables. A VIEW is a query that?s stored as an object. A VIEW is nothing more than a way to select a subset of table?Columns

ACER Laptop Solutions for VISTA OS

i Friends,

Recently I have installed VISTA os in my Laptop. After I faced some issues with Acer Logitech Orbicam. Not only with those softwares some other s/w like Bluetooth , Card Reader ,Empowering technology. VISTA will stop these Xp version s/w.
Please find here is one solution to those Problems.

http://support.acer-euro.com/drivers/notebook/as_9300.html

Thanks and Regards
Sitaram.PV
Singapore.
+65 81248727

DUAL BOOT OS with SOLARIS

Hi,

I installed SOLARIS recently in my Laptop.
SOLARIS is Free software from SUN

https://sdlc2d.sun.com/ECom/EComActionServlet/DownloadPage:~:com.sun.sunit.sdlc.content.DownloadPageInfo;jsessionid=388758B4FFA04045AA4E4F893EE54656;jsessionid=388758B4FFA04045AA4E4F893EE54656


Need to follow some rules to Install SOLARIS
Since VISTA knows NTFS but SOLARIS can understand ZFS file system.
Please folow below steps to install or go throug the below link


http://linux.wordpress.com/2007/02/17/vista-and-solaris-express-dual-boot/


  1. You need to have a GParted or QTParted LiveCD (System Rescue CD) handy. You also need to have a FAT-formatted USB Key (readable on Windows).
  2. Boot the QTParted/GParted cd and create a primary partition for Windows but do not format it.
  3. Now boot from the Solaris Express DVD and install Solaris in another primary partition
  4. Boot into Solaris Express and run: installgrub -m /boot/grub/staqe1 /boot/grub/stage2 /dev/rdsk/c[...]s0. You can get the value for […] by executing df -h and seeing the device name for mountpoint “/”. This puts GRUB stage1 into MBR instead of mboot. This allows Solaris to boot even if the Solaris Partition is not active.
  5. Now dump a copy of the MBR to a file: dd if=/dev/dsk/c[...]p0 of=/solmbr bs=512 count=1
  6. Plugin the USB Key and copy the file solmbr to your USB Key
  7. Insert the GParted CD and reboot into GParted.
  8. Remove the “Boot” or “Active” flag from the Solaris Partition
  9. Reboot and start Windows Vista installation
  10. Once Vista is ready copy the file solmbr from the USB Key to C:\
  11. Now you have to use bcdedit.exe. But before you can use that you need Administrator rights. So in start menu right-click on the Command Window entry and select “run as Administrator” option.
  12. Execute the following in the command window:
    bcdedit /create {ntldr} /d "Solaris Express"
    bcdedit /set {ntldr} device boot
    bcdedit /set {ntldr} path \solmbr
    bcdedit /displayorder {ntldr} /addlast

    This creates a new Legacy boot entry in the BCD.
  13. Now you have to reboot and if all is well you will be presented with 2 boot options by the Vista bootloader. The Solaris Express option will bring up the GRUB menu next from where you can boot Solaris.

You have a system already having Vista and wish to install Solaris

  1. You need to have one free Primary partition. You also need an OpenSolaris LiveCD like BeleniX.
  2. If you have at least 10GB free space on disk then skip to step #5
  3. You may have multiple Windows logical drives and reclaim space by deleting one. Skip to step #5
  4. You have one big Windows partition and need to resize it. So do the following:
    • You need the QTParted LiveCD (System Rescue CD).
    • Defragment your drive
    • Reboot and run chkdsk
    • Boot into the QTParted cd and you will get a partitioning GUI. You can resize the Windows partition here
    • After resizing, boot into windows again and run chkdsk
  5. Now take a backup of the MBR. Boot from BeleniX and execute: dd if=/dev/dsk/c[...]p0 of=mbrback bs=512 count=1 and copy the file to a USB Key.
  6. Now install Solaris Express.
  7. Boot into Solaris Express and run: installgrub -m /boot/grub/staqe1 /boot/grub/stage2 /dev/rdsk/c[...]s0. You can get the value for […] by executing df -h and seeing the device name for mountpoint “/”. This puts GRUB stage1 into MBR instead of mboot. This allows Solaris to boot even if the Solaris Partition is not active.
  8. Dump a copy of the MBR to a file: dd if=/dev/dsk/c[...]p0 of=/solmbr bs=512 count=1
  9. Plugin the USB Key and copy the file solmbr to your USB Key
  10. Boot into the GParted/QTParted CD and remove the boot/active flag from the Solaris Partition and enable the boot/active flag for the Windows Partition.
  11. Now you need to restore the MBR backup you had taken in step #5. Boot again into BeleniX, insert the USB Key having the mbrback file and execute the following: dd if=/path/to/mbrback of=/dev/dsk/c[...]p0 bs=446 count=1. Note the bs=446. You need to only restore the Vista bootloader. If you restore the entire MBR you will lose the partition info for the Solaris Partition!
  12. Reboot and this time it should boot directly into Windows Vista
  13. Copy the file solmbr from the USB Key to C:\
  14. Now you have to use bcdedit.exe. But before you can use that you need Administrator rights. So in start menu right-click on the Command Window entry and select “run as Administrator” option.
  15. Execute the following in the command window:
    bcdedit /enum all | find "{ntldr}"
    If this command returns: identifier {ntldr}, that means you already have a legacy boot loader in your system. Do the following:
    bcdedit /copy {ntldr} /d "Solaris Express"This should display a message similar to:
    The entry was successfully copied to {bcfa924e-07e0-11db-9d86-accf6fd346a1}

    You need to use the long GUID value from the above message in the following commands wherever {GUID} is mentioned:
    bcdedit /set {GUID} device boot
    bcdedit /set {GUID} path \solmbr
    bcdedit /displayorder {GUID} /addlast

    If the earlier find command did not return any entry, you need to do the following to create a new legacy bootloader:
    bcdedit /create {ntldr} /d "Solaris Express"
    bcdedit /set {ntldr} device boot
    bcdedit /set {ntldr} path \solmbr
    bcdedit /displayorder {ntldr} /addlast

  16. Finally reboot your system and if everything is hunky dory you will get multiple boot options from the Vista Bootloader
Please contact me if you need more info : srampv@gmail.com