Deepak Pandey

Mysql workbench

2010-10-19T01:53:00.000-07:00

MySQL workbench:

To download mysql work bench .Click here

Recently i got chance to work on database. and my assignment was to create database and ER diagram. And to complete this assignment, i used MySQL workbench.

About MySQL Workbench

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench is available as a native GUI tool on Windows, Linux and OS X in different editions. See the following link for more information about the editions available.

If you are familier with other gui tools like MySQL query browser and mysql administrator, both features are available in workbench. Other is data modeling, there you can create ER diagram.
Three parts of MySQL workbench:

1) SQL development: You can run your database query. very similar to mysql query browser.

2) Data Modeling: You can create ER diagram.

3)Server: very similar to mysql administrator browser. You acan create backup and restore of your database script.

I installed on windows 7 and vista. It was creating problems in XP. Error was .netframework, i tried but did not complete it.

Thanks
Deepak

Firbug

2010-09-25T01:59:00.000-07:00

Firebug:

To download the firbug development tool:
http://getfirebug.com/

Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

Features:
Inspect HTML and modify style and layout in real-time: After installing or adding plug-in of firebug, see at the bottom of, an icon image (a worm image), click here,
Use the most advanced JavaScript debugger available for any browser
Accurately analyze network usage and performance

Some very helpful shortcuts and commands when working with firebug. Thanks to Duvet-Dayez for creating this cheat sheet.

Firebug cheat sheet

Deepak

Internationalization in GWT

2010-09-23T04:13:00.000-07:00

In my last assignment, i got good assignments on GWT like internationalization, history implementation and maintenance of log.
They are easy, but while you are doing these thing first time specially in GWT,then it is not a simple nut.

So i would like to discuss internationalization here.

First create GWT project. (Here i am creating project name: UsePropertyScreen)

Create 2 interface and 2 properties file with same name like PropertConstant.java and PropertyMessage.java and property files with PropertyConstant.properties and PropertyMessage.properties.

Code for PropertConstant.java
package deepak;
import com.google.gwt.i18n.client.Constants;
public interface PropertConstant extends Constants {

String hello();
//Add more key values here
}

Code for PropertyMessage.java

package deepak;
import com.google.gwt.i18n.client.Messages;
public interface PropertyMessage extends Messages {

String alertMessage();
String alertParameter(String arg);
}

Now Make entries in .property file also. Please provide same key as you gave in java file. i.e function name in java =key value in properties

PropertyConstant.properties
hello=Hello Deepak

PropertyMessage.java
alertMessage=Hello deepak!, welcome
alertParameter= Hello {0}

So if you want to pass more parameter, define function with parameter and in property file use {0} for first parameter and {1} for second parameter etc

Now make samall change in UsePropertyScreen.gwt.xml.file

<inherits name="com.google.gwt.i18n.I18N">

<extend-property name="locale" values="PropertyMessage">

And now use these key value inside client side file. It can't be used server side files.

Screen.java
package deepak;

import com.google.gwt.user.client.ui.RootPanel;
import com.google.gwt.user.client.ui.VerticalPanel;
import com.gwtext.client.widgets.MessageBox;

public class UsePropertyScreen implements {
private final PropertyMessage message=GWT.create(PropertMessage.class);
private final PropertyConstant constant=GWT.create(PropertConstant.class);
public UsePropertyScreen(){
MessageBox.alert(constant.hello());
MessageBOx.alert(message.alertMessage());
MessageBOx.alert(message.alertParameter("Deepak Pandey"));

RootPanel.get().add(new Label(constant.hello()));

}

}

Now run this application.

YOu will get 3 alert,
First with : "Hello Deepak"
Second with : "Hello Deepak!, welcome"
Third with : Hello Deepak Pandey

By default it will take above files. But if you want to change propert file according to your language. Create property file in following manner:
PropertyMessage_hi.properties
and select Hindi language or use hi in url address. So you are able to identify.
and change in UsePropertyScreen.gwt.xml,
<extend-property name="locale" values="hi">

cheers!

Google Web Toolkit: Jar not loaded

2010-08-26T01:11:00.000-07:00

When a Google Web Toolkit (GWT) web application is deployed to Tomcat web server,
you may encounter a warning message as follows.
org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(<$webAppsFolder$>\WEB-INF\lib\gwt-user.jar) - jar not loaded.
See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class

This raises just because WebappClassLoader has loaded the servlet.jar already. The gwt-user.jar already contain the content of the servlet.jar file. Even though this message can be ignored, this warning message can be avoided just by replacing the gwt-user.jar file with gwt-servlet.jar (which comes with Google Web Toolkit (GWT) download).

