/*
 * userBean.java
 *
 * Created on 2007年12月8日, 上午9:50
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.classmoney.sbean;

import com.classmoney.entity.Userinfo;
import com.classmoney.userRemote;
import java.util.List;
import javax.ejb.Remote;
import javax.ejb.Stateless;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;

/**
 *
 * @author Administrator
 */
@Stateless
@Remote (userRemote.class)
public class userBean implements com.classmoney.userRemote {
   @PersistenceContext
    
    protected EntityManager em;
    /** Creates a new instance of userBean */
    public userBean() {
    }
     public String getpwdbyusername(String username) {
        Userinfo user=em.find(Userinfo.class,username);
        return user.getUserpass();
    }
       public short getuserlvbyusername(String username)
        {
        Userinfo user=em.find(Userinfo.class,username);
        return user.getUserlv();
    }
     public boolean insertUser(String Username, String Userpass,String Student,short Userlv) {
        try
        {
            Userinfo userinfo=new Userinfo();
            userinfo.setUsername(Username);
            userinfo.setUserpass(Userpass);
            userinfo.setStudent(Student);
            userinfo.setUserlv(Short.valueOf(Userlv));
            
            em.persist(userinfo);
            
            
        }
        catch (Exception e)
        {
            e.printStackTrace();
            return false;
        }
        return true;
    }

    public List getuserList() {
        Query query = em.createQuery("from userinfo order by username asc");
        List list = query.getResultList();
        return list;
    }

   
    
}