Access data from mysql through struts-hibernate integration

Access data from mysql through struts-hibernate integration

Hi friends, I am making a program in which I want to access data from mysql through struts-hibernate integration. My search command is working properly but my delete and insert command gives output correctly but they don't update mysql table. Here is my program coding :

hibernate.cfg.xml: my configuration file

org.hibernate.dialect.MySQLDialect com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/employee root 1234 10 true org.hibernate.dialect.MySQLDialect update save

hibernate.hbm.xml my mapping file

InsertDataAction.java My insert data action class

/* * To change this template, choose Tools | Templates * and open the template in the editor. */

package com.myapp.struts;

import java.sql.SQLException;

import org.hibernate.Query; import javax.servlet.ServletContext; import org.hibernate.SessionFactory; import org.hibernate.Session; import org.hibernate.cfg.Configuration; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionErrors; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.action.ActionMessage; /** * * @author pradeep.kundu */ public class InsertDataAction extends Action {

private static final String SUCCESS = "success";
private static final String FAILURE = "failure";

boolean flag; @Override public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { ActionErrors errors = new ActionErrors(); InsertDataForm idf = new InsertDataForm(); Integer userId = idf.getuserId(); String firstName = idf.getfirstName(); String lastName = idf.getlastName(); Integer age = idf.getage(); Long number = idf.getnumber(); Session session = null; System.out.println("Getting session factory"); /*Get the servlet context */ try { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); ServletContext context = request.getSession().getServletContext(); /*Retrieve Session Factory */ SessionFactory _factory = (SessionFactory) context.getAttribute(HibernatePlugIn.SESSIONFACTORYKEY); /*Open Hibernate Session */ session = _factory.openSession();

     String str = "INSERT INTO emp(userId,`firstName`,`lastName`,age,number)"
                    + " VALUES (?,?,?,?,?) ";
     Query query = session.createSQLQuery(str);
      query.setParameter(0,userId);
      query.setParameter(1,firstName);
      query.setParameter(2,lastName);
      query.setParameter(3,age);
      query.setParameter(4,number);
      int row = query.executeUpdate();
     // session.save(query);
      session.close();
       saveErrors(request, errors);
    if (errors.isEmpty()) {
        flag = true;
    } else {
        flag = false;
    }
   }
   catch (Exception ex) {
        errors.add("SQLException", new ActionMessage("error.SQLException"));
        throw new SQLException(ex.fillInStackTrace());
    }

    if (flag == true ) {
        return mapping.findForward(SUCCESS);
    } else {
        return mapping.findForward(FAILURE);
    }

} }

DeleteDataAction.java my delete data action class

/* * To change this template, choose Tools | Templates * and open the template in the editor. */

/* * To change this template, choose Tools | Templates * and open the template in the editor. */

package com.myapp.struts;

import org.hibernate.SessionFactory; import org.hibernate.Session;

import org.hibernate.Query;

import org.hibernate.cfg.Configuration; import javax.servlet.ServletContext; import java.util.List; import java.util.ArrayList;

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;

/** * * @author pradeep.kundu */ public class DeleteDataAction extends Action {

private static final String SUCCESS = "success";
private static final String FAILURE = "failure";

@Override
public ActionForward execute(ActionMapping mapping, ActionForm form,
        HttpServletRequest request, HttpServletResponse response)
        throws Exception {
         List<String> listM = new ArrayList<String>();
         DeleteDataForm sdf = (DeleteDataForm)form;
         Integer userId= sdf.getuserId();

         System.out.println("Getting session factory");

/*Get the servlet context */ ServletContext context = request.getSession().getServletContext(); Session session = null; try { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); /*Retrieve Session Factory */ SessionFactory _factory = (SessionFactory) context.getAttribute(HibernatePlugIn.SESSIONFACTORYKEY); /*Open Hibernate Session */ session = _factory.openSession();

String str = "delete from emp where userId = ? "; Query query = session.createSQLQuery(str); query.setParameter(0,userId); //session.delete("from emp where userId ="+userId); int row = query.executeUpdate(); if (row != 0){ listM.add("Record is successfully deleted");} else { listM.add("User Id not exit"); }
/*Close session */ session.close(); System.out.println("Hibernate Session Closed"); } catch(Exception e){ System.out.println(e.getMessage()); } request.setAttribute("listM", listM); return mapping.findForward(SUCCESS); } }

