Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Java MySQL ODBC
I have created a login program in Java. It uses a database with two fields (Username and Password). The program accesses the database and retrieves the records from the two fields. It works on my computer with the ODBC server address being set to 192.168.1.4 and the ports have been opened. However I need to know how I can create a ODB Connection via cmd line but having it access the cmd line from the Java application. And also how do I add a driver to the ODBC folder as I am using MySQL and is this needed or could I use the SQL Server driver that is in the files instead.
 
The code for the Login program is below
 
	public static void main(String[] args)
	{
		if (ConnectionSetup = true)
		{
			//Do Nothing
		}
		else if (ConnectionSetup = false)
		{
			SetupConnection();
		}
		new Login();
	}
	
	public static void SetupConnection()
	{
		//The code for the command line would go here
	}
}

Can somebody please help me because I have tried everything that I know. Thanks in advance.
Posted 18-Jun-12 2:50am
Edited 18-Jun-12 2:57am
TorstenH.33.9K
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

no command line - you should use a proper JDBC-Connection.
 
Tutorial on JDBC[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 269
1 OriginalGriff 240
2 CPallini 195
3 Maciej Los 177
4 BillWoodruff 173
0 OriginalGriff 5,655
1 DamithSL 4,506
2 Maciej Los 3,997
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 18 Jun 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100