package karan1;
import java.sql.*;
import java.util.Scanner;
import java.util.Vector;

public class Update {
	int clg_code,contact_no,mark;
	String name,semester;
	private void update(int usn,Integer clgCode, Integer contact,String Sname,String sem,Integer marks )
	{

		try{
			Connection con=Jdbc1.getConn();
			String selectSql="Select * from student where usn=?";
			PreparedStatement stat1=con.prepareStatement(selectSql);
			stat1.setInt(1,usn);
			ResultSet result=stat1.executeQuery();
			String sql="Update student set CLG_CODE=?,CNTCT_NO=?,SNAME=?,SEM=?,MARKS=? where USN=? ";


			PreparedStatement stat=con.prepareStatement(sql);

			while(result.next())
			{
			clg_code=result.getInt(2);
			contact_no=result.getInt(3);
			name=result.getString(4);
			semester=result.getString(5);
			mark=result.getInt(6);
			}

				if(clgCode!=null)
					stat.setInt(1,clgCode);
				else
					stat.setInt(1,clg_code);
				if(contact!=null)
					stat.setInt(2,contact);
				else
					stat.setInt(2,contact_no);
				if(Sname == null)
					stat.setString(3,name);

				else
					stat.setString(3,Sname);


				if(sem!=null)
					stat.setString(4,sem);
				else
					stat.setString(4,semester);
				if(marks!=null)
					stat.setInt(5,marks);
				else
					stat.setInt(5,marks);

					stat.setInt(6,usn);
			int res=stat.executeUpdate();
			if(res>0)
				System.out.println("Done");
			else
				System.out.println("Problem");
		}
		catch(SQLException e)
		{
			e.printStackTrace();

		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Vector<Object> values=new Vector<Object>();
		Update update=new Update();
		update.update(54,900,null,null,null,100);

	}


}