基于J2EE的网上在线听音乐

import java.sql.*; import javax.sql.*; import java.util.*; import javax.ejb.*; import javax.naming.*; import java.rmi.*; public class RegisterEjb implements EntityBean { private String requestId; private String userName; private String firstName; private String middleName; private String lastName; private String dateOfBirth; private String email; private String addressLine1; private String addressLine2; private String city; private String state; private String creditCard; private String creditCardType; private String password; private String secretQuestion; private String secretAnswer; Connection con; int id=0; public RegisterEjb(){} public void setRequestId(String req) { requestId=req; } public void setUserName(String user) { userName=user; } public void setFirstName(String first) { firstName=first; } public void setMiddleName(String middle) { middleName=middle; } public void setLastName(String last) { lastName=last; } public void setDateOfBirth(String date) { dateOfBirth=date; } public void setEmail(String em) { email=em; } public void setAddressLine1(String address1) { addressLine1=address1; } public void setAddressLine2(String address2) { addressLine2=address2; } public void setCity(String cit) { city= cit; } public void setState(String sta) { state= sta; } public void setCreditCard(String credit) { creditCard=credit; } public void setCreditCardType(String creditType) { creditCardType=creditType; } public void setPassword(String pass) { password=pass; } public void setSecretQuestion(String secretQ) { secretQuestion=secretQ; } public void setSecretAnswer(String secretA) { secretAnswer=secretA; } public String getRequestId() { return requestId; } public String getUserName() { return userName; } public String getFirstName() { return firstName; } public String getMiddleName() { return middleName; } public String getLastName() { return lastName; } public String getDateOfBirth() { return dateOfBirth; } public String getEmail() { return email; } public String getAddressLine1() { return addressLine1; } public String getAddressLine2() { return addressLine2; } public String getCity() { return city; } public String getState() { return state; } public String getCreditCard() { return creditCard; } public String getCreditCardType() { return creditCardType; } public String ejbFindByPrimaryKey(String id) throws FinderException{ return new String(new Integer(id).toString()); } public String ejbCreate(String userName,String firstName,String middleName,String lastName, String dateOfBirth,String email,String addressLine1,String addressLine2,String city, String state,String creditCard,String creditCardType,String password,String secretQuestion,String secretAnswer)throws CreateException { try{ getConnection(); Statement st= con.createStatement(); System.out.println("Afterget1"+st); ResultSet rst=st.executeQuery("Select max(request_id) from User_Info"); while(rst.next()){ id=rst.getInt(1); } System.out.println("Inside setEntityContext"); }catch(Exception e){ System.out.println("In setEntityContext() :"+e); } this.userName=userName; this.firstName=firstName; this.middleName=middleName; this.lastName=lastName; this.dateOfBirth=dateOfBirth; this.email=email; this.addressLine1=addressLine1; this.addressLine2=addressLine2; this.city= city; this.state= state; this.creditCard=creditCard; this.creditCardType=creditCardType; this.password=password; this.secretQuestion=secretQuestion; this.secretAnswer=secretAnswer; try { insertDetails(userName, firstName, middleName,lastName, dateOfBirth, email, addressLine1,addressLine2,city,state, creditCard,creditCardType,password,secretQuestion, secretAnswer); } catch(Exception ex) { System.out.println("Exception in inserting details in database"+ex); } try { closeConnection(); } catch(Exception ex) { System.out.println("Exception in closing Connection"+ex); } return (new Integer(id).toString()); } private void getConnection() throws NamingException,SQLException { InitialContext inc=new InitialContext(); DataSource datsrc=(DataSource)inc.lookup("java:comp/env/jdbc/RegisterDataSource"); con=datsrc.getConnection(); } private void insertDetails(String userName,String firstName,String middleName,String lastName,String dateOfBirth,String email, String addressLine1,String addressLine2,String city,String state,String creditCard,String creditCardType,String password, String secretQuestion,String secretAnswer)throws SQLException { try { Statement st= con.createStatement(); ResultSet rst=st.executeQuery("Select max(request_id) from User_Info"); while(rst.next()){ id=rst.getInt(1); } }catch(Exception e){ System.out.println("Exception in Activate"+e); } id++; String role="user"; String insert1="Insert into User_Info values(?,?,?,?,?,?,?,?,?,?,?,?,?)"; String insert2="Insert into Login_Info values (?,?,?,?,?)"; PreparedStatement stat1=con.prepareStatement(insert1); PreparedStatement stat2=con.prepareStatement(insert2); stat1.setInt(1,id); stat1.setString(2,userName); stat1.setString(3,firstName); stat1.setString(4,middleName); stat1.setString(5,lastName); stat1.setString(6,dateOfBirth); stat1.setString(7,email); stat1.setString(8,addressLine1); stat1.setString(9,addressLine2); stat1.setString(10,city); stat1.setString(11,state); stat1.setString(12,creditCard); stat1.setString(13,creditCardType); stat2.setString(1,userName); stat2.setString(2,password); stat2.setString(3,secretQuestion); stat2.setString(4,secretAnswer); stat2.setString(5,role); stat1.executeUpdate(); stat1.close(); stat2.executeUpdate(); stat2.close(); } private void closeConnection() throws SQLException { con.close(); } public String ejbPostCreate(String userName,String firstName,String middleName,String lastName, String dateOfBirth,String email,String addressLine1,String addressLine2,String city, String state,String creditCard,String creditCardType,String password,String secretQuestion,String secretAnswerr){return new Integer(id).toString();} public void ejbActivate(){ try{ getConnection(); Statement st= con.createStatement(); ResultSet rst=st.executeQuery("Select max(request_id) from User_Info"); while(rst.next()){ id=rst.getInt(1); } }catch(Exception e){ System.out.println("In Activate() :"+e); } } public void ejbLoad(){} public void ejbPassivate(){ try{ closeConnection(); }catch(Exception e){ System.out.println("In setEntityContext() :"+e); } } public void ejbRemove(){} public void ejbStore(){} public void setEntityContext(EntityContext ctx){ try{ getConnection(); } catch(Exception e){ System.out.println("In Activate() :"+e); } } public void unsetEntityContext(){ try{ closeConnection(); }catch(SQLException e){ } } }