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 {

		createTable ();


	}


	public static void createTable () throws Exception {

		try {

			Connection con = getConnection ();
			java.sql.PreparedStatement create = con.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 = getConnection ();
			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 = getConnection ();
			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); }



	}
	*/

	public static Connection getConnection() throws Exception{

		try{
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/guest";
		String username = "root";
		String password = "guest123";
		Class.forName(driver);
		Connection conn = DriverManager.getConnection(url,username,password);
		System.out.println("Connected");
		return conn;
		}
		catch(Exception e){
			System.out.println(e);
			}
		return null;
		}


}