22 June, 2012

JSTL a rich Web solution for JSP ! Kick your scriptlet over JSP.

By our traditional web development with J2EE is quite deprecated.Now-a-days there are ample of technology provided by different vendors like sun, oracle, micro soft , etc. Out of all JSTL(Java Standard Tag Library) a tech of sun has supreme power to optimize    and encapsulate the core functionality that common to many JSP applications. Instead of mixing tags from numerous vendors in your JSP applications, JSTL allows you to employ a single, standard set of tags.The sun has provides enormous benefits through JSTL.


  I am really disappointed; I am not using JSTL in my current project. Although I know it has many benefits over JSP scriptlet tags. I really want to kick out the scriptlet tags from my jsp. Scriptlets are difficult to maintain & execute by container also.It is a complete solution for web developers/front end developer , no need of prior knowledge of java/j2ee.It support full tag syntax, no need of jsp scriptlet tags.It has following major tag areas :-
      
         -- Core Tags
         -- Formatting Tags
         -- SQL Tags
         -- XML Tags
         -- Function Tags ( JSTL Functions)

There are many advantages of JSTL over JSP. 

         -- It is easy to use, ( avoid scriptlet tags)
         -- We can create our own custom tags
         -- These tags are standardize by sun.
         -- More functionality with easy iteration support tags
         -- XML supports
         -- It uses EL (Expression Language )  

You can get more about these from below given link from sun.

But, its quite simple to use JSTL with your jsp.I have posted here an easy example of JSTL below:-

Before go to the example, you need certain setups & resources like jstl.jar and  standard.jar.

1. You can Download the binary distribution from Apache Standard Taglib and unpack the compressed jar file.
2. Extract those files , and copy all extracted files ( .tld and other files) into WEB-INF\lib .

3. set some necessary tag-lib inside web.xml & enjoy the flavor of JSTL.

Simple Example-


web.xml file

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4"
    xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <jsp-config>
      <taglib>
          <taglib-uri>http://java.sun.com/jsp/jstl/core</taglib-uri>
          <taglib-location>/WEB-INF/lib/c.tld</taglib-location>
      </taglib>
       </jsp-config>
</web-app>

jsp file


<%@ taglib uri="/WEB-INF/lib/c.tld"  prefix="c" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">   
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
  </head>
 
  <body>
  <table>
    <c:forEach var="i"  begin="1" end="10" step="1">
    <tr>
        <c:forEach var="k" begin="1" end="5" step="1">
            <td><c:out value="${k}"></c:out></td>
        </c:forEach>
    </tr>
    </c:forEach>
    </table>
          </body>
</html>

 
Now start the tomcat and run from browser. The out put of the program will be like below :-


I have only used core tag in this example. But there are so many tags including other tag sections discuss above. Also you can develop you own .tld file and own custom tags. 


Read all about JSTL from sun.

By Manoj.

20 June, 2012

Arbic Data/Text in mySql Database Table

Some time we need this type of requirement as per the client given. I have faced this one. But need not to worry there are lots of way by which we can insert data/text into mysql table. Create a table with following steps:-

1. Create a table with Collation - utf8- utf8-bin
2. Then , set all columns datatype should be varchar and  Collation - utf8- utf8-bin
3. And now Apply changes. Ok







This above image setting for table.





This image for setting column . (utf-8-to-column.jpg)



This image , finally data inside the table. (data-in-table.jpg)


Or by using  query

column_name varchar(50) character set utf8 collate utf8_bin ----set for individual column
CHARSET=utf8 ---------Set on  table


Below one dummy query for better understanding-

ALTER TABLE `admin_kairali`.`t_report_language` CHANGE COLUMN `vchBeing` `vchBeing` VARCHAR(200) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  , CHANGE COLUMN `vchScrtry` `vchScrtry` VARCHAR(200) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  , CHANGE COLUMN `vchAccount` `vchAccount` VARCHAR(200) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  , CHANGE COLUMN `vchReceiversign` `vchReceiversign` VARCHAR(4000) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  ;


Now enjoy this read.

