java4practices

Create Initial-capital letter by using XSLT

2015-04-30T18:34:00.000+05:30

By using below template you can get initial capital letter for multiple word.

<xsl:call-template name="ginitcap">
<xsl:with-param name="text"> <xsl:value-of select="your value here"/> </xsl:with-param>
</xsl:call-template>


<xsl:template name="ginitcap">
<xsl:param name="text"/>
<xsl:choose>
<xsl:when test="contains($text,' ')">
<xsl:call-template name="ginitcapword">
<xsl:with-param name="text" select="substring-before($text,' ')"/>
</xsl:call-template>
<xsl:text> </xsl:text>
<xsl:call-template name="ginitcap">
<xsl:with-param name="text" select="substring-after($text,' ')"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:call-template name="ginitcapword">
<xsl:with-param name="text" select="$text"/>
</xsl:call-template>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="ginitcapword">
<xsl:param name="text"/>
<xsl:value-of select="translate(substring($text,1,1),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ')" /><xsl:value-of select="translate(substring($text,2,string-length($text)-1),'ABCDEFGHIJKLMNOPQRSTUVWXYZ','abcdefghijklmnopqrstuvwxyz')" />
</xsl:template>

Input : your value here

Output : Your Value Here

To use two version of jquery in single page

2013-06-03T15:07:00.000+05:30

Download js and css

Sample.jsp
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>jQuery.noConflict</title>

<%--This is for jquery Button--%>
<%--First jquery version Start--%>

<link rel="stylesheet" href="jquery.ui.all.css">
<script src="jquery-1.9.1.js"></script>
<script src="jquery.ui.core.js"></script>
<script src="jquery.ui.widget.js"></script>
<script src="jquery.ui.button.js"></script>
<link rel="stylesheet" href="demos.css">
<script>
$(function() {

$( "input[type=submit], a, button,input[type=Reset]")
.button()
});
</script>

<%--First jquery version End--%>

<%--This is for jquery Autocomplete--%>
<%--Second jquery version Start--%>

<script type="text/javascript" src="jquery-1.4.2.min.js"></script>
<script src="jquery.autocomplete.js"></script>
<link rel="stylesheet" type="text/css" href="style.css" />

<script language="javascript" type="text/javascript">
var jq = jQuery.noConflict (); // jq having the value of $.
// In your entire script use jq instead of $.
jq(document).ready(function(){
jq("#name").autocomplete("auto.jsp");
});
</script>

<%--By using this conflict you can use any number of jquery version in a single page
for example:you want to use version 1.10.1 then create another conflict
  var js = jQuery.noConflict (); // jq having the value of $.
