保证数据唯一性，校验功能

1、后端写校验接口实现类
public String getSubmitStatus(String personnel_number,String personnel_name) throws ClassNotFoundException, SQLException {
//开jdbc,关jdbc
String driver = “com.cloudera.impala.jdbc41.Driver”;
String url = “jdbc:impala://10.244.16.6:21050/dm;AuthMech=3;UID=impala;PWD=impala;UseSasl=0”;
String username = “impala”;
String password = “impala”;
Connection connection = null;
Class.forName(driver);
connection = DriverManager.getConnection(url,username,password);
//目标表等于录入并且要加限制条件，没被删掉的!
//目标表等于录入并且要加限制条件，没被删掉的!
String sql = “select *from dm.d_personnel_number a where a.personnel_type=‘录入’”;
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
//遍历结果集，将结果集转成list的临时对象接收
List list = new ArrayList<>();
while (resultSet.next()){
EnterPerson enterPerson = new EnterPerson();
String personnel_number1 = resultSet.getString(“personnel_number”);
String personnel_name1 = resultSet.getString(“personnel_name”);
enterPerson.setPersonnel_number(personnel_number1);
enterPerson.setPersonnel_name(personnel_name1);
list.add(enterPerson);
}
resultSet.close();
statement.close();
connection.close();
//遍历list判断，保证数据唯一性。没问题即可插入
String insert = “1”;//默认是可以提交的
for(int i=0;i<list.size();i++){
EnterPerson a = list.get(i);
//抽完全取出来，然后没被删的可用的中判断.equals（null）意为填了一个“null”的字符串
if(personnel_number.equals(“null”)){
insert = “3”;
break;
}if(list.get(i).getPersonnel_number().equals(personnel_number)){
insert = “2”;
break;
}
if(list.get(i).getPersonnel_name().equals(personnel_name)){
insert = “0”;
break;
}
}
return insert;
}

2、前端ajax请求
function a(){
var z=KaTeX parse error: Expected 'EOF', got '#' at position 3: ("#̲personnel_numbe…("#personnel_name").val();
if(z==""){
url=“getSubmitStatus/”+“null”+"/"+x;
}else{
url=“getSubmitStatus/”+z+"/"+x;
}
console.log(url);
RESTFul.GET(url,function(data){
if(data3){
alert(“录单人员编号不能为空”)
}else if(data2){
alert(“录单人员编号已经存在”)
}else if(data0){
alert(“录单人员名称已经存在”)
}else if(data1){
//可以提交表单了
url=“update/”+z+"/"+x;
RESTFul.GET(url,function(data){
if(data==1){
//跳转到列表页面
window.history.back(-1);
}
})
}
})
}
3、根据返回状态判断满足可提交的接口里，再次请求ajax调新增的接口，新增成功后返回成功状态，ajax根据data返回的成功状态进行处理返回到上一页列表页面