gwt-servlet.jar has been created by removing the content of the servlet.jar from the gwt-user.jar, so this change will not have any impact on your project.

Rs symol

2010-07-30T01:15:00.000-07:00

Hello friends,

Indian rupee had got its sign like $ etc. and i hope that currency will receive greater international recognition with the launch of a new symbol for the currency.

Following is the link from where you can download Foradian.ttf font.
http://blog.foradian.com/

After downloading,paste fordian.ttf into control panel-->Font folder.
Now select font Rupee foradian in your document.
And use (~) key just below the Esc key.

Image of symbol:

Feel proud to be an Indian.
"Sare jahan se achha Hindostan hamara"

JExcel API

2010-07-24T03:02:00.000-07:00

In my last assignment, i got requirment to write data into excel file.I got the solution JExcel API.I got solution in the form of JExcel.Today, i will try to demonstrate JExcel API.
JExcelApi allows developers to read Excel spreadsheets and to generate Excel spreadsheets dynamically.It also contains a mechanism which allows java applications to read in a spreadsheet, modify some cells and write out the new spreadsheet.

Download JExcelApi JAR files from

http://jexcelapi.sourceforge.net/

Benifit of this API is:
Any operating system which can run a Java virtual machine (i.e., not just Windows) can both process and deliver Excel

spreadsheets. Because it is Java, the API can be invoked from within a servlet, thus giving access to Excel spreadsheets over

internet and intranet web applications.

Demo Application:

imported packages are following:
import jxl.Workbook;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;

public ByteArrayOutputStream generateExcelReport() throws IOException, WriteException {
/* Stream containing excel data */
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();

/* Create Excel WorkBook and Sheet */
WritableWorkbook workBook = Workbook.createWorkbook(outputStream);

or writing data in to generated xls
//Workbook workbook = Workbook.getWorkbook(new File(“Deepak.xls”));
WritableSheet sheet = workBook.createSheet("Project List", 0);

/* Generates Headers Cells */
WritableFont headerFont = new WritableFont(WritableFont.TAHOMA, 12, WritableFont.BOLD);
WritableCellFormat headerCellFormat = new WritableCellFormat(headerFont);
headerCellFormat.setBackground(Colour.PALE_BLUE);
sheet.addCell(new Label(1, 1, "Project Id", headerCellFormat));
sheet.addCell(new Label(2, 1, "Project Name", headerCellFormat));

/* Generates Data Cells */
WritableFont dataFont = new WritableFont(WritableFont.TAHOMA, 12);
WritableCellFormat dataCellFormat = new WritableCellFormat(dataFont);

int currentRow = 2;
for (User user : getUsers()) {
sheet.addCell(new Label(1, currentRow, user.getLastName(),dataCellFormat));
sheet.addCell(new Label(2, currentRow, user.getFirstName(),dataCellFormat));
currentRow++;
}

/* Write & Close Excel WorkBook */
workBook.write();
workBook.close();

return outputStream;
}

public List getUsers() {

try{
Class.forName("com.mysql.jdbc.Driver");
Connection

con=DriverManager.getConnection("jdbc:mysql://localhost/pmsdatabase2?user=root&password=mysql");
PreparedStatement ps=con.prepareStatement("select project_code,project_name from project");
ResultSet rs=ps.executeQuery();
while(rs.next()){
users.add(new User(rs.getString(1),rs.getString(2)));
}

}catch(Exception e){
System.out.println("Coming here!!"+e);
}
return users;
}

COde for User.java:

class User{

private String firstName;
private String lastName;
//getter and setter of firstName and lastName
public User(){}

public User(String lastName,String firstName){
this.firstName=firstName;
this.lastName=lastName;

}

}

Call this method by using any servlet.
A complete document is available on sourceforge or other sites.

Thanks!
Deepak

Great day for Indians

2010-06-25T01:51:00.000-07:00

Today, like many indians i feel proud because today Queen's Baton reaching India. Wow what a great day for me and all indians.It is exactly a 100 day countdown for the first ever Commonwealth Games being hosted by India.

India, which will be hosting the prestigious international sporting event in the national capital, received the baton from Pakistan. Queen's Baton Relay, which has traveled across the world after it was launched by Queen Elizabeth-II at Buckingham Palace in Oct 2009, arrived in Amritsar through the Wagah Border.

I also hope like others that this kind of events would heal the strained relationship between India and Pakistan as well as bolster the ties between all countreis.

Short Introduction GWT (Google Web ToolKit)

2010-06-24T03:17:00.000-07:00

GWT:

In last couple of months, i am working on GWT (Google Web ToolKit). I am not great fan of this techonology because i got too many problems.

