我是Hibernate的新手,我正在尝试对我创建的oracle数据库进行“简单”用户插入.
我使用Netbeans Hibernate向导创建了所有必需的文件:
hibernate.cfg.xml,hibernate,reveng.xml,Users.hbm.xml,Users.java
如果我使用oracle sql developer插入用户,我可以从java代码中获取此用户.但是,如果我试图插入用户,我会收到错误:不一致的数据类型:预期NUMBER得到了BINARY.
部分Users.hbm.xml:
...
部分Users.java:
public class Users implements java.io.Serializable
{
private int userid;
private String username;
private String password;
private String firstName;
private String lastName;
private Serializable dateOfBirth;
private Serializable registrationDate;
...
部分insertUser方法(所有参数都是字符串):
session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
Calendar dOfBirth = Calendar.getInstance();
dOfBirth.set(Integer.parseInt(year_of_birth), Integer.parseInt(month_of_birth), Integer.parseInt(day_of_birth));
Calendar regDate = Calendar.getInstance();
Timestamp dOfBirthTS = new Timestamp(dOfBirth.getTimeInMillis());
Timestamp regDateTS = new Timestamp(regDate.getTimeInMillis());
Users user = new Users();
user.setUsername(username);
user.setPassword(password);
user.setFirstName(first_name);
user.setLastName(last_name);
user.setDateOfBirth(dOfBirthTS);
user.setRegistrationDate(regDateTS);
session.saveOrUpdate(user);
ans = user.getUserid();
tx.commit();
数据库中的用户表:
USERID NUMBER(9,0) - the primary key
USERNAME VARCHAR(200)
PASSWORD VARCHAR(200)
FIRST_NAME VARCAHR(200)
LAST_NAME VARCHAR(200)
DATE_OF_BIRTH TIMESTAMP
REGISTRATION_DATE TIMESTAMP