By Manoj.( مانوج بواسطة

19 June, 2012

John Yeary: When Do I Use CSS?

John Yeary: When Do I Use CSS?: Image via Wikipedia I have been looking at a number of articles on web technologies, and HTML . One of the things I noticed on a lot of the ...

18 June, 2012

SDLC:- Waterfall Model ( A Leaner Apporach for Designing )

As per our prior knowledge , Software development Life Cycle (SDLC) is the backbone of software development.Its part of systems engineering, information systems and software engineering, is a process of creating or altering information systems, and the models and methodologies that people use to develop these systems , means the every process involves with software development must follow SDLC for every organization.


On the other hand PCL,for project management defined both with a project life cycle (PLC) and an SDLC. According to Taylor (2004) "the project life cycle encompasses all the activities of the project, while the systems development life cycle focuses on realizing the product requirements"

As per my view SDLC is the best fundamental for software development.
There may be so many methodologies are there, but out of all there are finger count methodologies like Prototype Approach, Waterfall Approach,etc. The waterfall apporach is a linear approach. This approach or model has many advantages & Disadvantages, but it is quite popular & acceptable.The initial startup name of this model was Process Model and it has been accepted by many software engineering firms & authors. It ensure the software development process with different phases :-

1. Conception
2. Initiation
3. Analysis
4. Design
5. Coding
6. Testing
7. Implementation and Maintenance.
These all stages/phases are the vital part of this model. And these stages are the key concept of the entire software development.
Conception:-
The word conception , is self meaning word. An idea for create a project/application.
Initiation:-
To implement your ideas or to initialize your Ideas/Conception for start up.
Analysis:-
To analysis the data/requirements for the project/application.
Design:-
To build the concrete of the above points to make an application/project.
Codeing:-
Applying your construction code/logic for physical structure.
Testing:-
Test the application/project for make it accurate or bug free.( ie. unit test,inte. test)
Maintenance:-
To implement  the final product and keep maintenance for that product.Its a long term process .


There are so many development process we are following now-a-days. Because, we need fast & quick delivery, so that we a accepting so many techniques like AGILE,xp,SCRUM etc. Many authors argue on this waterfall model due to lack of fastness or other few disadvantages.
But still its the parent of all design & development models are used now-a-days. For more about Agile  read other posts.


By Manoj

15 June, 2012

J2EE: What is a Struts in our Life ? Struts.

We need to  our life with a easy & smooth track. Now-a-days our technology runs above of the sky with new vision. But , can we feel struts is one of the necessary part of software development , basically on the footprint of JAVA/J2EE.

When I was new to software development ( java/j2ee) at that time struts was new to me & I always afraid about what is that. But, after the span of time slowly slowly deeply I rushed into that struts garden.

Struts framework is an open-source framework for developing the web applications in Java EE, based on MVC-2 architecture. It uses and extends the Java Servlet API. Struts is robust architecture and can be used for the development of application of any size. Struts framework makes it much easier to design scalable, reliable Web applications with Java. The term Framework, is way we find to easy developing environment with all possible features for that environment. Its a complete 3rd party(in other way).

Struts components can be categorize into Model, View and Controller:
  • Model: Components like business logic /business processes and data are the part of model.
  • View: HTML, JSP are the view components.
  • Controller: Action Servlet of Struts is part of Controller components which works as front controller to handle all the requests.
Also Struts is a set of cooperating classes, servlets, and JSP tags that make up a reusable MVC 2 design.
  • JavaBeans components for managing application state and behavior.
  • Event-driven development (via listeners as in traditional GUI development).
  • Pages that represent MVC-style views; pages reference view roots via the JSF component tree.

But the major role in struts is ActionServlet. ActionServlet is a simple servlet which is the backbone of all Struts applications. It is the main Controller component that handles client requests and determines which Action will process each received request. It serves as an Action factory – creating specific Action classes based on user’s request.It has following roles:
  • Process user requests
  • Determine what the user is trying to achieve according to the request
  • Pull data from the model (if necessary) to be given to the appropriate view,
  • Select the proper view to respond to the user
  • Delegates most of this grunt work to Action classes
  • Is responsible for initialization and clean-up of resources

Except ActionServlet , there is one ActionForm, which may lead you to represent data(Usable component) . ActionForm is javabean which represents the form inputs containing the request parameters from the View referencing the Action bean.It has  2 major methods validate() and reset(). These methods are used by struts framework.

Also ActionMapping, ActionForward,Dispatch Action are play major roles in struts. Follow other reads/posts.

To make your application faster & easy , I follow struts.

12 June, 2012

MySQL : Find all Foreign Keys Constraints in a database (MySql)

I was really Unpleasant when I  failed to find out all foreign keys inside my database. Really, that was a great movement when I did it.My project manager was asking again and again , really I was so happy after the solution.

I can do it in MS SQL Server 2000/2008  , but in mysql its not quite easy.So, I share this in this blog, for help other developers to achive the goal.Below the query you can use it in mysql query editor :-



SELECT
f.table_schema as 'schema',
f.table_name as 'table' ,
f.column_name as 'column',
f.constraint_name as 'constraint_name'
FROM `information_schema`.`KEY_COLUMN_USAGE` f
where
f.table_schema='admin_kairali' and f.referenced_column_name  is not null


--Above for a single given table.



SELECT
f.table_schema as 'schema',
f.table_name as 'table' ,
f.column_name as 'column',
f.constraint_name as 'constraint_name'
FROM `information_schema`.`KEY_COLUMN_USAGE` f
where
 f.referenced_column_name  is not null

--For all table.




MySQL: Find Number of Engines and their description in Mysql Database System, Like (InnoDB)


I faced this problem to find the information about engines inside Mysql DB. Its quite easy to work with mysql, but the engine inside mysql are so pretty and the information about the engines can be found by using following commands in query editor/console :-

show engine innodb status;

This above  query /command will help you to find the information about a perticular database.Here I used in this query is innodb engine.

show engines;

This above query /command will help you to find following output ( all engines inside your db and some information about those).

Output:-

1--'MyISAM', 'YES', 'Default engine as of MySQL 3.23 with great performance'
2--'MEMORY', 'YES', 'Hash based, stored in memory, useful for temporary tables'
3--'InnoDB', 'DEFAULT', 'Supports transactions, row-level locking, and foreign keys'
4--'BerkeleyDB', 'NO', 'Supports transactions and page-level locking'
5--'BLACKHOLE', 'YES', '/dev/null storage engine (anything you write to it disappears)'
6--'EXAMPLE', 'NO', 'Example storage engine'
7--'ARCHIVE', 'YES', 'Archive storage engine'
8--'CSV', 'NO', 'CSV storage engine'
9--'ndbcluster', 'NO', 'Clustered, fault-tolerant, memory-based tables'
10--'FEDERATED', 'YES', 'Federated MySQL storage engine'
11--'MRG_MYISAM', 'YES', 'Collection of identical MyISAM tables'
12--'ISAM', 'NO', 'Obsolete storage engine'


Read more about this system internal commands from mysql.





11 June, 2012

Manoj.Blog: Java Struts: The flavor of DispatchAction. Leave A...

Manoj.Blog: Java Struts: The flavor of DispatchAction. Leave A...: Its really good to know that struts has so many features which provides the programmer/developer easy life.Out of all the good thing the ac...

Java Struts: The flavor of DispatchAction. Leave Action and Love DispatchAction .

Its really good to know that struts has so many features which provides the programmer/developer easy life.Out of all the good thing the action part of struts frame work is superb. As you know there are 5 type of action , provided by struts.

But the Dispatch action make your job function centric. Struts DispatchAction from (org.apache.struts.actions.DispatchAction) is one of the Built-in Actions provided along with the struts framework.It works on a single action with multiple function . No need of create multiple action type for operating any task. It gather all related methods into a single.

An abstract Action that dispatches to a public method that is named by the request parameter whose name is specified by the parameter property of the corresponding ActionMapping. This Action is useful for developers who prefer to combine many similar actions into a single Action class, in order to simplify their application design. Read more on this Dispatch Action.


public class MyDispatch_Action extends DispatchAction
 

{
  

public ActionForward add-data(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response) throws Exception{
  System.out.println("You are inside add");
  return mapping.findForward("addmydata");
  }

  

public ActionForward edit-data(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response) throws Exception

 {

  System.out.println("You are inside edit");
    return mapping.findForward("editmydata");
  

 }




return null;

}




The rest are same flavor as other struts.Just enjoy new flavor.

28 May, 2012

Java : JVM Inside. The Story behind JVM. Continue......

In , the previous post , we have discussed some points about JVM in Java platform. Including JVM, java has its own Run time environment(JRE). There are many versions available for JRE, download here.Being byte codes are binary format, Programs intended to run on a JVM must be compiled into a standardized portable binary format, which typically comes in the form of .class files. A program may consist of many classes in different files. For easier distribution of large programs, multiple class files may be packaged together in a .jar (Java Archive file ) file.

The Java application launcher, java, offers a standard way of executing Java code. The JVM runtime executes .class or .jar files, emulating the JVM instruction set by interpreting it, or using a just-in-time compiler (JIT) such as Oracle's HotSpot. JIT compiling, not interpreting, is used in most JVMs today to achieve greater speed. There are also ahead-of-time compilers that enable developers to precompile class files into native code for particular platforms.

Almost virtual machines are similar and the Java virtual machine has a stack-based architecture akin to a microcontroller/microprocessor. However, the JVM also has low-level support for Java-like classes and methods.


JVM have following inside paradigm :- 

1. Bytecode verifier
2. Stack
3. Garbage Collected Heap
4. Method Area


Bytecode Verifier :

It helps to jvm to verifies all bytecode before it is executed. This verification consists basic of three types of checks:-
       1. Branches are always to valid locations
       2. Data is always initialized and references are always type-safe
       3. Access to private or package private data and methods is rigidly controlled.

Stack: 

Stack in Java virtual machine stores various method arguments as well as the local variables of any method. Stack also keep track of each an every method invocation. This is called Stack Frame. There are three registers thats help in stack manipulation. They are vars ( local variable), frame (Execution environment), optop ( Operand Stack ). This registers points to different parts of current Stack.


Method Area:

The byte codes are here. The program counter (PC) points to some byte in the method area. It always keep tracks of the current instruction which is being executed (interpreted). After execution of an instruction, the JVM sets the PC to next instruction ( As we know in ASM language). Method area is shared among all the threads of a process. Hence if more then one threads are accessing any specific method or any instructions, synchorization is needed. Synchronization in JVM is acheived through Monitors (Read this post).

Garbage Collected Heap:

This is one of the main part of java/jvm .This is the place where the objects in Java programs are stored. Whenever we allocate an object using new operator, the heap comes into picture and memory is allocated from there. Unlike C++, Java does not have free operator to free any previously allocated memory. Java does this automatically using Garbage collection mechanism.The garbage collection logic for make memory free and available the resource for more development.

Point to Remember: The local object reference resides on Stack but the actual object resides in Heap only. Also, arrays in Java are objects, hence they also resides in Garbage-collected Heap.



Java: JVM Inside .A story behind JVM.

The word JVM is the core heart of java programming language. It stands for Java Virtual Machine , a simple virtual machine inside your physical computer/system. The virtual refers to not physically it is conceptual.So, it is a virtual machine which can understand byte code.

It is the code execution component of java software platform.A Java virtual machine is software that is implemented on virtual and non-virtual hardware and on standard operating systems. A JVM provides an environment in which Java byte code can be executed, enabling such features as automated exception handling, which provides root-cause debugging information for every software error (exception), independent of the source code. A JVM is distributed along with a set of standard class libraries that implement the Java application programming interface (API). Appropriate APIs bundled together with JVM form the Java Runtime Environment (JRE). 

The term WORA (Write Once and Run Anywhere) make java popular & easy . JVM understand byte code which is the intermediate language between programming and system.The WORA  and   write once, compile anywhere,(WOCA)  which describes cross-platform compiled languages Thus, the JVM is a vital component of the java platform. Typically , we can say JVM makes java platform independent. 


                                                 Java Source File (.java)
                                                                  |
                                                                  |
                                                   Java Compiler ( javac)     
                                                                  |
                                                                  |
                                       Byte code ( .class file, secure code)    
                                        |                         |                         |
                                        |                         |                         |
                                     JVM                   JVM                  JVM
                                       |                          |                         |
                                       |                          |                         |
                                Windows                Linux                   Mac

                                                                                                         Continue to read this in next post

24 May, 2012

MYSQL: Password security problem with mysql Database,Be Aware about secure your Password

Yes , it is true in mysql your password may not secure . It happens with any developer those are using mysql as database. Normally developers are not aware about the password hacking and apply normal query for retrieving  data from database.

Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes.
In discussing security, it is necessary to consider fully protecting your password when login. Commonly we are using such below where clause for comparison for login or validation . But, it is completely not safe.

where binary pass='yourpassword'

But, this above code is not secure and it can be overlapped by using '=' . In place of you password you can use '=' , and see it will hack your password. Your condition is going to true and login success. So, Be careful if you are a responsible developer for your organization.

Your data can be fetch if your condition is '=', it is hacked or checked true. So, follow the process below.

Always use password security mechanism for secure your password.Always follow mysql manual for security before applying security on mysql password.

But when retrive data , you can  use HEX() function from convert it to Hexa decimal format .
As below :

HEX(vchadmin_pass)=HEX('YOur password')

Or use

MD5() other function mentioned below table.


So, Always follow the password security for secure. You can encrypt or decrypt the password when store using the following table :-

AES_DECRYPT()Decrypt using AES
AES_ENCRYPT()Encrypt using AES
COMPRESS()Return result as a binary string
DECODE()Decodes a string encrypted using ENCODE()
DES_DECRYPT()Decrypt a string
DES_ENCRYPT()Encrypt a string
ENCODE()Encode a string
ENCRYPT()Encrypt a string
MD5()Calculate MD5 checksum
OLD_PASSWORD()Return the value of the pre-4.1 implementation of PASSWORD
PASSWORD()Calculate and return a password string
SHA1(), SHA()Calculate an SHA-1 160-bit checksum
SHA2()Calculate an SHA-2 checksum
UNCOMPRESS()Uncompress a string compressed
UNCOMPRESSED_LENGTH()Return the length of a string before compression






23 May, 2012

JAVA: Implementing Singleton design patten for creating single instance with example.

As per the old post related to singleton design patten , here the example of implementation.For implementing the singleton design patten for creating single instance of a class , below one example for better understanding:

//Class with Main function for calling singleton class
public class TestSingleTon {

    /**
     * @param args
     */

    public static void main(String[] args) {
    SingleTonClass classinstance=SingleTonClass.getInstance();
    System.out.println("My SingleTon member value is="+classinstance.testval);
    }

}


//Singleton class 
public class SingleTonClass {

    //create an instance
    private static SingleTonClass my_instance=new SingleTonClass();
   
    private SingleTonClass(){
        //Private Constructor here
        //Not allow to create an object out side
    }
   
    //method to access the instance
    public static SingleTonClass getInstance(){
        return my_instance;
    }
   
    //Member variable
    int testval=10;
   

     //if remove comment from below line , the program will not execute.
    //SingleTonClass s1=new SingleTonClass();
   
}


The output of this program is :-

My SingleTon member value is=10

This is the simple implementation & ensuring one object creation of singleton design patten.Also there are so many other methods are there for implementing signleton ( lazy loading, multiple jvm, etc ).

Thank you
Good Reading.

18 May, 2012

HTML/JAVASCRIPT: Creating a window in Javascript

Some times its an useful job to create a window with a new requirement. But , when we are in development room/area , we always remember any search engine to fine the solutions for any type of problem. Even I , also  following some of the search engine. 

But, it is a fact that I am always try to avoid this type of habits. Be , traceable  for finding any solution. This article is one of the mail memory & also my teaching my myself , that don't guess any coding is normal and easy , so don't remember.


So, below the topic:- code line put inside script tag


window.open('','','left=0,top=0,width=1000,height=780,toolbar=0,scrollbars=0,status=0');orwondow.open();

All parameters are not mandatory  to put with values. If you don't need any scrollbar,toolbar,status bar then you can put 0 as the value here, either put 1. 

17 May, 2012

How to set print area in JSP/HTML page for printer

This is one the interesting topic related to print the specific data from a jsp/html page. Directly to printer, without other browser data. I have done a quite obvious way in javascript for set the print area for printing. I faced this problem in my development team with me, for set a specific area for print.

Caution:-  Use of JavaScript may not be  always acceptable, due to client. If user/client disable the script setting in browser these may not work properly. But, every browsers are support script by default.  

As we know, window. Print() is used for print in JavaScript. There are so many ways to do a printing task in jsp/html page. Out of all I have mentioned 2 process below with advantage & disadvantage.  Put the below function in script area of your page:-

Procedure-1
function setDivPrint(val){
var printdata=document.getElementById('printarea').innerHTML;
var srcOriginalContent=document.body.innerHTML;
document.body.innerHTML=printdata;
window.print();
document.body.innerHTML=srcOrigionalContent;
}
Here ‘printarea ‘ is the id of printable div. It has some limitation, with getting the cancel button click event and some more. I am not mentioning all here. But in procedure-2 is so eminent than procedure-1.

Procedure-2

function setDivPrint(val){
var printdata=document.getElementById('printarea').innerHTML;
var printwindow=window.open('','','left=0,top=0,width=1000,height=780,toolbar=0,scrollbars=0,status=0');
printwindow.document.write(printdata);
printwindow.document.close();
printwindow.focus();
printwindow.print();
printwindow.close();
}

Here ‘printarea ‘ is the id of printable div. .This method is recommended to use. In this method no need to get the cancel or print button event. Suppose the user click on cancel, then the main original page should come, but it may not coming with the Procedure-1 . So, No need to face this problem in Procedure-2.

03 May, 2012

Manoj.Blog: MYSQL: Daily auto backup of database for windows o...

Manoj.Blog: MYSQL: Daily auto backup of database for windows o...: Quite simple , because you have read the older pos t for creating backup  (dump) . But, here the process of automatic backup the mysql data...

MYSQL: Daily auto backup of database for windows or Scheduled backup

Quite simple , because you have read the older post for creating backup  (dump) . But, here the process of automatic backup the mysql database in a particular time in your local system. This may not run your remote system.

Steps for create a schedule for back :-

 Step 1- Create a batch file with the command mysqldump and necessary options that mentioned in the old post .

Step 2- Goto Start => All program => Accessories => System Tool => Scheduled Task

Step 3- Then create a new schedule with given batch file and scheduled date & time.




Now ,  wait for the given scheduled  time and see the backup file is created in the destination directory .






Manoj.Blog: MYSQL:How to create MySql Dumps using batch file ...

Manoj.Blog: MYSQL:How to create MySql Dumps using batch file ...: Manoj.Blog: MYSQL:How to create MySql Dumps using batch file ... : Too much ,, really in MYSQL finding complete solution like oracle & sql ...

02 May, 2012

MYSQL:How to create MySql Dumps using batch file ...

Manoj.Blog: MYSQL:How to create MySql Dumps using batch file ...: Too much ,, really in MYSQL finding complete solution like oracle & sql server is too difficult. That I have faced so many times with my d...

MYSQL:How to create MySql Dumps using batch file (WINDOWS)


Too much ,, really in MYSQL finding complete solution like oracle & sql server is too difficult. That I have faced so many times with my development team. One of my colleague asked about the dumps creation using batch file. Really I searches many sites on internet with unexpected   results. Taking dumps using command line I have already post on my blog , but in this case I need a batch file for execution. And finally when I prepare it for serve , I was really happy and now I am sharing this happiness with all my visitors .  Below the code inside the batch file :-

cd "c:\Program Files\MySQL\MySQL Server 5.0\bin\"
mysqldump -hyourIPaddress -uyour_user_name -pyour_password yourdbname > d:\output_backup.sql
exit


Now create a batch file and paste the code above with host,username, password,database name and output file name for store data.

Example 1:-
cd "c:\Program Files\MySQL\MySQL Server 5.0\bin\"
mysqldump -hlocalhost -uroot -proot manojdb > d:\mybackupdumps.sql
exit

If you want to take all database backup/dumps you can also do by following code :-

cd "c:\Program Files\MySQL\MySQL Server 5.0\bin\"
mysqldump -hlocalhost -umyuname -pmypassword --all-databases > d:\myalldatabasedumps.sql
exit


MYSQL Reference manual provides so many options for using with mysqldump . Some of the most useful are below :-


--add-locks  is used for    Surround each table dump with LOCK TABLES and UNLOCK TABLES statements.

 --all-databases  is used for Dump all tables in all databases.
  
 --comments  is used for Add comments to the dump file.

--compact is used for produce more compact out put .

--ignore-table=db_name.tbl_name is used for Do not dump the given table



You can also follow mysql reference manual for dumps creation  by Click Here. 



Hope it will help you.
Ping me always.

Manoj.Blog: MYSQL: Create database dump from command line (WIN...

Manoj.Blog: MYSQL: Create database dump from command line (WIN...: Hi Readers, Really in MYSQL/WINDOW, I have many obstacles and searches internet more than 7-8 hour for create a dump file of my database...

MYSQL: Create database dump from command line (WINDOWS)

Hi Readers,


Really in MYSQL/WINDOW, I have many obstacles and searches internet more than 7-8 hour for create a dump file of my database with compatible for all mysql db engines. And finally I fry some thing below: -

Steps-1 Go to your MYSQL installed directory inside bin
              C:\Program Files\MySQL\MySQL Server 5.0\bin
Steps-2 Use mysqldump command for create the backup.
              mysqldump -uyour_username -pyour_password your_databasename > D:\mybackup.sql

Steps-3 Press Enter


Now check your D drive and find the mybackup.sql file.


Hope it will help you.
Ping me always.

25 April, 2012

Manoj.Blog: HTML Marquee : set Stop and Play on mouse over an...

Manoj.Blog: HTML Marquee : set Stop and Play on mouse over an...: Hello readers, As you  marquee  can create a scrolling preview. But when we need to make some operation like mouse over ,mouse out etc. S...

HTML Marquee : set Stop and Play on mouse over and mouse out

Hello readers,

As you  marquee  can create a scrolling preview. But when we need to make some operation like mouse over ,mouse out etc. Stop & play of marque like below:-


<marquee  onmouseover="this.setAttribute('scrollamount',0,0);" onmouseout="this.setAttribute('scrollamount',6,0);">
<a  style="color: #FF0000" href="#" title="Notice">New notice for Marquee readers</a>
</marquee>


This above code will help you for stop and play on mouse over and mouse out respectively.


Hope it will help you.
Thankx

20 April, 2012

Manoj.Blog: Java : Get Last inserted ID (Auto Increment) from...

Manoj.Blog: Java : Get Last inserted ID (Auto Increment) from...: Really I faced lot of questions & problems related to this topic , basically when we are using mysql as the backend. But its quite obvious ...

Java : Get Last inserted ID (Auto Increment) from Database Query

Really I faced lot of questions & problems related to this topic , basically when we are using mysql as the backend. But its quite obvious & simple for find the last inserted record id (Auto increment ) and primary key also from an insert query ( Not from a procedure). I am not using callable statement for achieve this task. Simple directly by query :-

You can retrive value by using:-

1. select last_insert_id()
2. RETURN_GENERATED_KEYS


Follow the example below:-


String query="insert into m_time_list(vchTime,vchGMT,createdDate) values('"+form.getTxtTime()+"','"+form.getRdbgmt()+"',curdate())";
            pstmt=connection.prepareStatement(query,Statement.RETURN_GENERATED_KEYS);
            sts=pstmt.executeUpdate();   
            rs=pstmt.getGeneratedKeys();
            int sid=0;
            while(rs.next()){
                sid=rs.getInt(1);
            }

Now , Sid contains the return inserted ID.



Hope it will help you.
Ping me:
javadevelopersguide@blogspot.com