package dao;

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

import model.CV;
import model.User;

public class AddCV {
	public void addCV(User user,CV cv) {

		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String url = "jdbc:oracle:thin:@localhost:1521:orcl";
		String n = "scott";
		String p = "tiger";
		Connection conn = null;
		PreparedStatement st = null;

		String sql = "insert into cvs(userid,cname,sex,age,school,major,xueli,eng,clanguage,advan,hob,exp) values(?,?,?,?,?,?,?,?,?,?,?,?)";

		try {
			conn = DriverManager.getConnection(url, n, p);
			conn.setAutoCommit(false);
			st = conn.prepareStatement(sql);
			st.setString(1, user.getUserid());
			st.setString(2, cv.getCname());
			st.setString(3,cv.getSex());
			st.setString(4,cv.getAge());
			st.setString(5,cv.getSchool());
			st.setString(6,cv.getMajor());
			st.setString(7,cv.getXueli());
			st.setString(8,cv.getEng());
			st.setString(9,cv.getClanguage());
			st.setString(10,cv.getAdvan());
			st.setString(11,cv.getHob());
			st.setString(12,cv.getExp());
			
			st.executeUpdate();
			conn.commit();

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					st.close();
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}

			}
		}
	}

}