registerbean.java

structejbmysql开发工程源码

/*
 * Created on 2007-5-6
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package course.ejb.register;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.ejb.SessionBean;

import course.sys.Param;
import course.sys.login.ParamLogin;
import course.sys.register.ParamRegister;

/**
 * 
 * <!-- begin-user-doc --> A generated session bean <!-- end-user-doc --> * <!--
 * lomboz.beginDefinition --> <?xml version="1.0" encoding="UTF-8"?> <lomboz:EJB
 * xmlns:j2ee="http://java.sun.com/xml/ns/j2ee"
 * xmlns:lomboz="http://lomboz.objectlearn.com/xml/lomboz"> <lomboz:session>
 * <lomboz:sessionEjb><j2ee:display-name>Register </j2ee:display-name>
 * <j2ee:ejb-name>Register </j2ee:ejb-name>
 * <j2ee:ejb-class>course.ejb.register.RegisterBean </j2ee:ejb-class>
 * <j2ee:session-type>Stateless </j2ee:session-type>
 * <j2ee:transaction-type>Container </j2ee:transaction-type>
 * </lomboz:sessionEjb> </lomboz:session> </lomboz:EJB> <!--
 * lomboz.endDefinition -->
 * 
 * <!-- begin-xdoclet-definition -->
 * 
 * @ejb.bean name="Register" jndi-name="Register" type="Stateless"
 *           transaction-type="Container" -- This is needed for JOnAS. If you
 *           are not using JOnAS you can safely remove the tags below.
 * @jonas.bean ejb-name="Register" jndi-name="Register" -- <!--
 *             end-xdoclet-definition -->
 * @generated
 */
public abstract class RegisterBean implements javax.ejb.SessionBean {

    /**
     * @ejb.interface-method view-type="remote"
     */
    public void InsertCustomer_info(String userName, String userNiName,
            String userPsw, String userPswQus, String userPswAns,
            String userEmail) {

        try {
            Class.forName(Param.JDBCDriver).newInstance();
            Connection conn = DriverManager.getConnection(Param.JDBCUrl);
            PreparedStatement pstmt = conn
                    .prepareStatement(ParamRegister.SQLInsertCustomer_info);
            pstmt.setString(1, userName);
            pstmt.setString(2, userNiName);
            pstmt.setString(3, userPsw);
            pstmt.setString(4, userPswQus);
            pstmt.setString(5, userPswAns);
            pstmt.setString(6, userEmail);
            String cashCanUsed = Integer.toString(Param.MoneyOfReg);
            pstmt.setString(7, cashCanUsed);
            String sumOfWth = Integer.toString(Param.MoneyOfReg);
            pstmt.setString(8, sumOfWth);
            String numOfDone = "0";
            pstmt.setString(9, numOfDone);
            String incOfDay = "0";
            pstmt.setString(10, incOfDay);
            String incOfWeek = "0";
            pstmt.setString(11, incOfWeek);
            String inc = "0";
            pstmt.setString(12, inc);
            SimpleDateFormat sf = new SimpleDateFormat("yyyyMMdd");
            String today = sf.format(new Date());
            String dayOfReg=today;
            pstmt.setString(13, dayOfReg);
            pstmt.executeUpdate();
            pstmt.close();
            conn.close();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * @ejb.interface-method view-type="remote"
     */
    public String getUserName(String userName) {
        String name = null;
        try {
            Class.forName(Param.JDBCDriver).newInstance();
            Connection conn = DriverManager.getConnection(Param.JDBCUrl);
            PreparedStatement pstmt = conn
                    .prepareStatement(ParamRegister.SQLGetUserName);
            pstmt.setString(1, userName);
            ResultSet rs = pstmt.executeQuery();
            if (rs.next()) {
                name = rs.getString("userName");
            }
            rs.close();
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return name;
    }
}