
//hibernate cfg file//
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="connection.username">root</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/student
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="myeclipse.connection.profile">local</property>
<property name="hbm2ddl.auto">update</property>
<property name="connection.password">root</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="show_sql">true</property>
<mapping resource="org/savinirs/pojos/Studentreg.hbm.xml" />
</session-factory>
</hibernate-configuration>
// StudentBeans file//
package org.savinirs.beans;
import org.apache.struts.action.ActionForm;
public class StudentBeans extends ActionForm {
public String fname;
public String lname;
public String email;
public String reg;
public String add;
public String gender;
public String course;
public Integer stdid;
public Integer age;
public String getFname() {
return fname;
}
public void setFname(String fname) {
this.fname = fname;
}
public String getLname() {
return lname;
}
public void setLname(String lname) {
this.lname = lname;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getReg() {
return reg;
}
public void setReg(String reg) {
this.reg = reg;
}
public String getAdd() {
return add;
}
public void setAdd(String add) {
this.add = add;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getCourse() {
return course;
}
public void setCourse(String course) {
this.course = course;
}
public Integer getStdid() {
return stdid;
}
public void setStdid(Integer stdid) {
this.stdid = stdid;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
//Action file//
package org.savinirs.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.MappingDispatchAction;
import org.hibernate.Hibernate;
import org.savinirs.beans.StudentBeans;
import org.savinirs.pojos.Studentreg;
import org.savinirs.util.HibernateSessionFactory;
public class LoginAction extends MappingDispatchAction{
public ActionForward studentmethod(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
{
org.hibernate.Session hiberobj=null;
try {
System.out.println("hi......");
hiberobj=HibernateSessionFactory.getSessionFactory().openSession();
hiberobj.beginTransaction();
System.out.println("insertion begin");
StudentBeans obj=(StudentBeans) form;
Studentreg pojoobj=new Studentreg();
pojoobj.setFname(obj.getFname());
pojoobj.setLname(obj.getLname());
pojoobj.setEmail(obj.getEmail());
pojoobj.setReg(obj.getReg());
pojoobj.setAdd(obj.getAdd());
pojoobj.setGender(obj.getGender());
pojoobj.setCourse(obj.getCourse());
pojoobj.setAge(obj.getAge());
hiberobj.save(pojoobj);
hiberobj.getTransaction().commit();
System.out.println("Done");
hiberobj.close();
return mapping.findForward("sucess");
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("msg1","give proper details");
return mapping.findForward("failure");
// TODO: handle exception
}
}
}
//struts cnfg file//
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
<form-beans >
<form-bean name="StudentBeans" type="org.savinirs.beans.StudentBeans"/>
</form-beans>
<global-exceptions />
<global-forwards />
<action-mappings >
<action name="StudentBeans" path="/studentmethod" parameter="studentmethod" type="org.savinirs.action.LoginAction" scope="request">
<forward name="sucess" path="/sucess.jsp"/>
<forward name="failure" path="/StudentPage.jsp"/>
</action>
</action-mappings>
<message-resources parameter="org.savinirs.struts.ApplicationResources" />
</struts-config>
//student registration page//
<body>
<form name="regForm" action="studentmethod.do" >
<h3> STUDENT REGISTRATION</h3>
<table align=center>
<tr>
<td>FIRST NAME
<input type="text" name="fname" id="fname" value="">
</td>
</tr>
<tr>
<td>LAST NAME
<input type="text" name="lname" id="lname" value="">
</td>
</tr>
<tr>
<td>EMAIL
<input type="text" name="email" id="email" value="">
</td>
</tr>
<tr>
<td>STUDENT ID
<input type="text" name="studid" id="studid" value="">
</td>
</tr>
<tr>
<td>REGISTRATION NO:
<select id="reg" name="reg"><option></option>
<option value="10yasca001">10yasca001</option><option value="10yasca002">10yasca002</option><option value="10yasca003">10yasca003</option><option value="10yasca004">10yasca004</option>
</select>
</td>
</tr>
<tr>
<td>AGE
<input type="text" name="age" id="age" value="">
</td>
</tr>
<tr>
<td>ADDRESS
<textarea rows="2" cols="20" name="add" id="add"></textarea>
</td>
</tr>
<tr>
<td>GENDER
<input type="radio" name="gender" id="gender" value="male" >Male
<input type="radio" name="gender" id="gender" value="female">Female
</td>
</tr>
<tr>
<td>COURSE
<input type="checkbox" name="course" id="course" value="UG">UG
<input type="checkbox" name="course" id="course" value="PG">PG
</td>
</tr>
<tr>
<td colspan="2">${requestScope.msg1 }</td>
</tr>
<tr>
<td align=center>
<input type="submit" value="SUMBIT" />
</td>
</tr>
</table>
</form>
</body>
//student database//
studentreg
coloumns
fname,char(40),Nullable
lname,char(40),Nullable
email,varchar(40),Nullable
reg,varchar(20),Nullable
add,varchar(30),Nullable
gender,char(5),Nullable
course,char(5),Nullable
stdid,int(11)
age,int(2),Nullable
stdid primary key with auto generate..
while trying to save data in database im getting error:
insertion begin
Hibernate: insert into student.studentreg (fname, lname, email, reg, add, gender, course, age) values (?, ?, ?, ?, ?, ?, ?, ?)
org.hibernate.exception.SQLGrammarException: could not insert: [org.savinirs.pojos.Studentreg]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
");
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.