注册mysql数据库驱动_jdbc mysql数据库链接 及 三种不同的注册驱动的方式

package cn.sigangjun.project;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

/**

* @author sigangjun

*

*/

public class MysqlJdbcTest {

public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {

//1.注册驱动

DriverManager.registerDriver(new com.mysql.jdbc.Driver());

System.getProperty("jdbc.drivers","com.mysql.jdbc.Driver:oracle.jdbc.driver.OracleDriver");

Class.forName("com.mysql.jdbc.Driver").newInstance();

//2.建立连接

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dang","root","root");

//3.创建语句

Statement st = con.createStatement();

//4.执行语句

ResultSet rs = st.executeQuery("select * from d_user");

//5.执行结果

while(rs.next()){

System.out.print(rs.getObject(1)+"\t");

System.out.print(rs.getObject(2)+"\t");

System.out.print(rs.getObject(3)+"\t");

System.out.println(rs.getObject(4));

}

//6.释放资源

rs.close();

st.close();

con.close();

}

}