Java使用executeUpdate()导致程序异常

代码

package okkk;
import java.sql.*;
import java.text.*;
import java.util.*;
public class test02 {
	public static void main(String[] args) throws Exception{
		Connection con=null;
		ResultSet rs;
		String diver="com.mysql.cj.jdbc.Driver";
		String url="jdbc:mysql://localhost:3306/sqltestdb?useSSL=false&&serverTimezone=UTC";
		String user="root";
		String password="1234";
		Class.forName(diver);
		con = DriverManager.getConnection(url,user,password);
		if(!con.isClosed()) System.out.println("Succeeded connecting to the Database!");
		Statement statement = con.createStatement();
		String sql = "select * from emp";
		rs=statement.executeQuery(sql);
		System.out.println("------------------");
		System.out.println("执行结果如下所示：");
		System.out.println("------------------");
		System.out.println("姓名"+"\t"+"职称");
		System.out.println("------------------");
		
		String job=null;
		String id=null;
		while(rs.next()) {
			job = rs.getString("job");
			id = rs.getString("ename");
			System.out.println(id+"\t"+job);
		}
		add(con);
		System.out.println("Succeeded");
		rs=statement.executeQuery(sql);
		while(rs.next()) {
			job = rs.getString("job");
			id = rs.getString("ename");
			System.out.println(id+"\t"+job);
		}
	}
	
	static void add(Connection con) throws Exception{
		String sql="insert into emp (empno,ename,job,hiredate,sal)"+"values(?,?,?,?,?)";
		PreparedStatement psql = con.prepareStatement(sql);
		psql.setInt(1, 3672);
		psql.setString(2, "王ee");
		psql.setString(3, "总裁");
		psql.setString(4, "2010-09-13");
		psql.setFloat(5, (float)2000.3);
		psql.executeUpdate();
	}
	
}

若添加了原本数据表中就有的数据时就会程序异常使程序终止

若需要程序继续执行可单独对executeUpdate()抛出异常。