package model;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;

import vo.UserinfoVO;

public class Database {

	private Connection conn;
	static  Conn conn1;
	private CallableStatement cs = null;
	
	public Database() throws ClassNotFoundException, SQLException {
		conn1 =new Conn();
		//conn=new Connection();
		 conn1.getConnection();
	}
	
	
	public int login(UserinfoVO uvo) throws SQLException{
		int flag = 0;
		String sql = "begin ?:=useroption.login(?,?); end;";
		cs = conn.prepareCall(sql);
		cs.registerOutParameter(1,java.sql.Types.INTEGER);
		cs.setString(2, uvo.getUsername());
		cs.setString(3,uvo.getPassword());
		cs.execute();
		flag = cs.getInt(1);
		conn1.close(null, null, cs, null, conn);
		return flag;
	}
	
	public void regist(UserinfoVO uvo) throws SQLException{
		String sql = "begin useroption.regist(?,?); end;";
		
		cs = conn.prepareCall(sql);
		cs.setString(1,uvo.getUsername());
		cs.setString(2,uvo.getPassword());
		System.out.println(uvo.getUsername());
		cs.execute();
		conn1.close(null, null, cs, null, conn);
	}

}