1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.*; import java.sql.Statement; public class vanied { Connection Verbindung; Statement stmt; vanied() { try { Class.forName("com.mysql.cj.jdbc.Driver"); Verbindung = DriverManager.getConnection("jdbc:mysql://java.www:3306/db-name?serverTimezone=UTC","db-benutzer","db-kennwort"); stmt = Verbindung.createStatement(); } catch(SQLException | ClassNotFoundException e){ System.out.println(e); } } void updateTopic(String ID, String Author, String dt) throws SQLException { String query = "UPDATE GDN_Discussion set DateInserted=" + dt + " where DiscussionID=" + ID + ";"; if ("" != Author) // das ist ein Kommentar query = "UPDATE GDN_Comment set InsertUserID=" + Author + ", DateInserted=" + dt + " where CommentID=" + ID + ";"; stmt.executeUpdate(query); } String benutzerExist(String benutzerName){ String benutzerID = ""; try { ResultSet rs = stmt.executeQuery("SELECT UserID FROM GDN_User WHERE Name=\"" + benutzerName + "\";"); while (rs.next()) { benutzerID = rs.getString("UserID"); } } catch (SQLException e) { System.out.println(e); } return benutzerID; } int maxBenutzerID(){ try { ResultSet rs = stmt.executeQuery("SELECT MAX(UserID) FROM GDN_User;"); while (rs.next()) { return rs.getInt("UserID"); } } catch (SQLException e) { System.out.println("Houston, wir haben ein Problem: " + e); } return 0; } String regBenutzerName(String benutzerName) { String benutzer = benutzerExist(benutzerName); if (benutzer != "") return benutzer; String kennwort = "neues-kennwort"; String query = "INSERT INTO GDN_User (UserID, Name, Password, HashMethod, Email, ShowEmail, Gender, CountVisits, " + "CountInvitations, Permissions, Attributes, HourOffset, Admin, Banned, Deleted) " + "VALUES(" + maxBenutzerID()+1 + ",\"" + benutzerName + "\", \"" + kennwort + "\", Vanilla, 'generiert@e-mail.www', 0, m, 0, 0, '', '', 2, 0, 0, 0);"; try { stmt.executeUpdate(query); return String.valueOf(maxBenutzerID()+1); } catch (SQLException e) { System.out.println("Houston, wir haben ein Problem: " + e); } return ""; } } |
To launch files from Chrome’s context menu, I’ve registered a simple new URI handler: https://docs.microsoft.com/en-us/previous-versions/windows/internet-explorer/ie-developer/platform-apis/aa767914(v=vs.85) i.e. vanied:
Add to Windows registry:
1 2 3 4 5 6 7 8 9 10 |
HKEY_CLASSES_ROOT vanied (Default) = "URL:Vanied Protocol" URL Protocol = "" DefaultIcon (Default) = "java.exe,1" shell open command (Default) = "C:\openjdk-15.0.1\bin\java.exe" --module-path C:\Users\User\IdeaProjects\javafx-sdk-11.0.2\lib --add-modules javafx.controls,javafx.fxml -jar "C:\Users\User\IdeaProjects\vanied\out\artifacts\vanied_jar\vanied.jar" "%1" |
Context Menu Editor plugin for Chrome: cme3.4.0.cab
After installing right click on Options:
Add new item
Edit and apply. Except info.linkUrl there are number of different data: https://developer.chrome.com/extensions/contextMenus#property-onclick-info