连接mysql属性文件_如何读取属性文件并连接MySQL数据库？

I need to connect my MySQL database from within Java program, for that I have to use JDBC.

I need to supply it with the necessary connection parameters. And I have to store these parameters in a separate configuration file to be passed as an argument to your Java program during execution. A sample db.properties file has been provided to me for my reference. The five lines of the file correspond to the host, port, database name, username and password for the database. I need to change the parameters according to your individual system setup.

How do I proceed with this? How do I connect MySQL database?

basically, I have a createdb.sql file . I have to run that file in mysql. It will create a database. Now I need to populate the database. I have two input files. I need to write a program in java that takes the names of the input data files as command line parameters, parses the files, and populates the data contained within them into your database via JDBC

解决方案

First, you need the mysql jdbc connector. Download the library and add the jar to the classpath.

The next steps (in your application) are to load the jdbc driver and to create a connection:

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection(

"jdbc:mysql://[host][:port]/[database]", username, password);

So you'll have to read the config file, extract the values and create the connection string (host, port, database part).

if you're using eclipse: create a 'lib' folder in your project, copy the jar to that folder, right-click the jar and add it to the build path.

if you're executing the application manually, and you did it like this:

java com.example.MyApplication

do it like this now:

java -cp .;path/to/jarfile/connector.jar com.example.MyApplication

(I'm not sure if the lib is named connector.jar, use the correct filename here)