dbconnection.java

来自「实现基本的购物车功能。 eclipse+sqlserver2005 1.主要」· Java 代码 · 共 36 行

package com.svse.DBConnection;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
public class DBConnection
{
	   Connection conn=null;

	   public Connection  getConnection()
	   {
		
	       try 
	       {  //属性文件
	    	   Properties prop=new Properties();
	    	   InputStream is=this.getClass().getResourceAsStream("/systemconfig.properties");
	    	   //从输入流中读取属性列表
	    	   prop.load(is);
	    	   
	           Class.forName(prop.getProperty("driver"));
	           conn = DriverManager.getConnection(prop.getProperty("url"),prop.getProperty("username"),prop.getProperty("password"));
	           conn.setAutoCommit(false);
	          
	       } 
	       catch (Exception e) 
	       {
	           e.printStackTrace();
	           System.out.println("数据库连接异常！");
	       }
	       return conn;
	   }
	  
	  
   }