java 连接数据库的几种方法

package day9JDBCText;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import java.util.ResourceBundle;

import javax.annotation.Resource;

import org.junit.Test;

import com.mysql.jdbc.Driver;

public class JDBCDemo {
    public static void main (String[] args) throws Exception{
        trans1();
    }
    
    public static void trans1() throws SQLException{
        //注册驱动
        DriverManager.deregisterDriver(new Driver());
        //进行连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql3","root","daichangxia");
        //创建对象
        Statement statement = connection.createStatement();
        //执行操作
        ResultSet resultSet = statement.executeQuery("select * from stu");
        //遍历输出结果
        while(resultSet.next()){
            Object object = resultSet.getObject(1);
            Object object1 = resultSet.getObject(2);
            Object object2 = resultSet.getObject(3);
            System.out.println(object+"--- "+object1+"--- "+object2);
        }
        connection.close();
        statement.close();
        resultSet.close();
    }
    @Test
    public void trans2() throws Exception{
        //注册驱动
        DriverManager.deregisterDriver(new Driver());
        //创建连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql3", "root", "daichangxia");
        //操作对象
        Statement statement = connection.createStatement();
        //进行操作
        ResultSet resultSet = statement.executeQuery("select * from stu");
        //遍历结果
        while(resultSet.next()){
            String name = resultSet.getString("name");
            String high = resultSet.getString("high");
            String desp = resultSet.getString("desp");
            System.out.println(name+"--"+high + "---"+desp);
        }
        connection.close();
        statement.close();
        resultSet.close();
    }
    @Test
    public void trans3() throws Exception{
        //注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        Properties properties = new Properties();
        properties.setProperty("user", "root");
        properties.setProperty("password", "daichangxia");
        //进行连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql3", properties);
        Statement statement = connection.createStatement();
        //进行操作
        ResultSet resultSet = statement.executeQuery("select * from stu");
        //遍历输出
        while (resultSet.next()) {
            System.out.println(resultSet.getString("name")+"---"+resultSet.getString("high"));
        }
        connection.close();
        statement.close();
        resultSet.close();
        
    }
    @Test
    public void trans4() throws Exception{
        Class.forName("com.mysql.jdbc.Driver");
        //进行连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql3?user=root&password=daichangxia");
        //创建操作对象
        Statement statement = connection.createStatement();
        //进行操作
        ResultSet resultSet = statement.executeQuery("select *from stu");
        //遍历输出
        while (resultSet.next()) {
            System.out.println(resultSet.getString("name"));
        }
    }
    @Test
    //常用
    public void trans5() throws Exception{
        //获取配置
        ResourceBundle bundle = ResourceBundle.getBundle("myProperty");

        //ResourceBundle bundle = ResourceBundle.getBundle("mysql");
        //参数
        String url = bundle.getString("urlPro");
        String password = bundle.getString("passwordPro");
        String user = bundle.getString("userPro");
        String driveClass = bundle.getString("drivePro");
        //注册驱动
        Class.forName(driveClass);
        //进行连接
        Connection connection = DriverManager.getConnection(url, user, password);
        //创建操作对象
        Statement statement = connection.createStatement();
        //操作
        ResultSet resultSet = statement.executeQuery("select *from stu");
        while(resultSet.next()){
            System.out.println(resultSet.getString("name"));
        }
        
        
    }

}
 

转载于:https://my.oschina.net/u/3164851/blog/812433