SearchDataAction.java search action class

/* * To change this template, choose Tools | Templates * and open the template in the editor. */

package com.myapp.struts;

import org.hibernate.SessionFactory; import org.hibernate.Session; import org.hibernate.criterion.Restrictions; import org.hibernate.Criteria;

import javax.servlet.ServletContext; import java.util.List;

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;

/** * * @author pradeep.kundu */ public class SearchDataAction extends Action {

private static final String SUCCESS = "success";
private static final String FAILURE = "failure";

@Override
public ActionForward execute(ActionMapping mapping, ActionForm form,
        HttpServletRequest request, HttpServletResponse response)
        throws Exception {

         SearchDataForm sdf = (SearchDataForm)form;

         System.out.println("Getting session factory");

/*Get the servlet context */ ServletContext context = request.getSession().getServletContext(); /*Retrieve Session Factory */ SessionFactory _factory = (SessionFactory) context.getAttribute(HibernatePlugIn.SESSIONFACTORYKEY); /*Open Hibernate Session */ Session session = _factory.openSession(); //Criteria Query Example Criteria crit = session.createCriteria(Emp.class); crit.add(Restrictions.like("userId", sdf.getuserId())); //Fetch the result from database List tutorials= crit.list(); request.setAttribute("searchresult",tutorials); /*Close session */ session.close(); System.out.println("Hibernate Session Closed");

    return mapping.findForward(SUCCESS);

} }

HibernatePlugin.java plugin file

package com.myapp.struts;

import java.net.URL; import javax.servlet.ServletContext; import javax.servlet.ServletException; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.apache.struts.action.ActionServlet; import org.apache.struts.action.PlugIn; import org.apache.struts.config.ModuleConfig; import org.hibernate.HibernateException;

public class HibernatePlugIn implements PlugIn { private String _configFilePath = "/hibernate.cfg.xml";

/**
 * the key under which the <code>SessionFactory</code> instance is stored
 * in the <code>ServletContext</code>.
 */
public static final String SESSION_FACTORY_KEY 
        = SessionFactory.class.getName();

private SessionFactory _factory = null;

public void destroy() { try{ _factory.close(); }catch(HibernateException e){ System.out.println("Unable to close Hibernate Session Factory: " + e.getMessage()); }

}

public void init(ActionServlet servlet, ModuleConfig config) throws ServletException { System.out.println("***********"); System.out.println("* Initilizing HibernatePlugIn ***"); Configuration configuration = null; URL configFileURL = null; ServletContext context = null;

 try{
        configFileURL = HibernatePlugIn.class.getResource(_configFilePath);
        context = servlet.getServletContext();
        configuration = (new Configuration()).configure(configFileURL);
        _factory = configuration.buildSessionFactory();
        //Set the factory into session
        context.setAttribute(SESSION_FACTORY_KEY, _factory);

 }catch(HibernateException e){
    System.out.println("Error while initializing hibernate: " + e.getMessage());
 }
 System.out.println("*************************************");

}

/**
 * Setter for property configFilePath.
 * @param configFilePath New value of property configFilePath.
 */
public void setConfigFilePath(String configFilePath) {
    if ((configFilePath == null) || (configFilePath.trim().length() == 0)) {
        throw new IllegalArgumentException(
                "configFilePath cannot be blank or null.");
    }

    System.out.println("Setting 'configFilePath' to '"  + configFilePath + "'...");
    _configFilePath = configFilePath;
}

/*(SessionFactory) servletContext.getAttribute (HibernatePlugIn.SESSIONFACTORYKEY); */

}

Please tell me solution as soon as possible

Thanks & Regards Pradeep Kundu

View Answers

May 11, 2012 at 3:56 PM

Please visit the following link:

http://www.roseindia.net/struts/struts-hibernate/









