Search:

Thank you - that's perfect!

How do I develop my code to listen for F5 and F10, so if F5 is pressed run 'runSQL(conn, sqlStatement.getText().trim());' otherwise if F10 is pressed run 'runUpdateQuery(conn,...

It's okay - I figured it out. I was calling the getText value in the wrong place

I have a database connection which works well when using static final Strings, i.e. DATABASE_NAME = "test";

I want to make this a little more dynamic so I created a text box on my JFrame


...

This should get you started on connecting to a MS Access DB


http://www.codeproject.com/Articles/35018/Access-MS-Access-Databases-from-Java


As for importing (not exporting) I can't help you...

How do I create a global login so that when the user logs in with their username and password that information is retained?

Here is my connection class. Currently, I am using static final...

Apologies, I meant run jar not create.
Anyway, thanks for the lead - I put the jar in the folder relative to the lib directory and it is now running :-)

Thanks - hadn't noticed that 'forward slash'.
Still can't create my jar file. 2 more screenshots 1)my layout in Eclipse and 2) the latest output from command

Hi,

The mysql driver is on the build path (as far as I can tell). I added it by right-clicking on the project in Eclipse/build path/configure and under Libraries I can see the mysql driver which...

I am working on a java front-end with a mysql database back-end.
It work's well in Eclipse, however, when I export it to a jar file I get the following 'class not found exception...

If you want to use a free text editor for Java coding take a look at Notepad++. It's a powerful text editor with its own set of plugins etc and I use it for everyday text use - great for copying and...

Thanks, figured it out. I had to add ResultSet.CONCUR_UPDATABLE to the createStatement method.



rs = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE...

Hi,

I am displaying the results of sql query (using com.mysql.jdbc.Driver) in a jtable. Here is the main part of the code



package guidatabase1;

import java.sql.Connection;
import...

Thanks! This is a tongue in cheek of way of doing the same thing ;-)

Let me Google that for you

Actually, being serious, I was thinking on the lines that members had some useful links which...

I have to login and connect to a mysql database using a java front end. I am also required to write and run queries in Java using Statement, etc.

Does anyone know of any useful links /...

Thank you. This is exactly what I want to do. Now that I know it is possible I am happy to research this method.

Cheers

Sorry about that. I used Excel to sort the order but it removed the colon which I didn't notice.
So, to clarify, this is my original list:

-4: a7a5
-3: b7b6
-6: f7f5
1: c7c6
2: d7d6
12:...

What would be the best way to sort this string into descending order by score, i.e:

from:
-4: a7a5
-3: b7b6
-6: f7f5
1: c7c6
2: d7d6
12: e7e6
13: d7d5

Norm & dlorde,

I have studied this loop but I cannot for the life of me figure out how to print lines at the top of my list.
I am trying method 1 proposed by Norm, i.e. Get the old text,...

I tried your method previously - it doesn't work. I need to print the most recent line at the top of my JTextArea but instead the most recent line prints at the bottom. In effect I need the data...

I was trying different methods with different techniques but none of my my methods prints the line at the top of the JTextArea. I left the code as was...aploogies for the confusion.


This is the...

I have tried many permutations to concatenate the data to insert the new line at the front v end with no luck so far. I am having problems concatenating old and new data inside a loop. This is...

Yes, well summarised :-)

I am not sure how to do it but I will research further on Internet

I have the following routine:



private void getEngineOutput(Process engine) {
try {
BufferedReader reader =
new BufferedReader(new...

Ok Norm, thanks for all your help.
I can take it form here.

ATB