GenerationType.IDENTITY

@Entity
@Table(name="Users")
public class UserInfo
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="id")
    private int id;

    @Column(name="firstName")
    private String firstName;

    @Column(name="lastName")
    private String lastName;

    @Column(name="login")
    private String login;

    @Column(name="userPassword")
    private String Password;
......
}

create table Users (id int(10) auto_increment,  firstName varchar(20),  lastName varchar(20), login varchar(15), userPassword varchar(15), primary key (id));

            session = HibernateUtil.getSessionFactory().openSession();
            Query query = session.createQuery("from Users where login = : login");
            query.setParameter("login", login);
            users = (List<UserInfo>)query.list();
            user = users.get(0);

@Entity
@Table(name="writer")
public class WriterInfo
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="id")
    private int id;

    @Column(name="firstName")
    private String firstName;

    @Column(name="lastName")
    private String lastName;

    @Column(name="fullName")
    private String fullName;

    @Column(name="info")
    private String info;
...
}

    public List<WriterInfo> getWriters(String firstName, String lastName, String fullName) throws SQLException
    {
        Session session = null;
        List<WriterInfo> writers = null;

        try {
            session = HibernateUtil.getSessionFactory().openSession();

            Logger.getLogger().write(firstName+lastName+fullName);

            WriterInfo writer = new WriterInfo();

            if (fullName != null && fullName.length() > 0)
                writer.setFullName(fullName);

            if (firstName != null && firstName.length() > 0)
                writer.setFirstName(firstName);

            if (lastName != null && lastName.length() > 0)
                writer.setLastName(lastName);

            Example example = Example.create(writer).enableLike().excludeProperty();


            writers = session.createCriteria(WriterInfo.class).add(example).list();

            Logger.getLogger().write(writers.size()+"");

        } catch (Exception e) {
            Logger.getLogger().write("5555");


        } finally {
            if (session != null && session.isOpen()) {
                session.close();
            }
        }
        return writers;
    }

    public List<WriterInfo> getWriters(String firstName, String lastName, String fullName) throws SQLException
    {
        Session session = null;
        List<WriterInfo> writers = null;

        try {
            session = HibernateUtil.getSessionFactory().openSession();

            WriterInfo writer = new WriterInfo();

            if (fullName != null && fullName.length() > 0)
                writer.setFullName(fullName);

            if (firstName != null && firstName.length() > 0)
                writer.setFirstName(firstName);

            if (lastName != null && lastName.length() > 0)
                writer.setLastName(lastName);

            writers = session.createSQLQuery("select * from WriterInfo").setParameter("firstName", writer.getFirstName()).
                    setParameter("lastName", writer.getLastName()).setParameter("fullName", writer.getFullName()).list();

            Logger.getLogger().write(writers.size()+"");

        } catch (Exception e) {
            Logger.getLogger().write("5555");


        } finally {
            if (session != null && session.isOpen()) {
                session.close();
            }
        }
        return writers;
    }

            writers = session.createQuery("from WriterInfo where firstName Like :firstName and lastName like :lastName and fullName like :fullName").
                    setParameter("firstName", writer.getFirstName()).setParameter("lastName", writer.getLastName()).setParameter("fullName", writer.getFullName()).list();