// In your entire script use jq instead of $.
     js(document).ready(function(){
js("#name").autocomplete("auto.jsp");
--%>

<%--Second jquery version End--%>

</head>
<body>
<div>
<form name="sample" action="sample">
<table border="0" width="100%" >
<tr>
<td colspan="2">/*Second jquery version Start*/</td>
</tr>
<tr >
<td>Name</td>
<td><input id="name" type="text" name="name" size="20" ></td>
</tr>
<tr>
<td colspan="2"> /*Second jquery version End*/</td>
</tr>
<tr>
<td>Number</td>
<td><input id="no" type="text" name="no" size="20"></td>
  </tr>
<tr>
<td colspan="2"> /*First jquery version Start*/</td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="submit"></td>
</tr>
<tr>
<td colspan="2">/*First jquery version End*/</td>
</tr>
</table>
</form>
</div>
</body>
</html>

auto.jsp

<%@page import="java.sql.*"%>

<%@page import="java.util.ArrayList"%>

<%@page import="com.hrm.connection.Dbconnection" %>

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection c=DriverManager.getConnection("jdbc:mysql://localhost:3306/xxx","root","root");

Statement st1=c.createStatement();

ResultSet rs=st1.executeQuery("select * from name");

String product="";

ArrayList aa=new ArrayList();

while(rs.next())

{

aa.add(rs.getString("name"));

System.out.println(rs.getString("name"));

}

int cnt=1;

String query = (String)request.getParameter("q");

for(int i=0;i<aa.size();i++)

{

String temp=(String) aa.get(i);

if(temp.toUpperCase().startsWith(query.toUpperCase()))

{

out.print(temp+"\n");

if(cnt>=10)

break;

cnt++;

}

catch(Exception ex)

{

System.out.println("error"+ex);

}

MySQL Export to CSV

2013-03-20T12:12:00.001+05:30

Export data from MySQL into a CSV file,Its simple by using this query.

SELECT * INTO OUTFILE '/tmp/name.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM [tablename]

Listview with AlertBox in Android

2013-02-07T19:08:00.002+05:30

ListActivity.java

package com.android.first;

import java.util.Arrays;

import android.app.AlertDialog;

import android.app.ListActivity;

import android.os.Bundle;

import android.view.View;

import android.widget.AdapterView;

import android.widget.ArrayAdapter;

import android.widget.ListView;

import android.widget.TextView;

import android.widget.Toast;

import android.widget.AdapterView.OnItemClickListener;

public class ListActivity extends ListActivity {

String item[]={ "ganesh","murali","vijaya","rengarajan","karthi" };

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

Arrays.sort(item);

// no more this

// setContentView(R.layout.list_fruit);

setListAdapter(new ArrayAdapter<String>(this, R.layout.list_data,item));

ListView listView = getListView();

listView.setTextFilterEnabled(true);

final AlertDialog.Builder adb = new AlertDialog.Builder(this);

adb.setTitle("Content");

listView.setOnItemClickListener(new OnItemClickListener() {

public void onItemClick(AdapterView<?> parent, View view,

int position, long id) {

if("ganesh".equals(((TextView) view).getText()))

{

adb.setMessage(R.string.ganesh);

adb.setIcon(R.drawable.icon);

adb.show();

}

else if("murali".equals(((TextView) view).getText()))

{

adb.setMessage(R.string.murali);

adb.setIcon(R.drawable.icon);

adb.show();

}

else if("vijaya".equals(((TextView) view).getText()))

{

adb.setMessage(R.string.vijaya);

adb.setIcon(R.drawable.icon);

adb.show();

}

else if("rengarajan".equals(((TextView) view).getText()))

{

adb.setMessage(R.string.rengarajan);

adb.setIcon(R.drawable.icon);

adb.show();

}

else if("karthi".equals(((TextView) view).getText()))

{

adb.setMessage(R.string.karthi);

adb.setIcon(R.drawable.icon);

adb.show();

}

else

{

adb.setMessage(R.string.notfound);

adb.setIcon(R.drawable.icon);

adb.show();

}

});

}

List_data.xml

<?xml version="1.0" encoding="utf-8"?>

<TextView xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="fill_parent"

android:layout_height="fill_parent"

android:padding="10dp"

android:textSize="20sp" >

</TextView>

String.xml

<?xml version="1.0" encoding="utf-8"?>

<string name="hello">ganesh</string>

<string name="app_name">GaneshRengarajan</string>

<string name="ganesh">Author of Blog</string>

<string name="murali">1^st brother of ganesh<string>

<string name="vijaya">Mother of ganesh</string>

<string name="Rengarajan">Father of ganesh</string>

<string name="karthi">2^nd brother of ganesh </string>

<string name="notfound">Not Found</string>

</resources>

Snapshot

Android Terms

2013-02-07T17:58:00.001+05:30

.APK

Android application package file. Each Android application is compiled and packaged in a single file that includes all of the application’s code (.dex file), resources, assets, and manifest file. The application package file can have any name but must use the .apk extension. For example: myExampleAppname.apk. For convenience, an application package file is often referred to as an “.apk”.

.DEX

Dalvik Executable. Compiled Android application code file. Android programs are compiled into .dex files, which are in turn zipped into a single .apk file on the device. .dex files can be created by automatically translating compiled applications written in the Java programming language.

Action

An action is a description of something that an Intent sender wants done. An action is a string value assigned to an Intent. Action strings can be defined by Android or by a third-party developer. For example, android.intent.action.VIEW for a Web URL, or com.example.rumbler.SHAKE_PHONE for a custom application to vibrate the phone.

Activity

An activity is a single screen in an application, with supporting Java code, derived from the Activity class. Most commonly, an activity is visibly represented by a full screen window that can receive and handle UI events and perform complex tasks, because of the Window it uses to render its window. Though an Activity is typically full screen, it can also be floating or transparent.

adb

Android Debug Bridge, a command-line debugging application included with the SDK. It provides tools to browse the device, copy tools on the device, and forward ports for debugging. If you are developing in Eclipse using the ADT Plugin, adb is integrated into your development environment.

AndroidManifest.xml file

Every application must have an AndroidManifest.xml file (with precisely that name) in its root directory of the source tree. The manifest presents essential information about the application to the Android system, information the system must have before it can run any of the application’s code.

Application

From a component perspective, an Android application consists of one or more activities, services, listeners, and intent receivers. From a source file perspective, an Android application consists of code, resources, assets, and a single manifest. During compilation, these files are packaged in a single file called an application package file (.apk).

Boot

In contrast to other Linux-based operating systems, Android has a boot partition (containing the contents of a boot.img file), as opposed to a direct-booting system. This partition contains a read-only ‘ramdisk’, and a couple of other files. The ramdisk contains files critical to booting, such as init.rc and default.prop. This ‘partition’ actually sets up the directory structure of the device, having empty folders for /data, /dev, /proc, /sbin, /sys and /system.

Bootloader

The bootloader, is firmware on the phone which runs on every startup. Sometimes it may be desirable to change the version of the bootloader, or to load a different bootloader entirely to enable different features or a completely different OS. The current version of the bootloader can be viewed by entering bootloader mode, the process of which is different for each and every device or manufacturer.

Broadcast Receiver

An application class that listens for Intents that are broadcast, rather than being sent to a single target application/activity. The system delivers a broadcast Intent to all interested broadcast receivers, which handle the Intent sequentially.

Canvas

A drawing surface that handles compositing of the actual bits against a Bitmap or Surface object. It has methods for standard computer drawing of bitmaps, lines, circles, rectangles, text, and so on, and is bound to a Bitmap or Surface. Canvas is the simplest, easiest way to draw 2D objects on the screen. However, it does not support hardware acceleration, as OpenGL ES does. The base class is Canvas.

Content Provider

A data-abstraction layer that you can use to safely expose your application’s data to other applications. A content provider is built on the ContentProvider class, which handles content query strings of a specific format to return data in a specific format.

Dalvik

The Android platform’s virtual machine. The Dalvik VM is an interpreter-only virtual machine that executes files in the Dalvik Executable (.dex) format, a format that is optimized for efficient storage and memory-mappable execution. The virtual machine is register-based, and it can run classes compiled by a Java language compiler that have been transformed into its native format using the included “dx” tool. The VM runs on top of Posix-compliant operating systems, which it relies on for underlying functionality (such as threading and low level memory management). The Dalvik core class library is intended to provide a familiar development base for those used to programming with Java Standard Edition, but it is geared specifically to the needs of a small mobile device.

Data

The data partition on the device contains the user-related data, such as installed applications and settings for those apps, as well as your SQLite database containing Android settings and messages. Normally, the directory /data/app is off-limits through the ‘adb shell’ command, as well as other terminal applications that can run on the device, since this directory contains the apk files for apps. On a rooted phone, using the ‘su’ command will allow full access to this partition. This partition can be flashed using Fastboot or Nandroid.

DDMS

Dalvik Debug Monitor Service, a GUI debugging application included with the SDK. It provides screen capture, log dump, and process examination capabilities. If you are developing in Eclipse using the ADT Plugin, DDMS is integrated into your development environment.

Deodex

Deodex is the process of combining the already optimized application elements found in the .odex file and compressing them into the .apk file with the rest of the application. The main reason for doing this allows for application and ROM themers to edit the graphics and settings in the application, whereas they would be unable to in the .odex file. There is really no reason to deodex an application and/or ROM other than to allow theming or other modifications of an application which you do not have access to the sources of.

Dialog

A floating window that that acts as a lightweight form. A dialog can have button controls only and is intended to perform a simple action (such as button choice) and perhaps return a value. A dialog is not intended to persist in the history stack, contain complex layout, or perform complex actions. Android provides a default simple dialog for you with optional buttons, though you can define your own dialog layout. The base class for dialogs is Dialog.

Drawable

A compiled visual resource that can be used as a background, title, or other part of the screen. A drawable is typically loaded into another UI element, for example as a background image. A drawable is not able to receive events, but does assign various other properties such as “state” and scheduling, to enable subclasses such as animation objects or image libraries. Many drawable objects are loaded from drawable resource files — xml or bitmap files that describe the image. Drawable resources are compiled into subclasses of android.graphics.drawable.

Fastboot

Fastboot is a means which allows the user to execute or Flash an img file to their device. Some devices and/or bootloaders allow this access, while others do not. All Nexus branded devices allow such access when unlocked.

Flash

Flashing is the process of writing data to the internal memory on your phone. Normally, you would flash a ROM image to the phone, which would give you a different version of system software on your phone. Flashing can also refer to updating/writing to any of the other parts of the phone, such as the SPL, Radio etc.

Flash Memory

Flash memory, also known as NAND memory, is nonvolatile – keeping information even when the device is off. Flash memory in the device is equivalent to the hard drive in a computer. This is where the device’s operating system (sometimes called firmware) and applications are stored. Flash memory is slower than RAM, but is (almost always) faster than SD cards.

Logcat

While in adb (see ADB), type in “adb logcat > logcat.txt”. This will help you when resolving issues and bugs. There are also tools in the market you can use for this, one of which is called aLogcat. It can show different categories (severity of errors ect.) too, which is something adb logcat cannot do.

Market (also Play Store)

The market on Android is a place where you can purchase or download applications for your phone. When you download through the market, the installation process is transparent (as in you don’t have to deal with the APK files yourself), and there is the facility to rate apps and post comments which are visible to other users. Frequently, the developers of apps actually take onboard the feedback in the comments (mainly the smaller apps with slightly less feedback to sift through).

When an app is installed from the market, it is copied to ‘/data/app/apkname.apk’, as the act of ‘installing’. An app can store its data in the folder ‘/data/data/apkname’. It is possible to clear the data stored by an application by using the Manage Applications feature in Settings | Applications | Manage Applications.

Intent

A message object that you can use to launch or communicate with other applications/activities asynchronously. An Intent object is an instance of Intent. It includes several criteria fields that you can supply, to determine what application/activity receives the Intent and what the receiver does when handling the Intent. Available criteria include the desired action, a category, a data string, the MIME type of the data, a handling class, and others. An application sends an Intent to the Android system, rather than sending it directly to another application/activity. The application can send the Intent to a single target application or it can send it as a broadcast, which can in turn be handled by multiple applications sequentially. The Android system is responsible for resolving the best-available receiver for each Intent, based on the criteria supplied in the Intent and the Intent Filters defined by other applications.

Intent Filter

A filter object that an application declares in its manifest file, to tell the system what types of Intents each of its components is willing to accept and with what criteria. Through an intent filter, an application can express interest in specific data types, Intent actions, URI formats, and so on. When resolving an Intent, the system evaluates all of the available intent filters in all applications and passes the Intent to the application/activity that best matches the Intent and criteria.

Layout Resource

An XML file that describes the layout of an Activity screen.

Manifest File

An XML file that each application must define, to describe the application’s package name, version, components (activities, intent filters, services), imported libraries, and describes the various activities, and so on.

Nandroid

Nandroid is used to backup or restore backups from Recovery. You can chose to either do a regular backup (Phone only) or a backup + sd-ext (Phone + Apps2sd ext.)Both will backup your whole system, the second will include apps saved on your sdcard’s sd-ext.

Nine-patch / 9-patch / Ninepatch image

A resizeable bitmap resource that can be used for backgrounds or other images on the device.

Odex

Odex stands for “Optimized Dalvik Executable” file. The Android system, as identified above, utilizes compressed data stored in the .apk file at runtime. To speed up this process, the most critical elements of application will be placed uncompressed in an .odex file, thus enabling the Android OS to quickly interpret that important information before it continues to parse the rest of the application. Stock ROMs will come from the manufacturer as “odexed”, meaning that the application(s) will have a .apk file and an .odex file, i.e. Calendar.apk and Calendar.odex.

OpenGL ES

Android provides OpenGL ES libraries that you can use for fast, complex 3D images. It is harder to use than a Canvas object, but better for 3D objects. The android.opengl and javax.microedition.khronos.opengles packages expose OpenGL ES functionality.

Radio

The Radio on a mobile phone is the part of the phone that deals with mobile connections. It handles talking to the CDMA/GSM/LTE/3G/4G network, Bluetooth, WiFi and GPS. The radio contains software that controls how it operates, and newer versions of radio firmware are made available from time to time via system updates. These updates are transparent to the user, although users who elect to install custom software can update their radio using an update.zip file made available by members of the modding community.

Flashing the radio is potentially risky, and you should NEVER pull the battery out of a phone that is flashing the radio. If you do so, it is possible your phone will be bricked. Nevertheless, it can give improved battery life, signal strength and data performance, so is often done by users moving to later versions of ROMs. Care should be taken to only flash the correct type of radio to a phone. NEVER attempt to flash a CDMA phone with a GSM radio or vice-versa. It is likely you will brick the phone if you attempt to do so.

Recovery

The recovery partition is a boot-mode for your phone that allows you to wipe your settings from the Data partition of the phone (a hard wipe), or perform an update using an update.zip file on the root of the microSD card. It is common (although not necessary) to flash a patched Recovery image, such as TWRP or ClockworkMod Recovery. This allows you to run Nandroid backup from the device, and flash modifications, such as files to the device, essentially becoming a means to install software to the device. Recovery mode is separate from ‘normal’ mode, and can be entered by holding down home whilst turning the phone on.

Resources

Nonprogrammatic application components that are external to the compiled application code, but which can be loaded from application code using a well-known reference format. Android supports a variety of resource types, but a typical application’s resources would consist of UI strings, UI layout components, graphics or other media files, and so on. An application uses resources to efficiently support localization and varied device profiles and states. For example, an application would include a separate set of resources for each supported local or device type, and it could include layout resources that are specific to the current screen orientation (landscape or portrait). The resources of an application are always stored in the res/* subfolders of the project.

ROM

ROM is literally “read-only memory” but its usage has changed over time. Today ROM can refer to the non-volatile area of a device’s flash memory on which read-only data resides or the packed image to be written to that flash area.

Root

Root is the name of the highest level superuser (su) on Unix-like systems such as Android. The root user, and applications run by the root user, have administrative access to protected files and services which makes it dangerous for normal daily use.

A ‘rooted’ device is one which has been hacked to provide privilege escalation from a standard user to superuser. Rooting a device is usually the first step in installing cooked ROMs.

S-OFF/S-ON

This refers to an unlocked/locked NAND drive. HTC locks the NAND on their phones to prevent writing to the system partition. S-OFF can generally be obtained by an exploit, by flashing an engineering SPL, or by using a process put in place by HTC.

Service

An object of class Service that runs in the background (without any UI presence) to perform various persistent actions, such as playing music or monitoring network activity.

SPL

The Secondary Program Loader is a piece of bootcode that initiates the startup of the phone, displaying the initial splash screen for the device, and loading the initial files from ROM.

It checks to see if a button combination is pressed on bootup (such as that to enter Recovery Mode or the bootloader), and loads the relevant system software. If no special instruction is given by holding keys, the bootloader loads the normal system software by initializing the boot process from the boot partition.

Flashing your SPL is risky, as the process failing will probably result in a broken, or bricked phone, since the SPL is executed very early on in the boot process, and any error here will prevent access to the recovery or bootloader features.

If you do flash the SPL though, it unlocks the Carrier-ID CID from the device, essentially allowing any RUU to be installed to the device, and allows flashing alternative or custom bootscreens.

Stock

The term stock is often used to refer to a file or part of the software which is unmodified or untouched by developers. For example, a stock ROM would be one which was produced by HTC or Samsung and which has not been modified or rooted by someone. The term is often used when comparing performance of different ROMs, as a way to refer to the phone as it came out the box.

su (substitute user) is a Linux command which, when run without a username parameter, gives the user full ‘root’ permissions. By default, this command binary (ie. Linux equivalent of an executable file) is not included on Android systems, but the process of “rooting” a phone copies this file to the ‘/system/bin/’ directory thereby enabling the command. Since root privileges can be abused by malicious applications it’s highly recommended to install an app to grant and manage access to su, similar to UAC on Windows. Many ROMs include the app called “SuperSU” for this.

Surface

An object of type Surface representing a block of memory that gets composited to the screen. A Surface holds a Canvas object for drawing, and provides various helper methods to draw layers and resize the surface. You should not use this class directly; use SurfaceView instead.

SurfaceView

A View object that wraps a Surface for drawing, and exposes methods to specify its size and format dynamically. A SurfaceView provides a way to draw independently of the UI thread for resource-intensive operations (such as games or camera previews), but it uses extra memory as a result. SurfaceView supports both Canvas and OpenGL ES graphics. The base class is SurfaceView.

System

The /system directory on your device is where the main operational software for the Android OS is stored. It has a number of sub-directories of which /system/apps (where application apk’s are stored) is probably the only one users would have need to access. The /system folder is read-only by default and needs remounted via ‘adb’ to allow write access.

Theme

A set of properties (text size, background color, and so on) bundled together to define various default display settings. Android provides a few standard themes, listed in R.style (starting with “Theme_”).

Update.zip

An update.zip (does not have to actually be called update.zip if you have a patched Recovery image) is a file containing some files which will be copied to the phone’s internal memory. Normally, a new system update or ROM is stored in the file, but update.zip files are commonly used to install modifications such as themes or applications that are installed on the System partition to prevent uninstallation.

To flash one of these files, which commonly would contain a custom ROM for your phone, you would boot your phone to a patched recovery image (whether using Fastboot, or the home+power method if you have a patched Recovery image flashed on your phone)

Update.zip files are cryptographically signed, and more information on how to sign your own files can be found online.

URIs in Android

Android uses URI strings as the basis for requesting data in a content provider (such as to retrieve a list of contacts) and for requesting actions in an Intent (such as opening a Web page in a browser). The URI scheme and format is specialized according to the type of use, and an application can handle specific URI schemes and strings in any way it wants. Some URI schemes are reserved by system components. For example, requests for data from a content provider must use the content://. In an Intent, a URI using an http:// scheme will be handled by the browser.

View

An object that draws to a rectangular area on the screen and handles click, keystroke, and other interaction events. A View is a base class for most layout components of an Activity or Dialog screen (text boxes, windows, and so on). It receives calls from its parent object (see viewgroup, below)to draw itself, and informs its parent object about where and how big it would like to be (which may or may not be respected by the parent).

Viewgroup

A container object that groups a set of child Views. The viewgroup is responsible for deciding where child views are positioned and how large they can be, as well as for calling each to draw itself when appropriate. Some viewgroups are invisible and are for layout only, while others have an intrinsic UI (for instance, a scrolling list box). Viewgroups are all in the widget package, but extend ViewGroup.

Widget

One of a set of fully implemented View subclasses that render form elements and other UI components, such as a text box or popup menu. Because a widget is fully implemented, it handles measuring and drawing itself and responding to screen events. Widgets are all in the android.widget package.

Window

In an Android application, an object derived from the abstract class Window that specifies the elements of a generic window, such as the look and feel (title bar text, location and content of menus, and so on). Dialog and Activity use an implementation of this class to render a window. You do not need to implement this class or use windows in your application.

Zipalign

zipalign is an archive alignment tool that provides important optimization to Android application (.apk) files. The purpose is to ensure that all uncompressed data starts with a particular alignment relative to the start of the file. Specifically, it causes all uncompressed data within the .apk, such as images or raw files, to be aligned on 4-byte boundaries. The benefit is a reduction in the amount of RAM consumed when running the application.

Create and View the Database Table in Java Swing

2012-12-11T17:25:00.001+05:30

Download the database and jar file here download

1.Create Java Project in Netbeans

2.Create JFrame form

3.Drag & Drop JTable

4.Delete the predefined columns

5.Then the jtable look like this

6.Insert this getTable() method in your class

public JTable getTable(int value)throws Exception{
String query=null;
query="select * from jsample where id='"+value+"'";
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/path","root","root");
Statement s1=con.createStatement();
DefaultTableModel dm=new DefaultTableModel();
ResultSet rs=s1.executeQuery(query );
ResultSetMetaData rsmd=rs.getMetaData();
//Coding to get columns-
int cols=rsmd.getColumnCount();
String c[]=new String[cols];
for(int i=0;i<cols;i++){
c[i]=rsmd.getColumnName(i+1);
dm.addColumn(c[i]);
}
//get data from rows
Object row[]=new Object[cols];
while(rs.next()){
for(int i=0;i<cols;i++){
row[i]=rs.getString(i+1);
}
dm.addRow(row);
}
jTable1.setModel(dm); //change your table name here
con.close();
return jTable1; //change your table name here
}

7.Call your method from your Action

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
getTable(1);
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}

8.Output

Autocomplete using jquery and Mysql Database

2012-12-05T13:39:00.000+05:30

Requirement:

Required javascript and css file Download Here

Required jsp files see below code

update.jsp

<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="jquery-1.4.2.min.js"></script>
<script src="jquery.autocomplete.js"></script>
<script language="javascript" type="text/javascript">

jQuery(function(){
$("#country").autocomplete("reg_update.jsp");
});
</script>
<title>Ganesh Rengarajan</title>
</head>
<body onLoad="show_clock()">
<table align="center" border="0" width=" 60%" cellspacing="6">
<tr>
<td >Select Name</td>
<td><input name="appno" id="country" name="country" size="20" ></td>
</tr>
</table>
</body>
</html>

reg_update.jsp

<%@page import="java.sql.*"%>
<%@page import="java.util.List"%>
<%@page import="java.util.ArrayList"%>
<%

try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/path","root","root");
Statement s1=con.createStatement();
Statement st1=con.createStatement();
ResultSet rs=st1.executeQuery("select * from jsample");
String product="";
ArrayList aa=new ArrayList();
while(rs.next())
{
aa.add(rs.getString("name"));
}
int cnt=1;
String query = (String)request.getParameter("q");

for(int i=0;i<aa.size();i++)
{
String temp=(String) aa.get(i);

if(temp.toUpperCase().startsWith(query.toUpperCase()))
{
out.print(temp+"\n");
if(cnt>=10)
break;
cnt++;
}
}

}
catch(Exception ex)
{
System.out.println("error"+ex);
}

%>

how to create struts in netbeans

2012-11-09T14:19:00.001+05:30

Sample table creation in PDF using Servlet

2012-11-01T17:58:00.001+05:30

Required Jar:

Download Itext 1.3 jar

Servlet Code:

import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.io.ByteArrayOutputStream;
import java.io.PrintWriter;
import com.lowagie.text.*;
import com.lowagie.text.pdf.*;

public class PDFServlet extends HttpServlet
{

public PDFServlet()
{
super();
}

public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws javax.servlet.ServletException, java.io.IOException
{
DocumentException ex = null;

ByteArrayOutputStream baosPDF = null;

try
{
baosPDF = generatePDFDocumentBytes(req, this.getServletContext());

StringBuffer sbFilename = new StringBuffer();
sbFilename.append("filename_");
sbFilename.append(System.currentTimeMillis());
sbFilename.append(".pdf");

resp.setHeader("Cache-Control", "max-age=30");

resp.setContentType("application/pdf");

StringBuffer sbContentDispValue = new StringBuffer();
sbContentDispValue.append("inline");
sbContentDispValue.append("; filename=");
sbContentDispValue.append(sbFilename);

resp.setHeader(
"Content-disposition",
sbContentDispValue.toString());

resp.setContentLength(baosPDF.size());

ServletOutputStream sos;

sos = resp.getOutputStream();

baosPDF.writeTo(sos);

sos.flush();
}
catch (DocumentException dex)
{
resp.setContentType("text/html");
PrintWriter writer = resp.getWriter();
writer.println(
this.getClass().getName()
+ " caught an exception: "
+ dex.getClass().getName()
+ "<br>");
writer.println("<pre>");
dex.printStackTrace(writer);
writer.println("</pre>");
}
finally
{
if (baosPDF != null)
{
baosPDF.reset();
}
}

}
protected ByteArrayOutputStream generatePDFDocumentBytes(
final HttpServletRequest req,
final ServletContext ctx)
throws DocumentException

{
Document doc = new Document();

ByteArrayOutputStream baosPDF = new ByteArrayOutputStream();
PdfWriter docWriter = null;

try
{
docWriter = PdfWriter.getInstance(doc, baosPDF);

doc.addAuthor(this.getClass().getName());
doc.addCreationDate();
doc.addProducer();
doc.addCreator(this.getClass().getName());
doc.addTitle("This is a title.");
doc.addKeywords("pdf, itext, Java, open source, http");
doc.setPageSize(PageSize.LETTER);

HeaderFooter footer = new HeaderFooter(
new Phrase("Created by Ganesh Rengarajan."),
false);

doc.setFooter(footer);
doc.open();
doc.add(new Paragraph(
"Sample table in PDF using Web Application(Servlet)"));
doc.add( makeGeneralRequestDetailsElement(req) );
}
catch (DocumentException dex)
{
baosPDF.reset();
throw dex;
}
finally
{
if (doc != null)
{
doc.close();
}
if (docWriter != null)
{
docWriter.close();
}
}

if (baosPDF.size() < 1)
{
throw new DocumentException(
"document has "
+ baosPDF.size()
+ " bytes");
}
return baosPDF;
}

protected Element makeGeneralRequestDetailsElement(
final HttpServletRequest req)

{

ArrayList l=new ArrayList();
l.add("Name");
l.add("ganesh");
l.add("Age");
l.add("23");
l.add("Gender");
l.add("Male");
l.add("Date");
l.add("23/02/12");
l.add("Seat No");
l.add("07");
l.add("From");
l.add("Mayiladuthurai");
l.add("To");
l.add("Chennai");
l.add("Ticket Fare");
l.add("240");

Table tab = null;

tab = makeTableFromMap(l);

return (Element) tab;
}

private static Table makeTableFromMap(

final java.util.ArrayList m)
{
Table tab = null;

try
{
tab = new Table(2 /* columns */);
}
catch (BadElementException ex)
{
throw new RuntimeException(ex);
}

tab.setBorderWidth(1.0f);
tab.setPadding(5);
tab.setSpacing(5);
tab.endHeaders();

if (m.size() == 0)
{
Cell c = new Cell("none");
c.setColspan(tab.columns());
tab.addCell(c);
}
else
{

Iterator i = m.iterator();
String strName=null;
while (i.hasNext())
{
strName=i.next().toString();
tab.addCell(new Cell(strName));
}

}

return tab;
}

}