It uses well-known Remote Procedure Call (RPC) principles implemented by a generic servlet (RemoteServiceServlet), which you can specialize for your own needs. You also can use JavaScript Object Notation (JSON) as the data interchange format for your HTTP messages sent with the GWT HTTPRequest class.
Way of creating the application.
1)One way just install GWTSDK and create application by using following command
webappcreator -out projectname packagename.projectname
It creates structure similar to web applciation.
src:
--packagename.projectname.gwt.xml(This file contains information about entry point and inherited modules)
--packagename.client
--projectname.java (By default this is entry class and it runs while we run this applciation.)
--GreetingServiceAsync.java ( An interface with methods)
--GreetingService.java ( An interface which extends RemoteService)
--packagename.server
--GreetingServiceImpl (extends RemoteServiceServlet implements GreetingService )
This class overrides the methods of GreetingService
war:
--WEB-INF (with classes, lib folders and web.xml (similar to normal j2ee web application))
--projectname.html and .css
--build.xml (for detais of build.xml read ANT in detail)

In next post,I would like to discuss these files in detail
Now import this project to eclipse workspace ,build required jar (all required jar --inside bin of GWT folder or parallel to webappcreator) and run as JAVA Application (Hosted Mode)

2) Second way install plugin for GWT on eclipse. You will get 3 icons. One blue button ('g' is written on it) and other with red ('G' is written)and etc
Now just click on blue button and you got screen where you write project name and package name. (Uncheck Google App Engine for Now)
You project hasbeen created. If you want to use extra jar ,then build them.Some extra folders are created like test and test classes ,shared etc. Rest similar to above.

Problem: Less control over the client-side code of your application because it’s eventually generated by the GWT compiler.GWT provides a compiler that translates the Java code on the client side into JavaScript and DHTML.So you can use only few JAVA API's (lan and util).

Personally i got these error:
1)When i create war file, i am not able to create it properly while in normal web application i can create easily. (according to me This error is not because of GWT, but little bit tough for me..:( ) I am still with this error.
2)On changing platforms (Windows to linux and vice-versa), some functions doesn't support. So it requires extra time.

Maybe i am new of this tecgonology that's why i am getting these problem or it has.
But it creates good application where i want to use AJAX. Much dynamic site and better look can be created using this techonology.

Jar Needed for it:
gwt-dev-windows.jar or gwt-dev-linux.jar: Programming tools including the compiler. The embedded Web browser provided by GWT is platform-dependent.
gwt-user.jar: The GWT runtime.
gwt-servlet.jar: The jar to deploy on your application server with the code generated by the GWT compiler. It contains the RemoteServiceServlet.

Any suggestion or solution of problem. Plz tell me.

Thanks!!

A basic application for iBatis use

2010-06-19T03:22:00.000-07:00

Last month i got chance to learn some new techonologies like GWT (Google Web ToolKit) and iBatis. Firstly i would like to demonstrate application on iBatis. In upcoming posts, i would cover GWT.

I found iBatis very useful because With Ibatis I find myself getting the Job done faster, I create any POJO any set of tables, and I link them, much flixability in that field, but little extra work, building Queries and managing Maps (Little time required here). I never worked or got chance to learn hibernate.So bit difficult for me to tell that which is much better.But anyway here i developed a small application which only tells you that how you can use iBatis in your projects.

Download iBatis.jar
http://ibatis.apache.org/javadownloads.html

iBatis:

Step1: create SQLMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
<settings useStatementNamespaces="true"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://localhost:3306/mhrddemo"/>
<property name="JDBC.Username" value="root"/>
<property name="JDBC.Password" value="mysql"/>
</dataSource>
</transactionManager>
<sqlMap resource="DataBean.xml"/>
</sqlMapConfig>

you can create property file and then use that values in this config file.

2)create another xml where you write query:
DataBean.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Contact">



<select id="getAll" resultClass="ibdeep.DataBean">
select university_id,entity_type,entity_description from entity_type
</select>

<resultMap id="result" class="ibdeep.DataBean">
<result property="university_id" column="university_id"/>
<result property="entity_type" column="entity_type"/>
<result property="entity_description" column="entity_description"/>

</resultMap>
<select id="getById" resultMap="result">
select * from entity_type where entity_type=#entity_type#
</select>

</sqlMap>

3) create a java file which has getter and setter of table fields or properties.

package ibdeep;

