[회원 가입, 로그인] Model

TaxiVO

package com.ptsd.model;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.NonNull;
import lombok.RequiredArgsConstructor;
import lombok.Setter;

@Data
@AllArgsConstructor
@NoArgsConstructor
@RequiredArgsConstructor
public class TaxiVO {
private int Taxi_seq;
   @NonNull
   private String Taxi_num;
   @NonNull
   private String Car_kinds;
   @NonNull
   private String Office_name;
   @NonNull
   private int Personal_tel;
   @NonNull
   private String Approve_check;
   @NonNull
   private String Pw;
//   
   public TaxiVO(String Taxi_num, String Pw) {
	   this.Taxi_num = Taxi_num;
	   this.Pw = Pw;
   }
}

 

TaxiDAO

package com.ptsd.model;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import com.ptsd.database.SqlSessionManager;
import com.ptsd.model.TaxiVO;

public class TaxiDAO {
   private SqlSessionFactory sqlSessionFactory = SqlSessionManager.getSqlSession();
   private SqlSession sqlSession = null;
   
   
   public int taxiinsert(TaxiVO vo) {
      int row = 0;
      try {
         sqlSession = sqlSessionFactory.openSession(true);
         row = sqlSession.insert("com.ptsd.model.TaxiDAO.taxiinsert", vo);
         System.out.println("1");
      } catch (Exception e) {
         e.printStackTrace();
      } finally {
         sqlSession.close();
      }
      return row;
   }
   
   public int taxiupdate(TaxiVO vo) {
      int row=0;
      try {
      sqlSession=sqlSessionFactory.openSession(true);
      row=sqlSession.update("com.ptsd.model.TaxiDAO.taxiupdate",vo);
      sqlSession.commit();
   }catch (Exception e) {
      e.printStackTrace();
   }finally {
      sqlSession.close();
   }
      return row;
   }
   
   public int taxidelete(String Taxi_num) {
      int row=0;
      try {
         sqlSession=sqlSessionFactory.openSession(true);
         row=sqlSession.delete("com.ptsd.model.TaxiDAO.taxidelete",Taxi_num);
      }catch (Exception e) {
         e.printStackTrace();
      }finally {
         sqlSession.close();
      }return row;
   }
   
   public TaxiVO login(TaxiVO vo) {
      TaxiVO result = null;
      try {
    	  System.out.println("1");
         sqlSession = sqlSessionFactory.openSession(true);
         System.out.println("2");
         result = sqlSession.selectOne("com.ptsd.model.TaxiDAO.memberlogin", vo);
         System.out.println(result);
         
      } catch (Exception e) {
         e.printStackTrace();
      }finally {
         sqlSession.close();
      }
      return result;
   }

}