Oracle Database Connection for Java

2012-10-05T13:33:00.000+05:30

PART 1

Oracle Download

Install Oracle database and do steps below in image

After select Go To Database Home Page a login page appear and then enter your username(what u give at installation time) and password (what u give at installation time) following page appear

After select sql command following page appear

Enter and Run your query here .

Table is created .

PART 2

In windows xp Start --> Control Panel --> Performance and Maintanenace --> Administratvie Tool --> Data Source(odbc)

ODBC Data Source Administrator dialog box appear
click Add Button
Create New Data Source dialog box appear

select Oracle in XE and Click Finish Button following dialog box appear

Fill information like above image and select ok button.After that your connectOracle created.

PART 3

Create Project and import ODBC jar into library from your installation path

C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar

Java Coding

INSERT CODING:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class InsertRecord {

public static void main(String[] args) {

String driver="sun.jdbc.odbc.JdbcOdbcDriver";

String cs="jdbc:odbc:connectoracle";

String user = "system";

String pwd = "admin";

String sqlstmt="INSERT INTO GANESH2 VALUES(7,'ambross')";

//String sqlstmt1="create table login(ID Number NOT NULL ,Name Varchar2(50),Password Varchar2(50),CONSTRAINT login_PK PRIMARY KEY (ID) ENABLE);";

Connection con = null;

Statement st = null;

try

{

Class.forName(driver);

}

catch(Exception e)

{

System.out.println(e);

}

System.out.println("Driver loaded");

try

{

con=DriverManager.getConnection(cs,user,pwd);

System.out.println("Connected to the Oracle Database");

st = con.createStatement();//creates a Statement object for sending SQL statements to the database.

//st.executeQuery(sqlstmt);

int updatecount=st.executeUpdate(sqlstmt);//return either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing

//System.out.println(updatecount+" row inserted");

}

catch(Exception e)

{

System.out.println(e);

}

try

{

st.close();

con.close();

}

catch(Exception e)

{

System.out.println(e);

}

}//main()

}//class()

VIEW CODING:

import java.sql.*;