class DataBean
{

private String university_id;

private String entity_type;

private String entity_description;

public DataBean(){

}

public DataBean(String university_id,String entity_type,String entity_description){

this.university_id=university_id;
this.entity_type=entity_type;
this.entity_description=entity_description;

}

public String getUniversity_id(){

return university_id;

}

public void setUniversity_id(String university_id){

this.university_id=university_id;

}

public String getEntity_type(){

return entity_type;

}

public void setEntity_type(String entity_type){

this.entity_type=entity_type;

}

public String getEntity_description(){

return entity_description;

}

public void setEntity_description(String entity_description){

this.entity_description=entity_description;

}

}

Step 4): Create another java file
package ibdeep;

import com.ibatis.common.resources.Resources;

import com.ibatis.db.sqlmap.SqlMap;

import com.ibatis.sqlmap.client.*;

import java.io.Reader;

public class SqlMapManager {
private static SqlMap sqlMap = null;
static SqlMapManager smm;

public static SqlMapClient getSqlMapClient() {
try {
Reader reader = Resources
.getResourceAsReader("ibdeep/SqlMapConfig.xml");
SqlMapClient sqlMapper = SqlMapClientBuilder
.buildSqlMapClient(reader);
reader.close();

return sqlMapper;
} catch (Exception e) {
System.out.println("Map Exception");
e.printStackTrace();
throw new RuntimeException(e.getMessage(), e);
}
}

public void setSqlMap(SqlMap sqlMap) {
SqlMapManager.sqlMap = sqlMap;
}

public static SqlMap getSqlMap() {
return sqlMap;
}
}

Step 5) create properties file.you can use it.You can pass these values directly

url=jdbc:mysql://localhost:3306/mhrddemo
login=root
password=mysql

Step 6) Finally create java file which uses

package ibdeep;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import java.io.*;
import java.sql.SQLException;
import java.util.*;

class IBatisExample
{
public static void main(String[] args)
throws IOException,SQLException{
Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
SqlMapClient sqlMap =
SqlMapClientBuilder.buildSqlMapClient(reader);

//Output all contacts

System.out.println("All Contacts");
List<DataBean> contacts = (List<DataBean>)
sqlMap.queryForList("Contact.getAll",null);
DataBean contact = null;
for (DataBean c : contacts) {
System.out.print(" " + c.getUniversity_id());
System.out.print(" " + c.getEntity_type());
System.out.print(" " + c.getEntity_description());
contact = c;
System.out.println("");
}
}
}

I hope it is useful.

A Simple Apllication with DWR:

2010-04-22T23:21:00.000-07:00

A Simple Apllication with DWR:

DWR: Direct Web Remoting-Easy Ajax for java

Link for DWR tutorial and download is:
http://directwebremoting.org/dwr/index.html

I found it very useful for my project PMS(Project Management System).
That's why I would like to demonstrate a simple application.

Just create webproject and put dwr.jar into lib.

