tools.java

含有 销售商、进货商

package dao;

import java.sql.*;

public class Tools {
    
	
	//创建一个静态方法,返回一个连接
	public static Connection getConnection()
	{    
		String driver = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@localhost:1521:oracle";
		String username = "suxuelei";
		String password = "suxuelei";
		Connection conn = null;
        //注册驱动程序
		try {
			Class.forName(driver);
            //获得连接
			conn = DriverManager.getConnection(url,username,password);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}

}