public class oracle {

public static void main(String[] args) {

String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //

String cs="jdbc:odbc:connectOracle"; //connectOracle is the data source name

String user = "system"; //username of oracle database

String pwd = "admin"; //password of oracle database

Connection con = null; //connection variable assigned to null

try

{

Class.forName(driver);// for loading the jdbc driver

}

catch(Exception e)

{

System.out.println(e);

}

System.out.println("JDBC Driver loaded");

try

{

con=DriverManager.getConnection(cs,user,pwd);// for establishing connection with database

Statement s=con.createStatement();

ResultSet r=s.executeQuery("select * from ganesh2");

while(r.next())

{

System.out.println("ID:"+r.getInt("id")+" Password:"+r.getString("name"));

}

catch(Exception e)

{

System.out.println(e);

}

System.out.println("Connected to the Oracle Database");

try

{

con.close();

}

catch(Exception e)

{

System.out.println(e);

}

}//end of main()

}//end of class()

Java Swing Look and Feel

2012-10-04T19:47:00.002+05:30

Download Link for Look and Feel Jar:
Download

Double Click and open nimrodlf-1.2.jar and...

Save NimRODThemeFile in your project source folder and set like below in your main class

UIManager.setLookAndFeel("com.nilo.plaf.nimrod.NimRODLookAndFeel");

Add nimrodlf-1.2.jar in your project library folder.

Simple WebApplication Using Spring

2012-10-03T12:40:00.000+05:30

In Netbeans Go File --> New Project

select java webapplication like show below:

Click Next--->click Next-->and select framework in framework window like show below:

Click -->Next

Now its ready for coding part....

Create java class bean.java

--------------------------------------Coding Start-------------------------------------

public class bean {
public void myexample()
{
System.out.println("Hello my spring by ganesh");
}
}

--------------------------------------Coding End-------------------------------------

Create Main class main.java

--------------------------------------Coding Start-------------------------------------

public class main {
public static void main(String[] args) {
XmlBeanFactory xml=new XmlBeanFactory(new ClassPathResource("myxml.xml"));
bean b=(bean)xml.getBean("mybean");
b.myexample();
}

}

--------------------------------------Coding End-------------------------------------

Create Spring xml Configuration file myxml.xml like show below:

myxml.xml

--------------------------------------Coding Start-------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
">
<bean id="mybean" class="bean"/>
</beans>

--------------------------------------Coding End-------------------------------------

Run your main class

Ouput :

Hello my spring by ganesh.

MYSQL QUERY

2012-09-17T19:28:00.000+05:30

DML

SELECT - extracts data from a database

UPDATE - updates data in a database

DELETE - deletes data from a database

INSERT INTO - inserts new data into a database

DDL

CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - creates a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

CREATE INDEX - creates an index (search key)

DROP INDEX - deletes an index

SQL Commands:

Select:

· SELECT * FROM tablename;

DISTINCT

Some of the columns may contain duplicate values. This is not a problem; however, sometimes you will want to list only the different (distinct) values in a table.

· SELECT DISTINCT column_name(s) FROM table_name

WHERE

The WHERE clause is used to filter records.

· SELECT column_name(s) FROM table_name WHERE column_name operator value

AND & OR Operator:

The AND operator displays a record if both the first condition and the second condition are true.

The OR operator displays a record if either the first condition or the second condition is true.

· SELECT * FROM Persons WHERE FirstName='Tove' AND LastName='Svendson'

· SELECT * FROM Persons WHERE FirstName='Tove' OR FirstName='Ola'

· SELECT * FROM Persons WHERE LastName='Svendson' AND (FirstName='Tove' OR FirstName='Ola')

ORDER BY

The ORDER BY keyword is used to sort the result-set.

The ORDER BY keyword sorts the records in ascending order by default.

If you want to sort the records in a descending order, you can use the DESC keyword.

· SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC

· SELECT * FROM Persons ORDER BY LastName

· SELECT * FROM Persons ORDER BY LastName DESC

INSERT

The INSERT INTO statement is used to insert new records in a table.

· INSERT INTO table_name VALUES (value1, value2, value3,...)

· INSERT INTO Persons VALUES (4,'Nilsen', 'Johan', 'Bakken 2', 'Stavanger')

Insert Data Only in Specified Columns

· INSERT INTO Persons (P_Id, LastName, FirstName) VALUES (5, 'Tjessem', 'Jakob')

UPDATE

The UPDATE statement is used to update records in a table.

· UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value

DELETE

The DELETE statement is used to delete records in a table.

· DELETE FROM table_name WHERE some_column=some_value

Delete All Rows

· DELETE FROM table_name

TOP

The TOP clause is used to specify the number of records to return.

The TOP clause can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

· SELECT TOP number|percent column_name(s) FROM table_name

· SELECT column_name(s) FROM table_name LIMIT number

· SELECT * FROM Persons LIMIT 5

We want to select only the two first records in the table

· SELECT TOP 2 * FROM Persons

We want to select only 50% of the records in the table

· SELECT TOP 50 PERCENT * FROM Persons

LIKE (wildcard)

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

· SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern

We want to select the persons living in a city that starts with "s" from the table

· SELECT * FROM Persons WHERE City LIKE 's%'

We want to select the persons living in a city that ends with an "s" from the table

· SELECT * FROM Persons WHERE City LIKE '%s'

We want to select the persons living in a city that contains the pattern "tav" from the table

· SELECT * FROM Persons WHERE City LIKE '%tav%'

It is also possible to select the persons living in a city that does NOT contain the pattern "tav" from the table, by using the NOT keyword.

· SELECT * FROM Persons WHERE City NOT LIKE '%tav%'

We want to select the persons with a first name that starts with any character, followed by "la" from the table.

· SELECT * FROM Persons WHERE FirstName LIKE '_la'

We want to select the persons with a last name that starts with "S", followed by any character, followed by "end", followed by any character, followed by "on" from the "Persons" table.

· SELECT * FROM Persons WHERE LastName LIKE 'S_end_on'

We want to select the persons with a last name that starts with "b" or "s" or "p" from the table.

· SELECT * FROM Persons WHERE LastName LIKE '[bsp]%'

We want to select the persons with a last name that do not start with "b" or "s" or "p" from the table.

· SELECT * FROM Persons WHERE LastName LIKE '[!bsp]%'

The IN operator allows you to specify multiple values in a WHERE clause.

· SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...)

We want to select the persons with a last name equal to "Hansen" or "Pettersen" from the table

· SELECT * FROM Persons WHERE LastName IN ('Hansen','Pettersen')

BETWEEN

The BETWEEN operator is used in a WHERE clause to select a range of data between two values.

· SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2

Alias

You can give a table or a column another name by using an alias. This can be a good thing to do if you have very long or complex table names or column names.

An alias name could be anything, but usually it is short.

· SELECT column_name(s) FROM table_name AS alias_name

· SELECT column_name AS alias_name FROM table_name

· SELECT po.OrderID, p.LastName, p.FirstName FROM Persons AS p, Product_Orders AS po WHERE p.LastName='Hansen' AND p.FirstName='Ola'

· SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName FROM Persons, Product_Orders WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola'

JOIN

SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.

Tables in a database are often related to each other with keys.

A primary key is a column (or a combination of columns) with a unique value for each row. Each primary key value must be unique within the table. The purpose is to bind data together, across tables, without repeating all of the data in every table.

· JOIN: Return rows when there is at least one match in both tables

· LEFT JOIN: Return all rows from the left table, even if there are no matches in the right table

· RIGHT JOIN: Return all rows from the right table, even if there are no matches in the left table

· FULL JOIN: Return rows when there is a match in one of the tables

INNER JOIN

The INNER JOIN keyword return rows when there is at least one match in both tables.

· SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name

· SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons INNER JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName

LEFT JOIN

The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).

· SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2 ON table_name1.column_name=table_name2.column_name

· SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons LEFT JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName

RIGHT JOIN

The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

· SELECT column_name(s) FROM table_name1 RIGHT JOIN table_name2 ON table_name1.column_name=table_name2.column_name

· SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons RIGHT JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName

FULL JOIN

The FULL JOIN keyword return rows when there is a match in one of the tables.

· SELECT column_name(s) FROM table_name1 FULL JOIN table_name2 ON table_name1.column_name=table_name2.column_name

· SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons FULL JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName

UNION

The UNION operator is used to combine the result-set of two or more SELECT statements.

Notice that each SELECT statement within the UNION must have the same number of columns. The columns must also have similar data types. Also, the columns in each SELECT statement must be in the same order.

· SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2

· SELECT column_name(s) FROM table_name1 UNION ALL SELECT column_name(s) FROM table_name2

The UNION operator selects only distinct values by default. To allow duplicate values, use UNION ALL.

· SELECT E_Name FROM Employees_Norway UNION SELECT E_Name FROM Employees_USA

· SELECT E_Name FROM Employees_Norway UNION ALL SELECT E_Name FROM Employees_USA

SELECT INTO

The SELECT INTO statement selects data from one table and inserts it into a different table.

The SELECT INTO statement is most often used to create backup copies of tables.

· SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename

· SELECT column_name(s) INTO new_table_name [IN externaldatabase] FROM old_tablename

· SELECT * INTO Persons_Backup FROM Persons

· SELECT * INTO Persons_Backup IN 'Backup.mdb' FROM Persons

· SELECT LastName,FirstName INTO Persons_Backup FROM Persons

· SELECT LastName,Firstname INTO Persons_Backup FROM Persons WHERE City='Sandnes'

· SELECT Persons.LastName,Orders.OrderNo INTO Persons_Order_Backup FROM Persons INNER JOIN Orders ON Persons.P_Id=Orders.P_Id

CREATE DATABASE

The CREATE DATABASE statement is used to create a database.

· CREATE DATABASE database_name

CREATE TABLE

The CREATE TABLE statement is used to create a table in a database.

· CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... )

Constraints

Constraints are used to limit the type of data that can go into a table.

Constraints can be specified when a table is created (with the CREATE TABLE statement) or after the table is created (with the ALTER TABLE statement).

We will focus on the following constraints:

· NOT NULL

· UNIQUE

· PRIMARY KEY

· FOREIGN KEY

· CHECK

· DEFAULT

NOT NULL

The NOT NULL constraint enforces a column to NOT accept NULL values.

The NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new record, or update a record without adding a value to this field.

· CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName archar(255), Address varchar(255), City varchar(255) )

UNIQUE

The UNIQUE constraint uniquely identifies each record in a database table.

The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns.

A PRIMARY KEY constraint automatically has a UNIQUE constraint defined on it.

Note that you can have many UNIQUE constraints per table, but only one PRIMARY KEY constraint per table.

· CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName archar(255), Address varchar(255), City varchar(255), UNIQUE (P_Id) )

UNIQUE Constraint on ALTER TABLE

· ALTER TABLE Persons ADD UNIQUE (P_Id)

· ALTER TABLE Persons ADD CONSTRAINT uc_PersonID UNIQUE (P_Id,LastName)

DROP a UNIQUE

· ALTER TABLE Persons DROP INDEX uc_PersonID