Make changes in web.xml:
"<servlet>
<servlet-name>dwr-invoker</servlet-name>
<servlet-class>uk.ltd.getahead.dwr.DWRServlet</servlet-class>
<init-param>
<param-name>debug</param-name>
<param-value>true</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>dwr-invoker</servlet-name>
<url-pattern>/dwr/*</url-pattern>
</servlet-mapping>"

create dwr.xml and put following entries
"<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dwr PUBLIC "-//GetAhead Limited//DTD Direct Web Remoting 0.4//EN" "http://www.getahead.ltd.uk/dwr/dwr.dtd">

<dwr>
<allow>
<create creator="new" javascript="DwrDemo">
<param name="class" value="deep.DwrDemo"/>
</create>

</allow>
</dwr>"
value of class where you write your fuction which you want to call on any event.
and this javascript (Here DwrDemo) willbe created corresponding to that class.

Now we try to use it in a simple JSP page.
Add these lines in you JSP.

" <script type='text/javascript' src='dwr/engine.js'></script>
<script type='text/javascript' src='dwr/util.js'></script>

<script type='text/javascript' src='dwr/interface/DwrDemo.js'></script>
<script type="text/javascript">

function demo() {
var name = DWRUtil.getValue("name");

DwrDemo.demo(name,function(val)
{
DWRUtil.setValue("first",val);
}
);
}
</script>

This javascript function calls demo() method which is inside DwrDemo method.
val is value which is returned by function demo().

<body>
<select id="name" name="name" onchange="demo();">
<option value="Deepak">Deepak</option>
<option value="Anil">Anil</option>
<option value="Akash">Akash</option>
<option value="Mayank">Mayank</option>
</select>

<input type="text" id="first"/>
</body> "

Class deep.DwrDemo is given below.
package deep;

public class DwrDemo {

public String demo(String name)
{
if(name.equals("Deepak"))
return "Hello "+name+" Pandey";
else
return "Hello "+name;
}

}

Now Run your application.

Project Management System

2010-03-30T23:38:00.000-07:00

Hi,

Last time i wrote about Project Management System(PMS). URL for PMS is

http://pms.iitk.ernet.in/

Thanks!!
Deepak

Add Graphs by Using JFree Chart

2010-03-19T22:11:00.000-07:00

Recently i want to add graphs in PMS application. There are too many ways to do this.One of them is JFree Chart.Steps for this are following..

Step1: Download Demo Application of JfreeChart demo and get library jar.

Step2: Add following lines in your code and import files which is required.

JFreeChart chart = ChartFactory.createPieChart("Pie Chart created by Deepak Pandey", pieDataset, true, true,true);
BufferedImage bi = chart.createBufferedImage(500, 500);
chart.setBackgroundPaint(new Color(173, 230, 163));
BufferedImage buf = chart.createBufferedImage(500, 500, null);
try {
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(response.getOutputStream());
JPEGEncodeParam param = encoder.getDefaultJPEGEncodeParam(buf);
param.setQuality(0.75f, true);
encoder.encode(buf, param);

} catch (Exception e) {
System.out.println("Exception in JSP"+e);
}

Step3: Run you application

You can create this chart on a frame.
Create JFrame Object. and then add JFreeChart object and make this JFrame Object visible.

More Information of this JFreeChart,access following link
http://www.jfree.org

Thanks!!!

Custom tag

2010-03-02T00:20:00.000-08:00

1)Create a class which extends BodyTagSupport or implements Tag

package deep;

import javax.servlet.jsp.tagext.BodyTagSupport;
import java.io.*;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;

public class Deepak extends BodyTagSupport {

BodyContent bodyContent;

public int doStartTag() throws JspException {

return EVAL_BODY_TAG;
OR
return SKIP_BODY;

}

public void setBodyContent(BodyContent
bodyContent) {
this.bodyContent = bodyContent;
}

public int doAfterBody() throws JspException {

return EVAL_BODY_TAG;
OR
return SKIP_BODY;

}

public int doEndTag() throws JspException {

return EVAL_PAGE;
}
}
//If It returns SKIP_PAGE,then code after the tag will not be executed ,in case of EVAL_PAGE it willbe calculated
2)Create tld(For ex:deep.tld)

3)Edit your web.xml

4)Add line in your JSP page
<%@ taglib uri="/WEB-INF/tag/name.tld" prefix="n" %>

and use tag which you defined earlier

5)Run your application

These are the steps which involved in making custom tag.Any suggestion or correction,plz leave comment.

Thanks
Deepak

Project Management System

2010-02-07T20:43:00.000-08:00

This system(PMS) can be used to manage projects. This includes project creation, task allocation, daily task monitoring, Gantt charts, sharing of documents, messaging and report generation.
Features
Managing project: User can add projects,view project according to enable/disable,update its detail
Monitoring task: Add task under projects,update its status etc

Managing organization:

Add,View and edit organisation.Admin user will assign project to user for an organisation.
Gantt chart: User can analyze project status by using Graphical Interface.
Managing resource: Add Member for your project.
N-level user: Every level of user can add its subordinate user.
Document sharing: Upload/download document for projects.
Reporting on demand:Report generation according to project status,user,task etc
Security:Proper authentication etc
E-mail notification: When a user is added or he assign task etc, a notification mail hasbeen sent.This mail configuration is configurable.

We are still working for features,for good graphics desgin and more user friendly,more graphics. And i request you to everyone,plz give suggession for more correction.It is an open source project and anyone can use and customize acording to their needs.

URL for this application:
http://202.141.40.218/

Thanks
Deepak

Validation using validator framework

2010-01-21T22:58:00.000-08:00

Validation on a form using validation form

1)Create a new web application
2)Add struts capabilities
3)create new action,form and jsp
4)Add the following lines in Struts-config.xml

//This is for validator plug in

plug-in className="org.apache.struts.validator.ValidatorPlugIn">
set-property property="pathnames"
value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml"/>

and in action tag ,add (validate="true") also.

6)Edit validation.xml

?xml version="1.0" encoding="UTF-8"?>
!DOCTYPE form-validation PUBLIC
"-//Apache Software Foundation//DTD Commons Validator Rules Configuration 1.1.3//EN"
"http://jakarta.apache.org/commons/dtds/validator_1_1_3.dtd">

form-validation>
formset>
form name="loginform" >
field property="name" depends="required,minlength" >
arg0 key="err.name" />
arg1 key="${var:minlength}" name="minlength" resource="false" />
var>
var-name>minlength
var-value>3
/field>
field property="pass" depends="required" >
arg0 key="err.pass" />
/field>
/form>
/formset>
/form-validation>

7)Edit Form JSP

html:javascript formName="loginform"/>
html:form action="login" onsubmit="return validateLoginform(this)">

onsubmit return validateFormName(this).

8)Test your application

Thanks
deepak

Use Tiles in your Struts Application

2010-01-14T23:24:00.000-08:00

Application Using Tiles:

For Eclise:
1) Create New Web-Project
2)Add Struts Capabilities.
3)Create "layout.jsp"
Use this Syntax:

<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles" %>

tiles:insert attribute="header"/>
How you want to show your page.Like header,footer,main,left,body etc.Specify it here.

4)Make following Entry in "tiles-defs.xml"

tiles-definitions>
-- Base Tiles Definition
This is the main definition.You extend it in other definition.
It means if you can use same jsp or override it.
-->
definition name="base.definition" path="/Layout.jsp">
put name="header" value="/WEB-INF/JSP/header.jsp" />
put name="left" value="/WEB-INF/JSP/LeftLink.jsp"/>
put name="left" value="/WEB-INF/JSP/welcome.jsp"/>
put name="footer" value="/WEB-INF/JSP/footer.jsp" />

-- Tiles Definition of welcome page -->
definition name="page.welcome" extends="base.definition">
put name="title" value="Welcome page" />
put name="body" value="/WEB-INF/JSP/welcome.jsp" />

5)Edit Struts-Config.XML

Required part:
plug-in className="org.apache.struts.tiles.TilesPlugin">
set-property property="definitions-config" value="/WEB-INF/tiles-defs.xml"/>
set-property property="moduleAware" value="true" />
set-property property="definitions-parser-validate" value="true" />

And define your actions as you want.
path="/welcome.do"
redirect="true" />

action-mappings>
action path="/welcome"
type="home.WelcomeAction">
forward name="showWelcome" path="page.welcome" />

action path="/leftlink"
type="home.LinkAction">
forward name="showLink" path="page.left" />

6)Create jsp according to your view and URL which you are giving in tiles-defs package

7)Create your actions.

8)Run your application.

I think it is useful.If any required step is still remaining,plz correct it.

Thanks
Deepak

Tree Structure in JSP

2009-08-27T23:29:00.000-07:00

Hi,

Its very useful if you want to show some structure in hierarchical way.

Requirement:treetag.jar and taglib49.tld (I can't upload here these files,you can download it form internet)

edit your web.xml file:
description This is the tree structure description
display-name Deepak display-name
servlet-name xmlTree servlet-name
servlet-class xmlTree servlet-class
servlet
servlet-mapping tree servlet-name
url-pattern /run1 url-pattern
servlet-mapping
taglib
taglib-uri /com/cj/tree taglib-uri
taglib-location /WEB-INF/Tag/taglib49.tld taglib-location
taglib
Now write in your jsp following line:
for JSP or in struts application,use following lines:
<%
root=new com.cj.tree.TreeBean();
root.setCode("Root");
root1=new com.cj.tree.TreeBean();
root1.setCode("deepak pandey");

rec("deepak pandey",root1);//this fuction is defined,because i want to get tree dynamically

root.addChild(root1);
%>
<%!
ResultSet rs=null;
com.cj.tree.TreeBean root;
com.cj.tree.TreeBean root1;
void rec(String s1,com.cj.tree.TreeBean root1)
{
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/pms1?user=root&password=123");
PreparedStatement ps1=con.prepareStatement("SELECT user_Id,project_name FROM validate v where permittedby=? and Project_Name='PMS'");
ps1.setString(1,s1);
ResultSet rs1=ps1.executeQuery();
while(rs1.next())
{
System.out.println(rs1.getString(1));
com.cj.tree.TreeBean node11=new com.cj.tree.TreeBean();
node11.setCode(""+rs1.getString(1));
rec(rs1.getString(1),node11);
root1.addChild(node11);
}
}
catch(Exception e1){System.out.println("error is"+e1);}
}
%>
tree:createTree defaultConnectors="false" treePicture="order_asc.gif" nodePicture="order_asc.gif" openPicture="order_desc.gif" verticalConnector="vertical.gif" middleConnector="middle.gif" modelBean="<%=root%>" dhtml="true"

Another way :
<%= "This is Tree Structure" %>
tree:createTree dhtml="true"//for image etc write in this tag
tree:addNode code="Deep"
tree:addNode code="Deepak1.1"
tree:addNode code="Deepak1.2"
tree:addNode code="Deepak1.2.1"
tree:addNode code="Deepak1.2.2"
tree:addNode>
tree:addNode code="Deepak1.3"
tree:addNode>
tree:addNode code="Deepak2"
tree:createTree>
tree:createTree>
For any query,you can ask.

a basic application in Struts

2009-06-29T19:54:00.000-07:00

Currently i am learning struts and i want to share some basics of it.Here i will tell how to create a basic struts application.

Struts is a free open-source framework for creating Java web applications.

Model-View-Controller (MVC) architecture:
The Model represents the business or database code, the View represents the page design code, and the Controller represents the navigational code. The Struts framework is designed to help developers create web applications that utilize a MVC architecture.(Learn MVC before learning Struts)

The framework provides three key components:

A "request" handler provided by the application developer that is mapped to a standard URI.

A "response" handler that transfers control to another resource which completes the response.

A tag library that helps developers create interactive form-based applications with server pages.

Setting Up Development Environment:

1)jdk 1.6 2)Tomcat 6.0 3)Eclipse

Step 1:-On Eclipse create new Web project and add Struts capabilities.(In myEclipse-->Click on myEclipse and project capabilities and add Struts capabilities)

Step 2:-Now create a New Form,action and JSP.

(select project-->new-->other-->MyEClipse-->WebStruts-->Struts 1.2-->Form,action,jsp)

Give name ,super class(ActionForm)

if you everything is right,it should be there.

Inside src:

1)A form bean:

/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.yourcompany.struts.form;

import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;

/**
* MyEclipse Struts
* Creation date: 05-20-2009
*
* XDoclet definition:
* @struts.form name="myForm"
*/
public class MyForm extends ActionForm {
/*
* Generated fields
*/

/*
* Generated Methods
*/

/**
* Method validate
* @param mapping
* @param request
* @return ActionErrors
*/
public ActionErrors validate(ActionMapping mapping,
HttpServletRequest request) {
// TODO Auto-generated method stub
return null;
}

/**
* Method reset
* @param mapping
* @param request
*/
public void reset(ActionMapping mapping, HttpServletRequest request) {
// TODO Auto-generated method stub
}
/*here you will get getter and setter of Properties,which you gave*/

}

