Add GUI to existing Java App using Netbeans, connect to SQL database, add data, query data.
I have a Very basic Java App that runs on the command line. Takes a security log file, parses it, and produces a text file with SQL commands.
What I'm trying to do (with limited success) is:
Use netbeans to create a GUI interface for my Java classes and then load and query the file via the GUI.
I have a partially written programme, but it may be faster for you to start from scratch.
1) Select file to parse.
(using JFileChooser class in Java)
2) Parse the file and upload to SQL on a local mySQL server.
(Using class already written to parse log file and create sql database)
(I also have a class to connect to the database - but it doesn't work with the GUI - you may already have one)
(Once this works for the saved username and password it would be great to type in the password => username can remain root)
3) Run queries against the file in SQL - start with a simple select and then add in more queries as a second step
(use pre-written queries so that it's not vulnerable for an SQL injection).
(results should be displayed in a scroll-able JTable - I've been using a mapping class - but you may have a better idea.)
One this is working then there will be additional queries to add in.
The query results should also provide a screen with details including a web page reference.
I'm told to get this working won't take very long for someone who uses Java a lot.
Đã trao cho:
i am java/javafx, mysql expert and have full experience for 12 years. java/javafx, mysql is my top skill and passision. i can provide most quality and high speed. if you want to success, please contact me.
17 freelancer đang chào giá trung bình €14/giờ cho công việc này
Hello, i have read your job description and fully understand your requirements. It looks like I’ll be the perfect candidate for this job because I have hands on experience in this field. let discuss
hello i am interest in your project. i have enough skills for your project. I can do it at a high level in the near future. i will work full time. if you give me chance, i will do my best for you.