PRIMARY KEY

The PRIMARY KEY constraint uniquely identifies each record in a database table.

Primary keys must contain unique values.

A primary key column cannot contain NULL values.

Each table should have a primary key, and each table can have only ONE primary key.

· CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (P_Id) )

PRIMARY KEY Constraint on ALTER TABLE

· ALTER TABLE Persons ADD PRIMARY KEY (P_Id)

DROP a PRIMARY KEY

· ALTER TABLE Persons DROP PRIMARY KEY

FOREIGN KEY

A FOREIGN KEY in one table points to a PRIMARY KEY in another table.

· CREATE TABLE Orders ( O_Id int NOT NULL, OrderNo int NOT NULL, P_Id int, PRIMARY KEY (O_Id), FOREIGN KEY (P_Id) REFERENCES Persons(P_Id) )

FOREIGN KEY Constraint on ALTER TABLE

· ALTER TABLE Orders ADD FOREIGN KEY (P_Id) REFERENCES Persons(P_Id)

DROP a FOREIGN KEY

· ALTER TABLE Orders DROP FOREIGN KEY fk_PerOrders

CHECK

The CHECK constraint is used to limit the value range that can be placed in a column.

If you define a CHECK constraint on a single column it allows only certain values for this column.

If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.

· CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), CHECK (P_Id>0) )

CHECK Constraint on ALTER TABLE

· ALTER TABLE Persons ADD CHECK (P_Id>0)

DROP a CHECK

· ALTER TABLE Persons DROP CHECK chk_Person

DEFAULT

The DEFAULT constraint is used to insert a default value into a column.

The default value will be added to all new records, if no other value is specified.

· CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) DEFAULT 'Sandnes' )

DEFAULT Constraint on ALTER TABLE

· ALTER TABLE Persons ALTER City SET DEFAULT 'SANDNES'

DROP a DEFAULT

· ALTER TABLE Persons ALTER City DROP DEFAULT

CREATE INDEX

The CREATE INDEX statement is used to create indexes in tables.

Indexes allow the database application to find data fast; without reading the whole table.

· CREATE INDEX index_name ON table_name (column_name)

· CREATE UNIQUE INDEX index_name ON table_name (column_name)

In second command duplicate not allowed.

· CREATE INDEX PIndex ON Persons (LastName)

· CREATE INDEX PIndex ON Persons (LastName, FirstName)

DROP

Indexes, tables, and databases can easily be deleted/removed with the DROP statement.

DROP INDEX

· ALTER TABLE table_name DROP INDEX index_name

DROP TABLE

· DROP TABLE table_name

DROP DATABASE

· DROP DATABASE database_name

TRUNCATE

What if we only want to delete the data inside the table, and not the table itself?

· TRUNCATE TABLE table_name

ALTER

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

· ALTER TABLE table_name ADD column_name datatype

· ALTER TABLE table_name DROP COLUMN column_name

AUTO INCREMENT

Auto-increment allows a unique number to be generated when a new record is inserted into a table.

è CREATE TABLE Persons ( P_Id int NOT NULL AUTO_INCREMENT, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (P_Id) )

è ALTER TABLE Persons AUTO_INCREMENT=100

VIEW

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

· CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition

· CREATE VIEW [Current Product List] AS SELECT ProductID,ProductName FROM Products WHERE Discontinued=No

· SELECT * FROM [Current Product List]

· CREATE VIEW [Products Above Average Price] AS SELECT ProductName,UnitPrice FROM Products WHERE UnitPrice>(SELECT AVG(UnitPrice) FROM Products)

· SELECT * FROM [Products Above Average Price]

· CREATE VIEW [Category Sales For 1997] AS SELECT DISTINCT CategoryName,Sum(ProductSales) AS CategorySales FROM [Product Sales for 1997] GROUP BY CategoryName

· SELECT * FROM [Category Sales For 1997]

· SELECT * FROM [Category Sales For 1997] WHERE CategoryName='Beverages'

· CREATE OR REPLACE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition

· CREATE VIEW [Current Product List] AS SELECT ProductID,ProductName,Category FROM Products WHERE Discontinued=No

· DROP VIEW view_name

Dates

The most difficult part when working with dates is to be sure that the format of the date you are trying to insert, matches the format of the date column in the database.

As long as your data contains only the date portion, your queries will work as expected. However, if a time portion is involved, it gets complicated.

NOW() Returns the current date and time

CURDATE() Returns the current date

CURTIME() Returns the current time

DATE() Extracts the date part of a date or date/time expression

EXTRACT() Returns a single part of a date/time

DATE_ADD() Adds a specified time interval to a date

DATE_SUB() Subtracts a specified time interval from a date

DATEDIFF() Returns the number of days between two dates

DATE_FORMAT() Displays date/time data in different formats

Date Data Types

DATE - format YYYY-MM-DD

DATETIME - format: YYYY-MM-DD HH:MM:SS

TIMESTAMP - format: YYYY-MM-DD HH:MM:SS

YEAR - format YYYY or YY

· SELECT * FROM Orders WHERE OrderDate='2008-11-11'

NULL Values

NULL values represent missing unknown data.

By default, a table column can hold NULL values.

SELECT LastName,FirstName,Address FROM Persons WHERE Address IS NULL
SELECT LastName,FirstName,Address FROM Persons WHERE Address IS NOT NULL
SELECT ProductName,UnitPrice*(UnitsInStock+IFNULL(UnitsOnOrder,0)) FROM Products

MySQL Data Types

CHAR(size) Holds a fixed length string (can contain letters, numbers, and special characters). The fixed size is specified in parenthesis. Can store up to 255 characters

VARCHAR(size) Holds a variable length string (can contain letters, numbers, and special characters). The maximum size is specified in parenthesis. Can store up to 255 characters. Note: If you put a greater value than 255 it will be converted to a TEXT type

TINYTEXT Holds a string with a maximum length of 255 characters

TEXT Holds a string with a maximum length of 65,535 characters

BLOB For BLOBs (Binary Large OBjects). Holds up to 65,535 bytes of data

MEDIUMTEXT Holds a string with a maximum length of 16,777,215 characters

MEDIUMBLOB For BLOBs (Binary Large OBjects). Holds up to 16,777,215 bytes of data

LONGTEXT Holds a string with a maximum length of 4,294,967,295 characters

LONGBLOB For BLOBs (Binary Large OBjects). Holds up to 4,294,967,295 bytes of data

SET Similar to ENUM except that SET may contain up to 64 list items and can store more than one choice

ENUM(x,y,z,etc.) Let you enter a list of possible values. You can list up to 65535 values in an ENUM list. If a value is inserted that is not in the list, a blank value will be inserted.

Note: The values are sorted in the order you enter them.

You enter the possible values in this format: ENUM('X','Y','Z')

Number types:

TINYINT(size) -128 to 127 normal. 0 to 255 UNSIGNED*. The maximum number of digits may be specified in parenthesis

SMALLINT(size) -32768 to 32767 normal. 0 to 65535 UNSIGNED*. The maximum number of digits may be specified in parenthesis

MEDIUMINT(size) -8388608 to 8388607 normal. 0 to 16777215 UNSIGNED*. The maximum number of digits may be specified in parenthesis

INT(size) -2147483648 to 2147483647 normal. 0 to 4294967295 UNSIGNED*. The maximum number of digits may be specified in parenthesis

BIGINT(size) -9223372036854775808 to 9223372036854775807 normal. 0 to 18446744073709551615 UNSIGNED*. The maximum number of digits may be specified in parenthesis

FLOAT(size,d) A small number with a floating decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter

DOUBLE(size,d) A large number with a floating decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter

DECIMAL(size,d) A DOUBLE stored as a string , allowing for a fixed decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter

Date types:

DATE() A date. Format: YYYY-MM-DD

Note: The supported range is from '1000-01-01' to '9999-12-31'

DATETIME() *A date and time combination. Format: YYYY-MM-DD HH:MM:SS

Note: The supported range is from '1000-01-01 00:00:00' to '9999-12-31 23:59:59'

TIMESTAMP() *A timestamp. TIMESTAMP values are stored as the number of seconds since the Unix epoch ('1970-01-01 00:00:00' UTC). Format: YYYY-MM-DD HH:MM:SS

Note: The supported range is from '1970-01-01 00:00:01' UTC to '2038-01-09 03:14:07' UTC

TIME() A time. Format: HH:MM:SS

Note: The supported range is from '-838:59:59' to '838:59:59'

YEAR() A year in two-digit or four-digit format.

Note: Values allowed in four-digit format: 1901 to 2155. Values allowed in two-digit format: 70 to 69, representing years from 1970 to 2069

Aggregate Functions

SQL aggregate functions return a single value, calculated from values in a column. Useful aggregate functions:

AVG() - Returns the average value

COUNT() - Returns the number of rows

FIRST() - Returns the first value

LAST() - Returns the last value

MAX() - Returns the largest value

MIN() - Returns the smallest value

SUM() - Returns the sum

Scalar functions

SQL scalar functions return a single value, based on the input value.Useful scalar functions:

UCASE() - Converts a field to upper case

LCASE() - Converts a field to lower case

MID() - Extract characters from a text field

LEN() - Returns the length of a text field

ROUND() - Rounds a numeric field to the number of decimals specified

NOW() - Returns the current system date and time

FORMAT() - Formats how a field is to be displayed

AVG()

· SELECT AVG(column_name) FROM table_name

· SELECT AVG(OrderPrice) AS OrderAverage FROM Orders

· SELECT Customer FROM Orders WHERE OrderPrice>(SELECT AVG(OrderPrice) FROM Orders)

COUNT()

The COUNT() function returns the number of rows that matches a specified criteria.

· SELECT COUNT(column_name) FROM table_name

COUNT(*)

The COUNT(*) function returns the number of records in a table

· SELECT COUNT(*) FROM table_name

· COUNT(DISTINCT column_name)

· SELECT COUNT(DISTINCT column_name) FROM table_name

FIRST()

The FIRST() function returns the first value of the selected column.

· SELECT FIRST(column_name) FROM table_name

· SELECT FIRST(OrderPrice) AS FirstOrderPrice FROM Orders

· SELECT OrderPrice FROM Orders ORDER BY O_Id LIMIT 1

LAST()

The LAST() function returns the last value of the selected column.

· SELECT LAST(column_name) FROM table_name

· SELECT LAST(OrderPrice) AS LastOrderPrice FROM Orders

· SELECT OrderPrice FROM Orders ORDER BY O_Id DESC LIMIT 1

MAX()

The MAX() function returns the largest value of the selected column.

· SELECT MAX(column_name) FROM table_name

· SELECT MAX(OrderPrice) AS LargestOrderPrice FROM Orders

MIN()

The MIN() function returns the smallest value of the selected column.

· SELECT MIN(column_name) FROM table_name

· SELECT MIN(OrderPrice) AS SmallestOrderPrice FROM Orders

SUM()

The SUM() function returns the total sum of a numeric column.

· SELECT SUM(column_name) FROM table_name

· SELECT SUM(OrderPrice) AS OrderTotal FROM Orders