3)A property file is also there.

# Resources for parameter 'com.yourcompany.struts.ApplicationResources'
# Project StrutsDemo

key=value

2)Action class

/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.yourcompany.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.yourcompany.struts.form.MyForm;

/**
* MyEclipse Struts
* Creation date: 03-20-2009
*
* XDoclet definition:
* @struts.action path="/my" name="myForm" input="/form/my.jsp" scope="request" validate="true"
*/
public class MyAction extends Action {
/*
* Generated Methods
*/

/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {

/* Write logic here or function which you want to perform*/
MyForm myForm = (MyForm) form;// TODO Auto-generated method stub

return mapping.findForward null;
}

}

Inside WEB-INF

3)Struts_config

I feel its the heart of struts.

Entries are given below:

attribute="myForm"
input="/form/my.jsp"
name="myForm"
path="/my"
scope="request"
type="com.yourcompany.struts.action.MyAction" >

name="success"
path="/Success.jsp"
redirect="true" />

4)web.xml

action
org.apache.struts.action.ActionServlet

config
/WEB-INF/struts-config.xml

debug
3

detail
3

0

action
*.do

index.jsp

Step 3:Now you can run struts application.Give some fields in your form and try to print them in your JSP,which you will call.

For any mistake,sorry!!

and for query,plz ask.

