basedao.java

模拟的土豆网视频网站

package cn.myvideosite.data.model.dao;

//import java.io.IOException;
//import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
//import java.util.Properties;

public abstract class BaseDAO {
      protected static Connection connection;
      static{
    	  init();
      }
	/**
	 * @return the connection
	 */
	public static Connection getConnection() {
		return connection;
	}
	protected static void init(){
	/*	InputStream is=ClassLoader.getSystemResourceAsStream("init.properties");
		Properties prop=new Properties();
		try {
			prop.load(is);						
			Class.forName((String) prop.get("datasource.driverClassName"));						
			connection=DriverManager.getConnection((String)prop.get("datasource.url"),(String)prop.get("datasource.username"),(String)prop.get("datasource.password"));				    				
		     
		} catch (IOException e) {			
			e.printStackTrace();
		} catch (ClassNotFoundException e) {			
			e.printStackTrace();
		} catch (SQLException e) {			
			e.printStackTrace();
		}
		*/	
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/tudou?useUnicode=true&characterEncoding=utf8","root","haorui");
			
			System.out.println("成功连接数据库!");
		} catch (ClassNotFoundException e) {
			
			e.printStackTrace();
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
	}  
}