GROUP BY

The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.

· SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name

· SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer

· SELECT Customer,OrderDate,SUM(OrderPrice) FROM Orders GROUP BY Customer,OrderDate

HAVING

· SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name HAVING aggregate_function(column_name) operator value

· SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer HAVING UM(OrderPrice)<2000

· SELECT Customer,SUM(OrderPrice) FROM Orders WHERE Customer='Hansen' OR Customer='Jensen' GROUP BY Customer HAVING SUM(OrderPrice)>1500

UCASE()

The UCASE() function converts the value of a field to uppercase.

· SELECT UCASE(column_name) FROM table_name

· SELECT UCASE(LastName) as LastName,FirstName FROM Persons

LCASE()

The LCASE() function converts the value of a field to lowercase.

· SELECT LCASE(column_name) FROM table_name
· SELECT LCASE(LastName) as LastName,FirstName FROM Persons

MID()

The MID() function is used to extract characters from a text field.

· SELECT MID(column_name,start[,length]) FROM table_name

column_name Required. The field to extract characters from

start Required. Specifies the starting position (starts at 1)

length Optional. The number of characters to return. If omitted, the MID() function returns the rest of the text

· SELECT MID(City,1,4) as SmallCity FROM Persons

LEN()

The LEN() function returns the length of the value in a text field.

· SELECT LEN(column_name) FROM table_name

· SELECT LEN(Address) as LengthOfAddress FROM Persons

ROUND()

The ROUND() function is used to round a numeric field to the number of decimals

specified.

· SELECT ROUND(column_name,decimals) FROM table_name

· SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products

NOW()

The NOW() function returns the current system date and time.

· SELECT NOW() FROM table_name

· SELECT ProductName, UnitPrice, Now() as PerDate FROM Products

FORMAT()

The FORMAT() function is used to format how a field is to be displayed.

· SELECT FORMAT(column_name,format) FROM table_name

· SELECT ProductName, UnitPrice, FORMAT(Now(),'YYYY-MM-DD') as PerDate FROM Products

Way2SMS Java API 2012

2012-09-15T14:25:00.000+05:30

This Tutorial showz that how you can use the www.way2sms.com for sending message using your java application.Here java program by which you can send SMS on mobile through your Java Program (for both Stand Alone App or Web App)

info : i don't know who written these code but i slightly modified them to work in better way.

REQUIREMENT:

Way2sms account
ACTION key.

Once u log in in Way2sms......open Quick SMS page....Right click to view frame source......
Use find (Ctrl + f ) to find ur unique ACTION key....
It must be in such format.....
input type="hidden" name="Action" id="Action" value="asd4kbjfkds"
Copy this hidden value.....use it in String ACTION.

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStreamReader;

import java.io.OutputStreamWriter;

import java.io.PrintWriter;

import java.io.UnsupportedEncodingException;

import java.net.HttpURLConnection;

import java.net.MalformedURLException;

import java.net.Proxy;

import java.net.URL;

import java.net.URLConnection;

import java.net.URLEncoder;

import javax.swing.JOptionPane;

/**

* @author ganesh

public class Way2SMS {

private URLConnection sendSMSConnection;

private String sessionCookie;

private Proxy proxy;

//Function to support connection through an HTTP Proxy

public void setProxy(String proxyHost,int proxyPort)

{

proxy=new Proxy(Proxy.Type.HTTP,java.net.InetSocketAddress.createUnresolved(proxyHost, proxyPort));

}

//Logging in to Way2sms and returning the authentication cookie

//No need to Give the cookie back to sendSMS() but cookie is returned for expanding the flexibility of the code

public String loginWay2SMS(String userName,String password)

{

String cookie=null;

URL urlLogin;

String loginContent;

HttpURLConnection loginConnection;

if(userName==null || userName.isEmpty())

{

System.err.println("A Valid User Name must be present!");

System.exit(0);

}

if(password==null || password.isEmpty())

{

System.err.println("A Valid Password must be present!");

System.exit(0);

}

try {

//UTF-8 encoding is the web standard so data must be encoded to UTF-8

userName=URLEncoder.encode(userName, "UTF-8");

password=URLEncoder.encode(password, "UTF-8");

urlLogin=new URL("http://site5.way2sms.com/Login1.action");

if(proxy==null)

{

loginConnection = (HttpURLConnection) urlLogin.openConnection();

}

else

{

loginConnection = (HttpURLConnection) urlLogin.openConnection(proxy);

}

loginContent="username=" + userName + "&password=" + password;

//Faking that we are from a valid client

loginConnection.setDoOutput(true);

loginConnection.setRequestProperty("User-Agent","Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5");

loginConnection.setRequestProperty("Content-Length", String.valueOf(loginContent.length()));

loginConnection.setRequestProperty("Content-Type","application/x-www-form-urlencoded");

loginConnection.setRequestProperty("Accept", "*/*");

loginConnection.setRequestProperty("Referer", "http://site5.way2sms.com/content/index.html?");

loginConnection.setRequestMethod("POST");

loginConnection.setInstanceFollowRedirects(false);

//Writing the Content to the site

PrintWriter printWriter = new PrintWriter(new OutputStreamWriter (loginConnection.getOutputStream()), true);

printWriter.print(loginContent);

printWriter.flush();

printWriter.close();

//Reading the cookie

cookie = loginConnection.getHeaderField("Set-Cookie");

//System.out.println(cookie);

} catch (MalformedURLException ex) {

System.err.println("Login URL Error");

System.exit(0);

} catch (UnsupportedEncodingException ex) {

System.err.println("Error in encoding Username or Password");

System.exit(0);

}catch (IOException ex) {

System.err.println("Can not connect to Login URL");

System.exit(0);

}

if(cookie==null || cookie.isEmpty())

{

System.err.println("Some error occured...Try again in a few seconds..If still problem exists check your username and password");

}

sessionCookie=cookie;

return cookie;

}

public void sendSMS(String phoneNumber,String message,String action)

