import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JOptionPane;
import com.mysql.jdbc.Driver;


public class DBConnection {
	String dbName="woerterbuch";
	String dbUser="root";
	String dbPw="test";
	String fail="test";
	
	Dict_Interface_Input dIn = new Dict_Interface_Input();
	
	public void FailMessage(){
		JOptionPane.showMessageDialog(dIn, fail, "Fehler", JOptionPane.INFORMATION_MESSAGE);
	}
	
	public String saveDataDB(String plWort, String plKommentar, String pdWort){
		String check="false";
		
		
		try{
			
			//Class driverClass = Class.forName("com.mysql.jdbc.Driver");
			//DriverManager.registerDriver((Driver) driverClass.newInstance());
			
			Class.forName("com.mysql.jdbc.Driver");
			
			//JDBC-Treiber laden
			//Class.forName("com.mysql.jdbc.Driver");
			//DriverManager.registerDriver(driver);
			//FailMessage();
			//Class.forName("mysql-connector-java-5.1.23-bin.jar").newInstance();
			//System.out.println("Test2");
			//DriverManager.registerDriver(driver);
			//Verbindung zu MYSQL aufbauen
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/", dbUser, dbPw); 
			FailMessage();
			System.out.println("Connection successfully");
			String lWort = plWort;
			String lKommentar = plKommentar;
			String dWort = pdWort;
			//SQL-Strings erstellen
			String query_selectDB = "USE woerterbuch";
			String query_lat = "INSERT INTO tlatein VALUES('"+ lWort +"','"+ lKommentar +"')"; //speichern, verschiedene Wörter
			String query_ger = "INSERT INTO tdeutsch(dWort)VALUES('"+ dWort + "')"; //speichern, verschiedene Wörter
			
			Statement stmt = con.createStatement();
			ResultSet rs_selectDB = stmt.executeQuery(query_selectDB);
			//System.out.println("Test3");
			int rs_lat = stmt.executeUpdate(query_lat);
			//System.out.println("Test4");
			int rs_ger = stmt.executeUpdate(query_ger);
			//System.out.println("Test5");
			con.close();
			
			check = "true";
						
		}catch(Exception e){
			//fail = e.getMessage();
			//FailMessage();
		}
		
		return check;
	}
}