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(); } } } }