package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import model.CV;

public class GetCV {
	
	public boolean flag = false;
	
	public CV getCV(String userid) {
		CV cv = new CV();
		
		String url = "jdbc:oracle:thin:@localhost:1521:orcl";
		String u = "scott";
		String p = "tiger";
		Connection conn = null;
		PreparedStatement st = null;
		ResultSet rs = null;
		String sql="select * from cvs where userid="+"'"+userid+"'";
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
			conn = DriverManager.getConnection(url,u,p);
			st = conn.prepareStatement(sql);
			rs = st.executeQuery();
			
			if(rs.next()) {
				flag=true;
				String cname,sex,age,school,major,xueli,eng,clanguage,advan,hob,exp;
				cname = rs.getString("cname");
				sex = rs.getString("sex");
				age = rs.getString("age");
				school = rs.getString("school");
				major = rs.getString("major");
				xueli = rs.getString("xueli");
				eng = rs.getString("eng");
				clanguage = rs.getString("clanguage");
				advan = rs.getString("advan");
				hob = rs.getString("hob");
				exp = rs.getString("exp");
				
				cv.setUserid(userid);
				cv.setCname(cname);
				cv.setSex(sex);
				cv.setAge(age);
				cv.setSchool(school);
				cv.setMajor(major);
				cv.setXueli(xueli);
				cv.setEng(eng);
				cv.setClanguage(clanguage);
				cv.setAdvan(advan);
				cv.setHob(hob);
				cv.setExp(exp);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally {
			if(conn!=null){
				try {
					rs.close();
				} catch (SQLException e1) {
					
				}
				try {
					
					st.close();
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
		return cv;
	}
}