Java tutorial
/* * Copyright 2008-2009 MOPAS(Ministry of Public Administration and Security). * * Licensed 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. */ package egovframework.rte.fdl.security.userdetails.jdbc; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import javax.sql.DataSource; import org.springframework.jdbc.core.SqlParameter; import org.springframework.jdbc.object.MappingSqlQuery; /** * ? DB? ?? ? * <p> * <b>NOTE:</b> * org.springframework.jdbc.object.MappingSqlQuery * ? DB? ?? ??. * @author * @since 2009.06.01 * @version 1.0 * @see <pre> * == ?(Modification Information) == * * ? ? * ------- -------- --------------------------- * 2009.06.01 ? * * </pre> */ public abstract class EgovUsersByUsernameMapping extends MappingSqlQuery { /** * ? ?? ??? . * @param ds * @param usersByUsernameQuery */ public EgovUsersByUsernameMapping(DataSource ds, String usersByUsernameQuery) { super(ds, usersByUsernameQuery); declareParameter(new SqlParameter(Types.VARCHAR)); compile(); } /* * (non-Javadoc) * @see * org.springframework.jdbc.object.MappingSqlQuery * #mapRow(java.sql.ResultSet, int) */ /** * mapRow ?? jdbc-user-service ? ? * users-by-username-query ? ? ResultSet? * ?. ) protected Object mapRow(ResultSet * rs, int rownum) throws SQLException; { String * userid = rs.getString(0); String password = * rs.getString(1); boolean enabled = * rs.getBoolean(2); EgovUserVO userVO = new * EgovUserVO(); userVO.setUserId(userid); * userVO.setPassWord(password); return new * EgovUser(userid, password, enabled, userVO); } */ @Override protected abstract Object mapRow(ResultSet rs, int rownum) throws SQLException; }