dbconnection.java

物料管理 物料登记 批量登记：一次性导入多条物料 单条登记：只能录入一条物料信息 物料管理 更新： 删除： 查看： 物料导出 库管员可以将系统中登记的所有物料一次性导出来 Mat

package com.qrsx.storage.manager;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DBConnection {

	   /**
	      Gets a connection from the properties specified
	      in the file database.properties
	      @return the database connection
	   */
	   public static Connection getConnection()
	      throws SQLException, IOException
	   {  
	      Properties props = new Properties();
	      File file = new File("E:\\java\\storage\\src\\database.properties");
	      FileInputStream in = new FileInputStream(file);
	      props.load(in);
	      in.close();

	      String drivers = props.getProperty("jdbc.drivers");
	      if (drivers != null) System.setProperty("jdbc.drivers", drivers);

	      String url = props.getProperty("jdbc.url");
	      String username = props.getProperty("jdbc.username");
	      String password = props.getProperty("jdbc.password");
	     try{
	    	 Class.forName(drivers);
	    	 
	     }catch(ClassNotFoundException e){
	    	 e.printStackTrace();
	     }
	     return DriverManager.getConnection(url, username, password);
	   }
}