| /* |
| * Licensed to the Apache Software Foundation (ASF) under one or more |
| * contributor license agreements. See the NOTICE file distributed with |
| * this work for additional information regarding copyright ownership. |
| * The ASF licenses this file to You under the Apache License, Version 2.0 |
| * (the "License"); you may not use this file except in compliance with |
| * the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, software |
| * distributed under the License is distributed on an "AS IS" BASIS, |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| * See the License for the specific language governing permissions and |
| * limitations under the License. |
| */ |
| // Step 1 -- Retrieve helper "beans" from the BSF framework |
| |
| scriptaction = bsf.lookupBean( "scriptaction" ) |
| manager = bsf.lookupBean( "manager" ) |
| request = bsf.lookupBean( "request" ) |
| logger = bsf.lookupBean( "logger" ) |
| actionMap = bsf.lookupBean( "actionMap" ) |
| |
| // Step 2 -- Perform the action |
| |
| logger.debug( "START createuser.js" ) |
| |
| // Retrieve things from the session and request |
| // NOTE: they are all of type java.lang.String |
| |
| session = request.getSession( false ) |
| uwid = session.getAttribute( "uwid" ) |
| |
| logger.debug( "Raw" ) |
| logger.debug( " uwid [" + uwid + "]" ) |
| |
| // We have the choice of declaring things out here and making them explicitly |
| // null, or we have to use a different comparison in the "finally" block (defined?) |
| |
| dbselector = null |
| datasource = null |
| conn = null |
| queryStatement = null |
| insertStatement = null |
| |
| try |
| { |
| dbselector = manager.lookup( scriptaction.DB_CONNECTION ) |
| datasource = dbselector.select( "ceabplanner" ) |
| conn = datasource.getConnection() |
| |
| // Check that the student exists |
| |
| queryStatement = conn.prepareStatement( |
| "select count(*) here from students where uw_userid=? " |
| ) |
| |
| queryStatement.setString( 1, uwid ) |
| |
| resultSet = queryStatement.executeQuery() |
| resultSet.next() |
| |
| userExists = resultSet.getInt("here") |
| |
| logger.debug( "Result #1 [" + userExists + "]" ) |
| |
| if (!userExists) |
| { |
| |
| logger.debug( "User does not exist...creating and initializing" ) |
| |
| insertStatement = conn.prepareStatement( |
| "INSERT INTO students (id, uw_userid, name, uw_id, current_term) values (students_seq.nextval, ?, '','', (SELECT id FROM terms WHERE description = '1A'))" |
| ) |
| |
| insertStatement.setString( 1, uwid ); |
| |
| result = insertStatement.executeUpdate() |
| logger.debug( "Result #2 [" + result + "]" ) |
| |
| insertStatement = conn.prepareStatement( |
| "insert into studentNotes (student,note) values ( ( SELECT id FROM students WHERE uw_userid = ? ),'')" |
| ) |
| |
| insertStatement.setString( 1, uwid ); |
| |
| result = insertStatement.executeUpdate() |
| logger.debug( "Result #3 [" + result + "]" ) |
| |
| insertStatement = conn.prepareStatement( |
| "INSERT INTO studentKnownCourseList (student, known_course, term_taken, distance_ed, course_extra) ( SELECT ( SELECT id FROM students WHERE uw_userid = ? ), course, term, '1', '1' FROM corecourses )" |
| ) |
| |
| insertStatement.setString( 1, uwid ); |
| |
| result = insertStatement.executeUpdate() |
| logger.debug( "Result #4 [" + result + "]" ) |
| |
| conn.commit() |
| } |
| else |
| { |
| logger.debug( "User exists" ) |
| } |
| actionMap.put( "scriptaction-continue", "" ) |
| } |
| catch( ex ) |
| { |
| logger.debug( "Caught Exception" ) |
| logger.debug( " " + ex ) |
| } |
| finally |
| { |
| if ( null != queryStatement ) { queryStatement.close() } |
| if ( null != insertStatement ) { insertStatement.close() } |
| if ( null != conn ) { conn.close() } |
| if ( null != datasource ) { dbselector.release( datasource ) } |
| if ( null != dbselector ) { manager.release( dbselector ) } |
| } |
| |
| logger.debug( "END createuser.js" ) |