[J2SE]s03e06.通过JDBC访问MySQL数据库(练习)

JDBC：Java Database Connectivity

主流数据库：Oracle,SQL-Server,DB2,MySQL,Access,Informix,....

需要下载MySql的JDBC驱动程序(官网Connector/J目录中下载ZIP文件，解压出一个jar包)，引入到工程(项目)中

代码：

package javastudy;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class Test1 {

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		//将驱动程序加载到内存中
		Class.forName("com.mysql.jdbc.Driver");
		//创建一个连接
		Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/student","root","0000");	
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery("select * from studinfo");
		while(rs.next())
		{
			for(int i=1;i<=4;i++)
			{
				System.out.print(rs.getString(i)+"\t");
			}
			System.out.println();
		}
	}

}

运行前需开启MySQL的服务(cmd命令行中输入“net start mysql”，或在控制面板中开启)

另外，起初运行时会提示错误，在MySQL workbench中修改用户密码并重试后得到如下运行结果(仍然有标红的警告提示)

标红提示如下

Thu May 19 21:39:36 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.