package com.example.javaqui;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class studentslist
{
	String datasource;
	ArrayList<student> students;
	BufferedReader reader;
	int choice;
	int filereadtoken;
	//1 is for file,2 is for serialized data,3 is for database
	//for database only
	private Connection con=null;
	private Statement st=null;
	ResultSet rs=null;
	String query=null;
	String constring="jdbc:mysql://localhost/test?user=root&password=";

	public studentslist()
	{
		datasource="Not Choosen";
		filereadtoken=0;
		reader=new BufferedReader(new InputStreamReader(System.in));
		showmenu();
	}
	public void showmenu()
	{
		while(true){
		clearscreen();
		System.out.println("Data Source Choosen : "+ datasource);
		System.out.println("1. Choose plain text as data source");
		System.out.println("2. Choose serialized text as data source");
		System.out.println("3. Choose db as data source");
		System.out.println("4. Add Student");
		System.out.println("5. List Students");
		System.out.println("Enter your choice [1,2,3,4,5]");
		try
		{
			choice=Integer.parseInt(reader.readLine());
			switch(choice)
			{
				case 1:
				{
					datasource="PlainText";
					filereadtoken=1;
					break;
				}
				case 2:
				{
					datasource="Serialization";
					filereadtoken=2;
					if(deserializedata()==null)
						students=new ArrayList<student>();
					else
						students=deserializedata();
					break;
				}
				case 3:
				{
					datasource="Database";
					filereadtoken=3;
					break;
				}
				case 4:
				{
					if(checkdatasource())
						getstudentdetails();
					break;
				}
				case 5:
				{
					if(checkdatasource())
					{
						if(filereadtoken==1)
							readfromfile();
						else if(filereadtoken==2)
							printstudentdetails();
						else if(filereadtoken==3)
							printstudentsdb();
					}
					break;
				}
				default:
				{
					System.out.println("Invalid Choice");
					break;
				}
			}
		}
		catch (IOException e)
		{
			e.printStackTrace();
		}
		}
	}
	public ArrayList<student> deserializedata()
	{
		FileInputStream fileIn=null;
		ObjectInputStream inStream=null;
		try
		{
			fileIn=new FileInputStream("data");
			inStream=new ObjectInputStream(fileIn);
			students=(ArrayList<student>) inStream.readObject();
			return students;
		}
		catch(IOException e)
		{
			//e.printStackTrace();
			System.out.println(e.getMessage());
			return null;
		}
		catch(ClassNotFoundException c)
		{c.printStackTrace();return null;}
		finally
		{

			try
			{
				fileIn.close();
				inStream.close();
			}
			catch(Exception e)
			{
				return null;
			}
		}
	}
	public void serializedata()
	{
		FileOutputStream fileOut=null;
		ObjectOutputStream outStream=null;
		try
		{
			fileOut=new FileOutputStream("data");
			outStream=new ObjectOutputStream(fileOut);
			outStream.writeObject(students);
		}
		catch(IOException e)
		{
			e.printStackTrace();
		}
		finally
		{
			try {
				fileOut.close();
				outStream.close();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}
	}
	public void readfromfile()
	{
		File file;
		FileReader fileReader=null;
		BufferedReader bufferedReader=null;
		try
		{
			file=new File("file.txt");
			fileReader=new FileReader(file);
			bufferedReader=new BufferedReader(fileReader);
			String line;
			while((line=bufferedReader.readLine())!=null)
			{
				System.out.println(line);
			}
			String dummy=reader.readLine();
		}
		catch(IOException e)
		{e.printStackTrace();}
		finally
		{
			try{
				if(fileReader!=null)
					fileReader.close();
				if(bufferedReader!=null)
					bufferedReader.close();
			}catch(IOException e){;}
		}
	}
	public void writetofile(ArrayList<String> data)
	{
		String student=data.get(0)+","+data.get(1)+","+data.get(2)+","+data.get(3);
		try
		{
			File file=new File("file.txt");
			FileWriter filewriter=new FileWriter(file.getName(),true);
			//BufferedWriter bufferedwriter=new BufferedWriter(filewriter);
			filewriter.write("\n");
			filewriter.write(student);
			filewriter.close();
		}
		catch(IOException e)
		{
			e.printStackTrace();
		}
	}
	public Boolean checkdatasource()
	{
		if(filereadtoken==0)
		{
			System.out.println("Please choose data source to proceed !");
			try
			{
				String dummy=reader.readLine();
			}
			catch(IOException e)
			{e.printStackTrace();}
			return false;
		}
		else
			return true;
	}
	public void clearscreen()
	{
		for(int clear=0;clear<1000;clear++)
		{
			System.out.println("");
		}
	}
	public void getstudentdetails()
	{
		try{
		clearscreen();
		System.out.println("Enter Student Number");
		String sno=reader.readLine();
		System.out.println("Enter Student Name");
		String sname=reader.readLine();
		System.out.println("Enter Subject Code");
		String sbcode=reader.readLine();
		System.out.println("Enter Subject Name");
		String sbname=reader.readLine();
		if(filereadtoken==1)
		{
			ArrayList<String> data=new ArrayList<String>();
			data.add(sno);
			data.add(sname);
			data.add(sbcode);
			data.add(sbname);
			writetofile(data);
		}
		else if(filereadtoken==2)
		{
			student s=new student(sno,sname,sbcode,sbname);
			students.add(s);
			serializedata();

		}
		else if(filereadtoken==3)
		{
			student s=new student(sno,sname,sbcode,sbname);
			writetodb(s);

		}
		else
			System.out.println("Data source not choosen");
		}
		catch(IOException e)
		{
			System.out.println(e.getMessage());
		}
	}
	public void printstudentdetails()
	{
		clearscreen();
		for(student s:students)
		{
			System.out.println(s.snumber);
			System.out.println(s.sname);
			System.out.println(s.sbcode);
			System.out.println(s.sbname);
		}
		try
		{
			reader.readLine();
		}
		catch(IOException e)
		{
			e.printStackTrace();
		}
	}
	public void makecon()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection(constring);
			//st=con.createStatement();
		}
		catch (Exception e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}
	public Boolean writetodb(student s)
	{
		try
		{
			makecon();
			query="insert into students(studentno,studentname,subjectcode,subjectname) values(?,?,?,?)";
			PreparedStatement ps=con.prepareStatement(query);
			ps.setString(1,s.snumber);
			ps.setString(2,s.sname);
			ps.setString(3,s.sbcode);
			ps.setString(4,s.sbname);
			//System.out.println(query);
			ps.executeUpdate();
			System.out.println("student inserted !");
				return true;
		}
		catch(Exception e)
		{
			System.out.println(e);
			return false;
		}
		finally
		{
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				System.out.print(e.getMessage());
			}
		}
	}
	public void printstudentsdb()
	{
		try
		{
			makecon();
			query="select * from students";
			PreparedStatement ps=con.prepareStatement(query);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				System.out.print(rs.getString(1));
				System.out.print(",");
				System.out.print(rs.getString(2));
				System.out.print(",");
				System.out.print(rs.getString(3));
				System.out.print(",");
				System.out.print(rs.getString(4));
				System.out.println();
			}
			reader.readLine();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}
	}
	public static void main(String args[])
	{
		new studentslist();
	}
}