Related Tutorials/Questions & Answers:
Access data from mysql through struts-hibernate integration
Access data from mysql through struts-hibernate integration  Hi friends, I am making a program in which I want to access data from mysql through struts-hibernate integration. My search command is working properly but my
access data from mysql through struts
access data from mysql through struts  I am Pradeep Kundu. I am making a program in struts in which i want to access data from MySQL through struts. I am using Strut 1.3.8 , Netbean 6.7.1 and MySQL 5.5. In this program ,I want
Advertisements
Struts - Hibernate Integration
the following link:ADS_TO_REPLACE_2 Struts Hibernate Integration Thanks...Struts - Hibernate Integration  Hi, I need to integrate the struts with hibernate.. can u pls tell me the process of configuring etc etc WITHOUT
struts and hibernate integration
struts and hibernate integration  i want entire for this application using struts and hibernate integration here we have to use 4 tables i.e... the following link: Struts Hibernate Integration
struts hibernate integration application
also use annotation as mapping metadata. About struts hibernate integration... of the struts hibernate integration application example. Description...Struts2 hibernate integration application. In this tutorial we are going
Struts-Hibernate-Integration - Hibernate
Struts-Hibernate-Integration  Hi, I was executing struts hibernate intgeration code the following error has occured. Anyone can give me... the following link: http://www.roseindia.net/struts/struts-hibernate/ Hope
Migrating from mysql to MS Access
Migrating from mysql to MS Access  Hi I am hoping for some help I need to write a conversion program (SQL statements) to import existing data in a MYSQL database to a MS Access database. any suggestions would be appreciated
Struts Hibernate Integration
or to learn Struts and Hibernate Integration. You can download the source... Struts Hibernate       Hibernate is Object-Oriented mapping tool that maps the object view of data
How to access (MySQL)database from J2ME?
How to access (MySQL)database from J2ME?  I am new to J2ME. I am using NetBeans. Can anyone help me? How to access (MySQL)database from J2ME? ( I search a lot I found that there is need to access database through servlet
update data to mysql database through JTextField
update data to mysql database through JTextField  I am getting an error, when i am updating a data to mysql database through JTextField. Send me...(); JOptionPane.showMessageDialog(null,"Data successfully Updated to the database
Video Tutorial: How to access MySQL through JDBC?
How to access MySQL through JDBC? The interface that is used to access... of "How to Access MySQL through JDBC?":ADS_TO_REPLACE_1 In the JAR... required. The below list elucidates the process of accessing MySQL through
Need to access data from another application
Need to access data from another application  Hi Tech masters, I want to develop a reporting application.for that I need to access data from a third party application. I want to access data from a software called service
retreiving data from microsoft access database
retreiving data from microsoft access database  How can i retrieve data from microsoft access when i have select the vaules in combo box and text box. When i select these values... i want to retrieve the corresponding columns
Retrieve The Data From MySql Datbase
Retrieve The Data From MySql Datbase   How to Retrieve The Data From MYSQL database TO Use Select the Emp_id Option.And Also Search Option
Data retrieve from mysql database
Data retrieve from mysql database  Hi sir, please give some example... text field using struts and hibernate. Regards Subrat   The given... from the dropdown, related data will get displayed on the textboxes. Here we have
How to access data yearly from DB in C# ?
How to access data yearly from DB in C# ?  how to access data yearly from database in C#. I have code but i m not able to retrieve data yearly from... as Student_ID,payment FROM fee" + ses + " where date1='" + date1
access image from ajax store in mysql using jsp
access image from ajax store in mysql using jsp  access image from ajax store in mysql using jsp (code to access image captured by camera and store in mysql
How to delete data from MySQL?
How to delete data from MySQL?  Hi, How I can conditionally delete the data from MySQL Table? Thanks   Hi, You can use the where clause to conditionally delete the data from MySQL database table. Here is some query
jfreechart display from access database data.
jfreechart display from access database data.  I have made a database... to retrieve the data from the access database using prepared statement and then display... is to be done in a servlet.. Note that it is a access made database. How can I
Integrating Struts and Hibernate
Integrating Struts and Hibernate           This article explains the integration of Struts... Hibernate in your Struts project. We will be using Hibernate Struts plug
store data from a variable in mysql?
store data from a variable in mysql?  sir last time asked you tell me how to retrieve data from a database mysql and store it in an int variable... of the calculation from an int variable into mysql in a new table of database. how
retrieve data from mysql database
retrieve data from mysql database  hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data from mysql...;/html> retcombosearch.php form is <?php mysql_connect ("localhost
design chart takes data from database and through jsp page
design chart takes data from database and through jsp page  how can I design chart takes data from database and through in jsp page
Purge Data from Mysql tables
Purge Data from Mysql tables  Hi, i have to write a mysql procedure to purge data from tables. but written procedure clear entire tables data. Please give me the solution for purging data. CREATE DEFINER=`root`@`localhost
display data from a table in Access Database in a HTML page
display data from a table in Access Database in a HTML page  how to display data from a table in Access Database in a HTML page in a Java Program
php import data from excel to mysql
php import data from excel to mysql  php import data from excel to mysql
Retrieve image from mysql database through jsp
Retrieve image from mysql database through jsp... to retrieve image from mysql database through jsp code. First create a database.... Before running this java code you need mysql connector jar file
Access all the fields from table through JSP
Access all the fields from table through JSP... data from the specified table. Before running this java code you need.... This is first jsp page that has a link 'show data from table', which displays all
Fetch the data from mysql and display it on php form
Fetch the data from mysql and display it on php form  when i press on login button, after succesful login the related data of that person should be display in other textbox
retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp  hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box
Exporting data from mysql into csv using jsp
Exporting data from mysql into csv using jsp  Hi friends.... I want to export the data from mysql to csv file using... i am having 30 columns in my database.. Eg- text1,text2,text3,....,upto text30... i want to export this data
Building and Testing Struts Hibernate Plugin Application
will build and test our Struts Hibernate Integration application. Compiling... for deployment, open console and go to "C:\Struts-Hibernate-Integration\code\WEB... strutshibernate.war in the "C:\Struts-Hibernate-Integration\dist" directory
MYSQL retrieve record from Data table
MYSQL retrieve record from Data table  Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field
Select Employee and display data from access database in a jtable
Select Employee and display data from access database in a jtable  I... a employee's name from a comboBox and the jtable will be filled with all... name of the customer is stored in a access database. Below is how it should
retrieve data from mysql database and store it in a variable ?
retrieve data from mysql database and store it in a variable ?  sir , I am working on a project , in which I have to apply operation on input data which is stored in mysql. so to apply some arithmetic operation on it we have
Exporting data from mysql to csv file
Exporting data from mysql to csv file  Hi friends.... I want to export the data from mysql to csv file... i am having 30 columns in my database.. Eg... example that retrieves the data from the database and save it into csv file
how to retreive data dynamically from mysql to drop down list
how to retreive data dynamically from mysql to drop down list   sir, i created a table in mysql and i inserted some values into the table through fron end using jsp , after storing the data successfully .i want to retrieve
extract data from excel sheet to mysql
extract data from excel sheet to mysql  sir, i want to extract data from excel sheet and save the data in mysql5.0 database in the form of table
Retriving data from MYSQL without line break using java
Retriving data from MYSQL without line break using java  get data without line breaking from mysql table (i.e data stored as mediumtext )using java
accessing ms access through jsp
accessing ms access through jsp  i have 3 tables in my database employee,project,task if i put employee id the search field .i should get details from other table what all queries should i use in servlet file and i am using
sending data to google chart api from mysql database using java
sending data to google chart api from mysql database using java  how to send data from mysql database to google chart api using java
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database... a browse button which can upload a excelfile and after uploading the data should..., Please go through the following links may this will be helpful for you. However
How to access session values through Ajax?
How to access session values through Ajax?  Suppose in a servlet a variable userName is kept in session. How can I access this variable from JSP through AJAX? Is it possible
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet.  I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields
Downloading Struts & Hibernate
. 4. A new directory will created "C:\Struts-Hibernate-Integration...;\hibernate-3.1  into C:\Struts-Hibernate-Integration\code\WEB-INF\lib...\lib" to "C:\Struts-Hibernate-Integration\code\WEB-INF\lib"
create dropdown cell in csv or excell from mysql data in php
create dropdown cell in csv or excell from mysql data in php  Hello sir i want to create drodown cell in csv from mysql data is this is possible or not? if this is posible please share answer or reference link Thanks
ACCESS DATABASE FROM HTML
ACCESS DATABASE FROM HTML  I want to access sql 2008 database in html page without help of ADODB connection.. because if access through ADODB means there is a security problem. so, Access database in html page(client side
how to store JTree data hierarchically in mysql database from netbeans
how to store JTree data hierarchically in mysql database from netbeans  how to store JTree data hierarchically in mysql database from netbeans. I am new to this topics so I need a program and tables you are using in database

Ads