JDBC,java对mysql进行新增

import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
public class JDBCTest01 {
	public static void main(String[] args){
		Connection conn = null;
		Statement st = null;
		try{
			//1、注册驱动
			Driver driver = new com.mysql.cj.jdbc.Driver();//多态父类型引用指向子类型对象
			DriverManager.registerDriver(driver);   //此方法有异常SQLException
			//2、获取连接
			String url = "jdbc:mysql://127.0.0.1:3306/lzhnb";
			String user = "root";
			String password = "l1170265936";
			conn = DriverManager.getConnection(url,user,password);
			System.out.println("数据库连接对象=" + conn);
			//数据库连接对象=com.mysql.cj.jdbc.ConnectionImpl@dbf57b3

			//3、获取数据库操作对象
		    st = conn.createStatement();
			//4、执行sql
			String sql = "insert into dept(deptno,dname,loc) values(50,'测试','测试')";
			//专门执行DML语句
			//返回值是影响数据库中的记录条数
			int count = st.executeUpdate(sql);
			System.out.println(count == 1 ? "保存成功" : "保存失败");
			//5、处理查询结果集
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			//6、释放资源
			//遵循从小到大依次关闭
			//分别对其trycatch
			if(st != null){
				try{
					st.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
			}
			if(conn != null){
				try{
					conn.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
			}
		}
			
	}
}