jdbC连接到数据库

<span style="font-size:18px;">package cn.aweiyo.jdbc;

import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.DriverPropertyInfo;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import org.junit.Test;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;

public class JDBCtest {
	@Test
	public void demo1() throws ClassNotFoundException, SQLException {
		  Class.forName("com.mysql.jdbc.Driver") ; //加载MySQL的驱动类
                      
                     java.sql.Connection con =    
	             DriverManager.getConnection("jdbc:mysql://localhost:3306/day13" , "root" , "1" )  ;
		  Statement stmt = con.createStatement() ;   
		  ResultSet rs = (ResultSet) stmt.executeQuery("SELECT * FROM user") ;  
		  while(rs.next()){   
		    String name = rs.getString("name") ;   
		  
		    System.out.println(name);
		  }
              </span><pre name="code" class="java">package cn.aweiyo.jdbc;

import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.DriverPropertyInfo;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import org.junit.Test;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;

public class JDBCtest {
	@Test
	public void demo1() throws ClassNotFoundException, SQLException {
	//加载MySQL	
              Class.forName("com.mysql.jdbc.Driver") ; 
	//建立连接	  java.sql.Connection con =    
	             DriverManager.getConnection("jdbc:mysql://localhost:3306/day13" , "root" , "1" )  ;
		  Statement stmt = con.createStatement() ;   
		  ResultSet rs = (ResultSet) stmt.executeQuery("SELECT * FROM user") ;  
		  while(rs.next()){   
		    String name = rs.getString("name") ;   
		    String pass = rs.getString(1) ;
		    System.out.println(name);
		  }

//关闭资源
		  rs.close() ; 
		  stmt.close();
		  con.close();
	}
}

rs.close() ; stmt.close(); con.close();}}