{

if(phoneNumber==null || phoneNumber.isEmpty())

{

System.err.println("Enter A Valid Phone Number");

System.exit(0);

}

else

{

try

{

long testLong=Long.valueOf(phoneNumber);

}catch(NumberFormatException ex)

{

System.err.println("Invalid Phone Number");

System.exit(0);

}

if(message==null || message.isEmpty())

{

System.err.println("Enter A Valid Phone Number");

System.exit(0);

}

else if(message.length()>140)

{

System.err.println("Message should be less than 140 characters");

}

if(action==null || action.isEmpty())

{

System.err.println("Enter Valid Action to send Message");

System.exit(0);

}

URL sendURL;

HttpURLConnection sendConnection;

String sendContent;

try {

message=URLEncoder.encode(message, "UTF-8");

sendURL=new URL("http://site5.way2sms.com/quicksms.action");

if(proxy==null)

{

sendConnection = (HttpURLConnection) sendURL.openConnection();

}

else

{

sendConnection = (HttpURLConnection) sendURL.openConnection(proxy);

}

sendContent="custid=undefined&HiddenAction=instantsms&Action="+action+"&login=&pass=&MobNo="+ phoneNumber+ "&textArea="+message;

sendConnection.setDoOutput(true);

sendConnection.setRequestProperty("User-Agent","Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5");

sendConnection.setRequestProperty("Content-Length", String.valueOf(sendContent.getBytes().length));

sendConnection.setRequestProperty("Content-Type","application/x-www-form-urlencoded");

sendConnection.setRequestProperty("Accept", "*/*");

sendConnection.setRequestProperty("Referer", "http://site5.way2sms.com//jsp/InstantSMS.jsp");

sendConnection.setRequestProperty("Cookie", sessionCookie);

sendConnection.setRequestMethod("POST");

sendConnection.setInstanceFollowRedirects(false);

PrintWriter printWriter = new PrintWriter(new OutputStreamWriter(sendConnection.getOutputStream()),true);

printWriter.print(sendContent);

printWriter.flush();

printWriter.close();

//Reading the returned web page to analyse whether the operation was sucessfull

BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(sendConnection.getInputStream()));

StringBuilder SendResult=new StringBuilder();

String line;

while ((line=bufferedReader.readLine()) != null)

{

SendResult.append(line);

SendResult.append('\n');

//Message has been submitted successfully

}

if(SendResult.toString().contains("Message has been submitted successfully"))

{

System.out.println("Message sent to "+phoneNumber+" successfully.");

// JOptionPane.showMessageDialog(null,"Message sent to "+phoneNumber+" successfully.");

}

else

{

System.err.println("Message could not send to "+phoneNumber+". Also check login credentials");

}

bufferedReader.close();

}catch (UnsupportedEncodingException ex) {

System.err.println("Message content encoding error");

System.exit(0);

}catch (MalformedURLException ex) {

System.err.println("Sending URL Error");

System.exit(0);

}catch (IOException ex) {

System.err.println("Sending URL Connection Error");

System.exit(0);

}

public void logoutWay2SMS()

{

try {

HttpURLConnection logoutConnection;

URL logoutURL;

logoutURL = new URL("http://site5.way2sms.com/jsp/logout.jsp");

if(proxy==null)

{

logoutConnection = (HttpURLConnection) logoutURL.openConnection();

}

else

{

logoutConnection = (HttpURLConnection) logoutURL.openConnection(proxy);

}

logoutConnection.setRequestProperty("User-Agent","Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5");

logoutConnection.setRequestProperty("Accept", "*/*");

logoutConnection.setRequestProperty("Cookie", sessionCookie);

logoutConnection.setRequestMethod("GET");

logoutConnection.setInstanceFollowRedirects(false);

BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(logoutConnection.getInputStream()));

while ((bufferedReader.readLine()) != null);

bufferedReader.close();

} catch (MalformedURLException ex) {

System.err.println("Logout URL Error");

System.exit(0);

}catch (IOException ex) {

System.err.println("Logout URL Connection Error");

System.exit(0);

}

Way2SMS()

{

proxy=null;

sendSMSConnection=null;

}

public static void main(String args[])

{

final String USERNAME="9999999999";//REQUIRED

final String PASSWORD="jkjbklbkl";//REQUIRED

final String ACTION="asd456cbvgfdf";//REQUIRED : In order to understand ACTION value please read the blog

Way2SMS sms=new Way2SMS();

//HTTP PROXY

//sms.setProxy("10.1.1.1",8080); //REQUIRED ONLY IF CONNECTING THROUGH A PROXY

StringBuilder phoneNumber= new StringBuilder("8888888888");

StringBuilder message=new StringBuilder("Welcome to Ganesh JAVA Power");

/*if(args.length>0)

{

if(args[0].toLowerCase().compareTo("phone")==0)

{

int i=1;

while(args[i].toLowerCase().compareTo("message")!=0)

{

phoneNumber.append(args[i]);

phoneNumber.append(';');

i++;

}

for(i=i+1;i

{

message.append(args[i]);

message.append(' ');

}

else

{

System.out.println("USAGE : Way2SMS phone ... message ");

System.exit(0);

}

else

{

System.out.println("USAGE : Way2SMS phone ... message ");

System.exit(0);

}

String cookie=sms.loginWay2SMS(USERNAME,PASSWORD);

String textMessage=message.toString();

String strPhoneNumber=phoneNumber.toString();

String arrPhoneNUmber[]=strPhoneNumber.split(";");

for(int i=0;i< arrPhoneNUmber.length;i++)

{

sms.sendSMS(arrPhoneNUmber[i], textMessage, ACTION);

}

sms.logoutWay2SMS();

}

JSTL TAGS

2012-09-10T17:58:00.000+05:30

Required Library file:

jstl-1.2.jar

mysql-connector-java-5.1.6-bin.jar

Example:

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>

<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>

<%@taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>

<html>

<head>

<title> Tag Example </title>

</head>

<body>

<h2> 1.<font color="green">jstl core tags started http://java.sun.com/jsp/jstl/core</font></h2>

------------------------Simple IF LOOP-------------------------

<c:set var="salary" scope="session" value="${2000*2}"/>

<c:if test="${salary > 2000}">

<p>My salary is: <c:out value="${salary}"/><p>

</c:if>

--------------------Exception--------------------------------

<c:catch var ="catchException">

<% int x = 5/0;%>

</c:catch>

<c:if test = "${catchException != null}">

<p>The exception is : ${catchException} <br />

There is an exception: ${catchException.message}</p>

</c:if>

----------------------IF LOOP WITH ELSE--------------------------

<c:set var="salary1" scope="session" value="${1000}"/>

<c:if test="${salary1 > 2000}">

<p>My salary is: <c:out value="${salary1}"/><p>

<c:otherwise>

<p>My salary is: <c:out value="${salary1}"/>

</c:otherwise>

</c:if>

-----------------------WHEN CONDITION------------------------------

<c:set var="s11" scope="session" value="${1000}"/>

<p>Your salary is: <c:out value="${s11}"/></p>

<c:choose>

<c:when test="${s11==9999||s11==10000}">

Salary is Good

</c:when>

<c:when test="${s11>=5000}">

Salary is Medium Level

</c:when>

<c:otherwise>

You had Low salary

</c:otherwise>

</c:choose>

-----------------------------DIV IMPORT----------------------------

<div>

<c:import varReader="java.io.Reader" url="newjsp.jsp"/>

<%--<c:out value="${data}"/>--%>

</div>

--------------------------------FOREACH LOOP------------------------

<br/>

<c:forEach var="i" step="2" begin="1" end="10">

Item: <c:out value="${vengat}"/>

</c:forEach>

--------------------------------------------------------------------

<br/>

<c:forEach var="t" items="dinesh,ganesh,murugan,balaji,anand,lalitha" step="2">

Item: <c:out value="${t}"/> <p>

</c:forEach>

<br/>

----------------------PASSING VARIABLE TO OTHER PAGE----------------

<br/>

<c:url value="newjsp.jsp" var="myURL">

<c:param name="trackingId" value="1234"/>

<c:param name="reportType" value="summary"/>

</c:url>

<c:import url="${myURL}"/>

--------------------------------------------------------------------

<br/>

<c:forTokens var="e1" items="henry,murugan,anand,lalitha,ganesh,dinesh,balaji" delims=",">

</c:forTokens>

<%--<c:redirect url="newjsp.jsp" >

<c:param name="trackingId" value="123456789"/>

<c:param name="reportType" value="summary11111111"/>

</c:redirect>--%>

--------------------------------URL---------------------------------

<br/>

---------------------------------FORMAT TAG--------------------------

<br/>

<h2> 2. <font color="blue">jstl Formatting tags started http://java.sun.com/jsp/jstl/fmt</font></h2>

<c:set var="sr" value="120000.2309"/>

<p>Currency in USA : <b> <fmt:setLocale value="en_US"/>

<fmt:formatNumber value="${sr}" type="currency"/></b></p>

-------------------------------------------------------------------

<br/>

<c:set var="k7" value="1250003.350"/>

<fmt:parseNumber var="j" type="number" value="${k7}" />

<b> Parsed format with fraction 1: <c:out value="${j}"/></b></p>

<fmt:parseNumber var="j" integerOnly="true"

type="number" value="${k7}" />

<b> Parsed format without fraction 2: <c:out value="${j}"/></b></p>

<h3>Number Parsing:</h3>

<c:set var="k6" value="1250003.350" />

<fmt:parseNumber var="i" type="number" value="${k6}" />

<p>Parsed Number (1) : <c:out value="${i}" /></p>

<fmt:parseNumber var="i" integerOnly="true"

type="number" value="${k6}" />

<p>Parsed Number (2) : <c:out value="${i}" /></p>

-------------------------------------------------------------------

<br/>

<c:set var="dt" value="<%=new java.util.Date()%>"/>

<p>Formatted Date 1: <fmt:formatDate type="time"

value="${dt}" /></p>

<p> Formatted Date 2: <fmt:formatDate type="date" value="${dt}"/></p>

<p> Formatted Date 3. <fmt:formatDate type="both" value="${dt}"/>

<p> Formatted Date 4. <fmt:formatDate type="both" dateStyle="short" value="${dt}"/>

<p> Formatted Date 5. <fmt:formatDate type="both" dateStyle="medium" timeStyle="short" value="${dt}"/>

<p> Formatted Date 6. <fmt:formatDate type="both" dateStyle="long" timeStyle="long" value="${dt}" />

<p> Formatted Date 7. <fmt:formatDate type="time" timeStyle="medium" pattern="G" value="${dt}" />

<p> Formatted Date 8. <fmt:formatDate pattern="yyyy-mm-dd" value="${dt}" />

--------------------------------------------------------------------

<br/>

<c:set var="pd" value="09-05-2012"/>

<fmt:parseDate value="${pd}" var="pdat" pattern="dd-mm-yyyy"/>

<p>Parsed Date:<c:out value="${pdat}"/></p>

<c:set var="now" value="20-10-2010" />

<fmt:parseDate value="${now}" var="parsedEmpDate"

pattern="dd-MM-yyyy" />

<p>Parsed Date: <c:out value="${parsedEmpDate}" /></p>

--------------------------------------------------------------------

<br/>

<fmt:bundle basename="Example" prefix="count.">

<fmt:message key="one"/><br/>

<fmt:message key="two"/><br/>

<fmt:message key="three"/><br/>

</fmt:bundle>

<fmt:bundle basename="Example">

<fmt:message key="count.one"/><br/>

<fmt:message key="count.two"/><br/>

<fmt:message key="count.three"/><br/>

</fmt:bundle>

--------------------------------------------------------------------

<br/>

<fmt:bundle basename="samplebundle" prefix="v.">

<fmt:message key="1"/><br/>

<fmt:message key="2"/><br/>

<fmt:message key="3"/></br>

</fmt:bundle>

<fmt:bundle basename="samplebundle">

<fmt:message key="v.1"/><br/>

<fmt:message key="v.2"/><br/>

<fmt:message key="v.3"/></br>

</fmt:bundle>

--------------------------------------------------------------------

<br/>

<fmt:setLocale value="es_ES"/>

<fmt:bundle basename="samplebundle">

<fmt:message key="v.1"/><br/>

<fmt:message key="v.2"/><br/>

<fmt:message key="v.3"/><br/>

</fmt:bundle>

--------------------------------------------------------------------

<br/>

<fmt:setLocale value="en" />

<fmt:setBundle basename="setBundle2" var="hi"/>

<fmt:setBundle basename="samplebundle" var="si"/>

<fmt:setBundle basename="Example" var="ex"/>

<fmt:message key="s.a" bundle="${hi}"/></p>

<fmt:message key="v.2" bundle="${si}"/></p>

<fmt:message key="count.three" bundle="${ex}"/></p>

--------------------------------------------------------------------

<br/>

<c:set var="now" value="<%=new java.util.Date()%>" />

<tr>

<b>

<font color="#FFFFFF" size="4">Formatting:

<fmt:formatDate value="${now}" type="both"

timeStyle="long" dateStyle="long" />

</font>

</b>

</p>

</td>

</tr>

<c:forEach var="zone"

items="<%=java.util.TimeZone.getAvailableIDs()%>">

<tr>

<c:out value="${zone}" />

</td>

<fmt:timeZone value="${zone}">

<fmt:formatDate value="${now}" timeZone="${zn}"

type="both" />

</fmt:timeZone>

</td>

</tr>

</c:forEach>

</table>

--------------------------------------------------------------------

<br/>

<fmt:requestEncoding value="UTF-8" />

<fmt:setLocale value="es_ES"/>

<fmt:setBundle basename="setBundle2" var="lang"/>

<fmt:message key="s.a" bundle="${lang}"/><br/>

<fmt:message key="s.b" bundle="${lang}"/><br/>

<fmt:message key="s.c" bundle="${lang}"/><br/>

<br/>

--------------------Mysql database connection ----------------

<h2> 3.<font color="pink">jstl core tags started http://java.sun.com/jsp/jstl/sql</font></h2>

<sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/sample" user="root"

password="root" />

<c:set var="un" value="ganesh"/>

<sql:query dataSource="${snapshot}" var="rs">

select * from login where username="${un}";

</sql:query>

<tr>

<th>Password</th>

</tr>

<c:forEach var="row" items="${rs.rows}">

<tr>

</tr>

</c:forEach>

</table>

-----------------------------Form Creation---------------------------

<br/>

Enter the User Name: <input type="text" name="un"/> </p>

<br/>

Enter the Password: <input type="text" name="pw"/> </p>

<br/>

</form>

<%--<sql:update dataSource="${snapshot}" var="up">

insert into login values("${paramValues.un}","${paramValues.pw}");

</sql:update>

----------------------------------------------

<sql:query dataSource="${snapshot}" var="rs1">

select * from login;

</sql:query>

----------------------------------------------

<tr>

<th>Password</th>

</tr>

<c:forEach var="row1" items="${rs1.rows}">

<tr>

</tr>

</c:forEach>

</table>--%>

-----------------------------------------------

------------------------------------------------

</body>

</html>

How to use stored procedure in java

2012-09-08T10:40:00.000+05:30

Sample.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

</head>

<body>

<tr>

</tr>

<tr>

<td>Gender</td>

</tr>

<tr>

</tr>

<tr>

<td>Address</td>

</tr>

<tr>

</tr>

<tr>

<td>PinCode</td>

</tr>

<tr>

<td>Phone number</td>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

store.java

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.DriverManager;

import java.sql.*;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class store extends HttpServlet {

protected void processRequest(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException, ClassNotFoundException, SQLException {

response.setContentType("text/html;charset=UTF-8");

PrintWriter out = response.getWriter();

String s=request.getParameter("T1");

String s1=request.getParameter("T2");

String s2=request.getParameter("T3");

String s3=request.getParameter("T4");

String s4=request.getParameter("T5");

String s5=request.getParameter("T6");

String s6=request.getParameter("T7");

try

{

Class.forName("com.mysql.jdbc.Driver");

Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/projects","root","root");

/* using this query for stored procedure

DELIMITER //

CREATE PROCEDURE aa(in name varchar(50),in phone varchar(50),in quali varchar(50))

begin

insert into adddre values(name,phone,quali);

end

CallableStatement css=(CallableStatement) con.prepareCall("{call aa(?,?,?)}");

css.setString(1, s);

css.setString(2, s1);

css.setString(3, s2);

// css.setString(4, s3);

// css.setString(5, s4);

// css.setString(6, s5);

ResultSet rs = (ResultSet) css.executeQuery();

while(rs.next())

{

String ds=rs.getString(1);

System.out.println(":::::::"+ds);

String dss=rs.getString(2);

System.out.println(":::::::"+dss);

}

css.close();

System.out.println("done ********** ");

response.sendRedirect("informa.jsp");

} finally {

out.close();

}

Database :

Database name : Projects

CREATE TABLE 'address' (

'addressid' int(10) default NULL,

'city' varchar(50) default NULL,

'state' varchar(50) default NULL,

'country' varchar(50) default NULL

);

CREATE TABLE 'login' (

'AU_ID' int(11) NOT NULL auto_increment,

'uname' varchar(255) NOT NULL,

'upass' varchar(255) NOT NULL,

PRIMARY KEY ('AU_ID')

);

Create Stored Routine :

Reference forRoutine creation

How to create hibernate in netbeans

2012-09-06T15:15:00.001+05:30

Excel Creation Using Jsp With Mysql Database Connection

2012-09-04T10:58:00.001+05:30

Search the database and export the relevant data into excel format

SearchUser.jsp

<html>

<head>

</head>

<body>

<tr>

<td colspan=3 align="center"><b><span style="font-size:20px;">Create a Excel file with Search Table</span></b></td>

</tr>

<tr>

</tr>

<tr>

<td><b>Search</b></td>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

excelData.jsp:

<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell"%>

<%@ page import="java.io.*" %>

<%@ page import="java.util.*" %>

<%@ page import="java.sql.*" %>

<%!

Connection conn = null;

String url = "jdbc:mysql://localhost:3306/";

String dbName = "db5";

String driver = "com.mysql.jdbc.Driver";

String username = "root";

String userPassword = "root";

int index=3;

int sno=0;

String name="";

java.util.Date date = new java.util.Date();

String filename = "c:\\f"+date.getTime()+".xls" ;

String searchText="";

if(request.getParameter("searchtxt")!=null)

{

searchText= request.getParameter("searchtxt").toString();

System.out.println(""+searchText);

}

try{

HSSFWorkbook hwb = new HSSFWorkbook();

HSSFSheet sheet = hwb.createSheet("new sheet");

HSSFRow rowhead = sheet.createRow((short)2);

rowhead.createCell((short) 0).setCellValue("SNo");

rowhead.createCell((short) 1).setCellValue("First Name");

rowhead.createCell((short) 2).setCellValue("Last Name");

rowhead.createCell((short) 3).setCellValue("Username");

rowhead.createCell((short) 4).setCellValue("E-mail");

rowhead.createCell((short) 5).setCellValue("Country");

Class.forName("com.mysql.jdbc.Driver");

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/db5","root","root");

Statement stmt = conn.createStatement();

String strQuery = "select * from register where firstname like

'%"+searchText+"%' or lastname like '%"+searchText+"%'";

ResultSet rs = stmt.executeQuery(strQuery);

while(rs.next())

{

System.out.println(sno++);

HSSFRow row = sheet.createRow((short)index);

row.createCell((short) 0).setCellValue(sno);

row.createCell((short) 1).setCellValue(rs.getString(1));

row.createCell((short) 2).setCellValue(rs.getString(2));

row.createCell((short) 3).setCellValue(rs.getString(3));

row.createCell((short) 4).setCellValue(rs.getString(4));

row.createCell((short) 5).setCellValue(rs.getString(5));

index++;

}

FileOutputStream fileOut = new FileOutputStream(filename);

hwb.write(fileOut);

fileOut.close();

out.println("<b>Your excel file has been generated</b>");

} catch ( Exception ex ) {

}

DataBase:

# Table structure for table 'register'

CREATE TABLE ‘register’ (

‘SNo‘ int(10) default NULL,

‘firstname‘ varchar(50) default NULL,

‘lastname‘ varchar(50) default NULL,

‘Username‘ varchar(50) default NULL,

‘E-mail‘ varchar(50) default NULL,

‘Country‘ varchar(50) default NULL

);

# Dumping data for table 'register'

REPLACE INTO "register" ("SNo", "firstname", "lastname", "Username", "E-mail", "Country")

VALUES(1,'dsd','gd','fd','fd','fddf');

REPLACE INTO "register" ("SNo", "firstname", "lastname", "Username", "E-mail", "Country")

VALUES(2,'daxs','ddd','ll;','l;l','ll');

Create Jasper Report in NetBeans

2012-08-30T18:54:00.000+05:30

STEP 1: Download ireport plugin for Netbeans

http://plugins.netbeans.org/plugin/4425/ireport

STEP 2: Install plugin in Netbeans

· Click tools --> select option plugin

· Select Downloaded tab --> click Add Plugin Button --> Browse and select your plugin from system location --> click open button

· After that Click Install button --> Next --> Install --> Validation warning dialog box appear Click Continue Button --> click finish

STEP3: Right click your project and select Empty report

STEP 4: select this database icon and create database link

STEP 5: Create Sample Jasper Report and select database icon next to preview button

After that drag and drop text field
Right click -->select Edit expression and
Select your table field here

STEP 6: Call Jasper Report from Java code with database connection

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import net.sf.jasperreports.engine.*;

import net.sf.jasperreports.engine.export.JRXlsAbstractExporterParameter;

import net.sf.jasperreports.engine.export.JRXlsExporter;

import net.sf.jasperreports.view.JasperViewer;

/**

* @author ganesh

public class anand {

public static void main(String[] args) throws IOException

{

try

{

//Specify Your Report Path

JasperReport jasperReport=JasperCompileManager.compileReport("Report\\report3.jrxml");

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/tally" , "root", "root");

Statement stmt = null;

ResultSet rset = null;

String queryString = "SELECT category.`accountno` AS category_accountno, category.`name` AS category_name,category.`type` AS category_type FROM `category` category WHERE accountno BETWEEN 100 and 111";

stmt = conn.createStatement();

rset = stmt.executeQuery(queryString);

JRResultSetDataSource jasperReports = new JRResultSetDataSource(rset);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,null, jasperReports);

//Report saved in specified path

JasperExportManager.exportReportToPdfFile(jasperPrint,"D:\\b1.pdf");

//Report open in Runtime

Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " +"D:\\b1.pdf");

JRXlsExporter exporterXLS = new JRXlsExporter();

OutputStream output = new FileOutputStream(new File("D:\\b1.xls"));

exporterXLS.setParameter(JRExporterParameter.JASPER_PRINT,jasperPrint);

exporterXLS.setParameter(JRExporterParameter.OUTPUT_STREAM, output);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, Boolean.FALSE);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);

exporterXLS.setParameter(JRXlsAbstractExporterParameter.IS_IGNORE_GRAPHICS, Boolean.TRUE);

exporterXLS.exportReport();

//JasperViewer.viewReport(jasperPrint);

}

catch (JRException e)

{

e.printStackTrace();

}

catch (ClassNotFoundException ex)

{

ex.printStackTrace();

}

catch (SQLException ex)

{

ex.printStackTrace();

}

Required Jar Files:

commons-beanutils-1.8.2.jar

2.      commons-collections-3.2.1.jar

3.      commons-digester-2.1.jar

4.      commons-logging-1.1.1.jar

5.      groovy-all-1.7.5.jar

6.      iText-2.1.7.jar

7.      jasperreports-4.5.1.jar

8.      jdt-compiler-3.1.1.jar

9.      mysql-connector-java-5.1.6-bin.jar

10. poi-3.7-20101029.jar

11. rs2xml.jar

java email coding

2012-08-29T18:26:00.000+05:30

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Properties;

import javax.activation.DataHandler;

import javax.activation.DataSource;

import javax.activation.FileDataSource;

import javax.mail.BodyPart;

import javax.mail.Message;

import javax.mail.MessagingException;

import javax.mail.NoSuchProviderException;

import javax.mail.Session;

import javax.mail.Transport;

import javax.mail.Message.RecipientType;

import javax.mail.Multipart;

import javax.mail.internet.AddressException;

import javax.mail.internet.InternetAddress;

import javax.mail.internet.MimeBodyPart;

import javax.mail.internet.MimeMessage;

import javax.mail.internet.MimeMultipart;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class sendmail

{

public static void main(String[] args)
{

String from="Sender Emailid here"; // Sender Emailid here Ex:mysample@gmail.com

String to="Receiver Emailid here"; //Receiver Emailid here

String SMTP_AUTH_PWD=""; //Your Gmail Password

String fileAttachment="Specify File Path here"; //Specify File Path here

String text="hi"; //Text here

System.out.println(fileAttachment);

System.out.println(from);

System.out.println(to);

try

{

String subject="hi"; //Subject here

Properties props = new Properties();

props.put("mail.smtp.host", "smtp.gmail.com");

props.put("mail.smtp.starttls.enable", "true");

props.put("mail.transport.protocol", "smtps");

props.put("mail.smtps.auth", "true");

String SMTP_HOST_NAME = "smtp.gmail.com";

int SMTP_HOST_PORT = 465;

Session mailSession = Session.getDefaultInstance(props);

mailSession.setDebug(true);

Transport transport = mailSession.getTransport();

//Session session = Session.getDefaultInstance(props, null);

Message message = new MimeMessage(mailSession);

message.setSubject("Testing SMTP-SSL");

message.setContent("", "text/plain");

message.addRecipient(Message.RecipientType.TO,new InternetAddress(to));

transport.connect(SMTP_HOST_NAME, SMTP_HOST_PORT, from, SMTP_AUTH_PWD);

// Get a mail session

// Define a new mail message

message.setFrom(new InternetAddress(from));

message.addRecipient(Message.RecipientType.TO, new InternetAddress(to));

message.setSubject(subject);

// Create a message part to represent the body text

BodyPart messageBodyPart = new MimeBodyPart();

messageBodyPart.setText(text);

//use a MimeMultipart as we need to handle the file attachments

Multipart multipart = new MimeMultipart();

//add the message body to the mime message

multipart.addBodyPart(messageBodyPart);

messageBodyPart = new MimeBodyPart();

DataSource source =new FileDataSource(fileAttachment);

messageBodyPart.setDataHandler( new DataHandler(source));

messageBodyPart.setFileName(fileAttachment);

multipart.addBodyPart(messageBodyPart);

// add any file attachments to the message

// addAtachments(attachments, multipart);

// Put all message parts in the message

message.setContent(multipart);

// Send the message

transport.sendMessage(message,message.getRecipients(Message.RecipientType.TO));

// Transport.send(message);

}

catch(Exception e1)

{

System.out.println(e1.getMessage());

}

Required Jar Files:

activation.jar
concurrent-1.3.2.jar
log4j-1.2.15.jar
mailapi-1.4.4.jar
simple-java-mail-2.0.jar
smtp-1.4.4.jar