MySql连接数据库简单示例

package com.itheima;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBCtest {public static void main(String[] args) {Connection conn = null;Statement stmt = null;ResultSet rs = null;try {//加载驱动器，创建对象Class.forName("com.mysql.jdbc.Driver");//创建连接conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysqldata","root","root");//创建Statement对象，用于执行sql语句stmt = conn.createStatement();stmt.executeUpdate("insert into person(id,name,age,tel) values(2,'搞搞',23,'13333111333')");//将执行结果存入ResultSet中rs = stmt.executeQuery("select * from person where 1=1");//对ResultSet结果集进行遍历while(rs.next()){String id = rs.getString("id");System.out.println(id);}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {//分别关闭所有对象，按照后用到先关闭，最后赋值null以确保try {if(rs!=null){rs.close();rs = null;}if(stmt!=null){stmt.close();stmt = null;}if(conn!=null){conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}