Thanks

Deepak

Tips for green living

2009-05-04T10:30:00.001-07:00

Use Public transport when available.

use a mug or glass for your drinks instead of disposable cups

When traveling on a bike, give lifts to other travelers. Helps save fuel.

Reduce, Re-Use And Re-cycle

Get your vehicles checked and serviced regularly, to reduce carbon and smoke emission

Save water / electricity

Print documents only if neccesary and in fewer number of copies. Use both sides of the page to print (Set this as your default setting). Also you may use advance print options to print multiple pages on the same page.

Car pool to your workplace, it only needs a small adjustment in your schedules. You can socialize and get to know your neighbors and colleagues while driving, reduce your driving stress and save the money spent on fuel and maintenance.

Soak the rice and lentils in water for sometime before you cook, it not only helps you save cooking gas, but is also good for health as the grains absorb water

Once a day, avoid taking lift and climb up to your apartment. It would not only help save the high power consumed by lifts but would also help you reduce those extra calories and the cost of joining the gym.

You should only take and prepare the food as much as you can eat. Do not waste it. If it is going wasted make sure to feed a dog or cow.

Exchange your old appliance for newer one which consumes less energy

Switch Off Your Engine at Traffic Signal

Do not throw used oils of vehicles in drainage which will mix up with water when raining and results in water pollution.

