JDBC连接mysql案例01

JDBC连接mysql案例

/*
	JDBC连接Msql六步
*/
import java.sql.*;

public class JDBCTest02{
	public static void main(String[] args){
		Statement stmt = null;
		Connection conn = null;
		try{
			//注册驱动
			DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
			//打开通道
			String url = "jdbc:mysql://localhost:3306/mysql";
			String user = "root";
			String pwd = "123456";
			
			conn = DriverManager.getConnection(url,user,pwd);
			System.out.println("数据库连接对象是"+conn);

			//获取数据库操作对象
			stmt = conn.createStatement();
			//执行SQL
			String sql = "insert into user(name,age) values('张三',35)";
			//专门执行DML语句(插入,更新,删除)
			//返回值是影响数据库的记录条数 
			int res = stmt.executeUpdate(sql);
			System.out.println(res == 1?"保存成功":"保存失败");
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			//释放资源 遵循从小到大一次关闭  并且分别对其 try{}catch(){}
			try{
				if(stmt != null){
					stmt.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}

			try{
				if(conn != null){
					conn.close();
				}
			}catch(SQLException e){
				e.printStackTrace();
			}
		}
	}
}