创建JDBC连接的三种方式

package com.atguigu.demo1;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import org.junit.Test;

public class TestConnection2 {
	/*
	 *getConnection(url):连接url?user=用户名&password=密码 
	 */
   @Test
	public void testCon1() throws ClassNotFoundException, SQLException{
	   Class.forName("com.mysql.jdbc.Driver");
	   Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/girls?user=root&password=root");
	   System.out.print("成功1");
    }
   @Test
   public void testCon2() throws SQLException, ClassNotFoundException
   {
	  Class.forName("com.mysql.jdbc.Driver");
	  Connection connection=DriverManager.getConnection("jdbc:mysql:///girls","root","root");
	  System.out.println("成功2");
   }
   
   @Test
   public void testCon3() throws SQLException, ClassNotFoundException, FileNotFoundException, IOException
   {
	  Class.forName("com.mysql.jdbc.Driver");
	  Properties properties=new Properties();
	  properties.load(new FileInputStream("src/db.properties"));
	  Connection connection=DriverManager.getConnection("jdbc:mysql:///girls",properties);
	  
	  System.out.println("成功3");
   }
   
   
   
}

  

posted @ 2018-01-16 08:51  xqyun_yun  阅读(2034)  评论(0编辑  收藏  举报