hibernate报错 org.hibernate.exception.SQLGrammarException: could not execute statement

Question

package hibernate;

import java.util.Date;

public class Student {

      private int sid;

      private String sname;

      private String gender;

      private Date birthday;

      private String address;

      

     

      public Student(int sid,String sname,String gender,Date birthday,String address){

     this.sid=sid;

     this.sname=sname;

     this.gender=gender;

     this.birthday=birthday;

     this.address=address;

     

      }

 public Student(){

     

     

      }

public int getSid() {

return sid;

}

public void setSid(int sid) {

this.sid = sid;

}

public String getSname() {

return sname;

}

public void setSname(String sname) {

this.sname = sname;

}

public String getGender() {

return gender;

}

public void setGender(String gender) {

this.gender = gender;

}

public Date getBirthday() {

return birthday;

}

public void setBirthday(Date birthday) {

this.birthday = birthday;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

      

}

<?xml version="1.0"?>

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<!-- Generated 2017-3-18 17:32:20 by Hibernate Tools 3.5.0.Final -->

<hibernate-mapping>

    <class name="hibernate.Student" table="STUDENT">

        <id name="sid" type="int">

            <column name="SID" />

            <generator class="assigned" />

        </id>

        <property name="sname" type="java.lang.String">

            <column name="SNAME" />

        </property>

        <property name="gender" type="java.lang.String">

            <column name="GENDER" />

        </property>

        <property name="birthday" type="java.util.Date">

            <column name="BIRTHDAY" />

        </property>

        <property name="address" type="java.lang.String">

            <column name="ADDRESS" />

        </property>

    </class>

</hibernate-mapping>

package hibernate;

import java.util.Date;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.Transaction;

import org.hibernate.boot.registry.StandardServiceRegistryBuilder;

import org.hibernate.cfg.Configuration;

import org.hibernate.service.ServiceRegistry;

import org.junit.After;

import org.junit.Before;

import org.junit.Test;

public class StudentsTest {

  private SessionFactory sessionFactory;

  private Session session;

  private Transaction transaction;

@Before

public void init(){

//创建配置对象

Configuration config=new Configuration().configure();

config.addClass(Student.class);

//创建服务注册对象

ServiceRegistry serviceRegistry =new StandardServiceRegistryBuilder().applySettings(config.getProperties()).build();

//创建会话工厂对象

sessionFactory=config.buildSessionFactory(serviceRegistry);

//会话对象

session=sessionFactory.openSession();

//开启事物

transaction=session.beginTransaction();

}

@After

public void destroy(){

transaction.commit();//提交事物

session.close();//关闭会话

sessionFactory.close();//关闭会话工厂

}

@Test

public void testSaveStudent(){

Student s=new Student(2,"张三","男",new Date(),"丽水");

session.save(s);

}

}

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

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

    <property name="connection.username">root</property>

    <property name="connection.password">123456</property>

    <property name="connection.driver_name">com.mysql.jdbc.Driver</property>

    <property name="connection.url">jdbc:mysql://localhost:3306/student</property>

     <property name="dialect">org.hibernate.dialect.MySQLDialect</property> 

     

     <property name="show_sql">true</property>

     <property name="format_sql">true</property>

     <property name="hbm2dd1.auto">create</property>

    <mapping resource="Student.hbm.xml"/>

    </session-factory>

</hibernate-configuration>

Answer 1

你看一下控制台输出的sql语句是什么样的？