Solar energy is eco-friendly and helps to save electricity

Computer or your PC consumes more electricity than a laptop computer. Encourage employees use laptops in office and save up to 90% of energy.

Pay Online Bills to Save Trees

For further details you can visit following site:
http://www.commonfloor.com/green-living?f=elsjgl

GeekEvaluation,Online test,Prehiring Test

2009-04-09T06:18:00.000-07:00

Last monday,i was chatting with my friend.He asked me some questions about GeekEvaluation.
So i want to again discuss about GeekEvaluation.
GeekEvaluation is web based online assessment and evaluation solution.What features make different from others are following:

1)The most unique feature is that it geekevaluation allows you can add your own questions. You can even import the files and create your own exams.

2)It allows you to customize the exams as per your requirements. You can mix and match various subjects to create your won customized exams.

3)And the important thing that it is not just the technical tests , as the name suggest. You can virtually create any type of tests here.
And the best deal....... while others charge same price if you add your own questions or do not add , geekevaluation charges only $0.99 for each tests.

GeekEvaluation will help you in filtering the candidates,you are looking to hire them in next project.These prehiring tests are designed by experienced programmers & software engineers who know very well what it takes to complete a project successfully.Unlike other sites, we are exclusively focused on evaluating technical expertise of the candidates.

You could find more details of our features here

http://www.geekevaluation.com/features.html

Thanks.
Deepak

Impact of Nano

2009-03-26T09:26:00.000-07:00

Now finally most awaited product of TATA i.e "NANO" CAR hasbeen launched in India.It was normally asked to me that what's the impact of Nano in India.
Last year,It was the hot topic for discussion.Now it hasbeen launched then again it is back.Here i would like to discuss only benifits.
The first benifit is safety.It will provide more safety than a 2 wheeler.The family of four person struggling for space in dangerously wobbling two wheeler.Now Nano will provide a good option.
Second,people have option for buying a small used car to reap the benifits of affordability and fuel efficiency,could choose to buy a new car in form of NANO.Fuel efficiency is also good i.e near about 20km/litre.
Impact of Nano on 2 wheeler segment and used car segment couldbe high relatively high compared to its impact on small car segment,this depends on performance of car,how it stabilises and user reviews of initial performance once it hits the roads.In last,Time will tell how the future of this move pans out. So far the initial response for the product has been mostly positive.

Thanks.

What is market bottom?

2009-03-13T09:50:00.000-07:00

AFTER writing off 2008 as a bad dream, the Indian investor is now left wondering whether it is time to call a market bottom anytime soon or if 2009 will be a repeat of the miserable 2008. The year till date has not been particularly encouraging for equity investors with the sensex down about 14% and the mid and small cap indices by a steeper 20% or thereabouts. In addition, the rupee is down another 6% year to date and the foreign institutional investor has continued the selling spree with around $2 billion of net sales in 2009 till date following the $13 billion of sales in 2008. Expert opinion appears divided between a potential market rebound and an imminent crash.
In jan 2008,sensex was above the 20000 but now only 8000.so where is bottom?but
I read it in a newspaper that the intelligent investor should identify companies that can survive the downturn and generate good returns when the tide turns over the next few quarters.
If it is possible then it's a great news for all of us.

Thanks.

Evaluate your technical skill,prehiring test

2009-02-23T08:16:00.000-08:00

Hello friends,

Here i want to talk about geekevaluation.(It is web based online assessment and evaluation solution)

Geekevaluation will help you in filtering the candidates,you are looking to hire them in next project
These prehiring tests are designed by experienced programmers & software engineers who know very well what it takes to complete a project successfully.Unlike other sites, we are exclusively focused on evaluating technical expertise of the candidates.

The most unique and exciting feature is that it geekevaluation allows you to add your own questions. You can even import the files and create your own exams.

You can customize the exams as per your requirements. You can mix and match various subjects to create your own customized exams.You can virtually create any type of tests here.

Thanks.

Deepak

2009-02-23T00:48:00.000-08:00

Hi friends
JSF (JavaServer Faces) is Sun's standard Java web development technology. This technology greatly simplifies developing web applications and is well suited to create rich web applications. It is a robust component based framework, event driven programming model offering a lot of reusable UI components, extensible architecture, support for multiple client devices etc.You will need the following:JDK1.4,Tomcat 5.0 or any other servlet container (JBoss, Resin, JRun) and Ant.
I hope this information is helpful for you(This information is only for freshers).
For more detail,the links are java.sun.com/javaee/javaserverfaces/ ,en.wikipedia.org/wiki/JavaServer_Faces etc. Thanks. Deepak