package Reviseknowledge;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

public class Learn {

	public static void main(String[] args) throws Exception {


	}


	static String url = "jdbc:mysql://localhost:3306/guest";
	static String username = "root";
	static String password = "guest123";





	public static void update () throws Exception {




	}
















	/*
	public static void createTable () throws Exception {

		try {

			Connection conn = DriverManager.getConnection(url,username,password);

			PreparedStatement create = conn.prepareStatement("CREATE TABLE IF NOT EXISTS stebuklas "
					+ "( first varchar(253), "
					+ "last varchar(250),"
					+ "numbers integer(50) )");
			create.executeUpdate();

		}

		catch(Exception e){ System.out.println(e); }

		finally { System.out.println ("table was madee"); }

	}








	public static void post () throws Exception {

		String var1 = "ann";
		String var2 = "lesh";
		double var3 = 5;

		try {
			Connection conn = DriverManager.getConnection(url,username,password);
			PreparedStatement posted = conn.prepareStatement (" INSERT INTO stebuklas "
					+ "(first,last,numbers) VALUES  ('"+var1+"', '"+var2+"', '"+var3+"')");

			posted.executeUpdate ();
			posted.executeUpdate ();

		}
		catch(Exception e){ System.out.println(e); }

		finally {System.out.println ("values inserted to the table.");}


	}





	public static void get() throws Exception {
		try{
			Connection conn = DriverManager.getConnection(url,username,password);
			PreparedStatement statement = conn.prepareStatement("SELECT * FROM stebuklas LIMIT 2");
			PreparedStatement stat = conn.prepareStatement("SELECT * FROM stebuklas LIMIT 3");

			ResultSet result = statement.executeQuery ();
			ResultSet res = stat.executeQuery ();

			while  (result.next() ) {

				System.out.println ( result.getString("first") );

			}


			while ( res.next() ) {

				System.out.println ( res.getInt("numbers") );

			}


		}
		catch(Exception e){ System.out.println(e); }



	}

	*/

}