public class ClientsAction {
private ClientsService clientsService;
private List clientslist;
private Integer count;
private Clients clients;
public Integer getCount() {
return count;
}
public void setCount(Integer count) {
this.count = count;
}
public List getClientslist() {
return clientslist;
}
public void setClientslist(List clientslist) {
this.clientslist = clientslist;
}
public ClientsService getClientsService() {
return clientsService;
}
public void setClientsService(ClientsService clientService) {
this.clientsService = clientService;
}
public Clients getClients() {
return clients;
}
public void setClients(Clients clients) {
this.clients = clients;
}
//public String addclients(){
//clientsService.saveClient(clients);
//return "addclients";
//}
public String addclient() throws Exception{
clients.setClientid(getclientsid());
System.out.print(clients.getClientid()+","+clients.getName()+","+clients.getTel());
clientsService.saveClient(clients);
return "addclient";
}
private String getclientsid(){
String clientsid="";
int id=0;
ArrayList list=new ArrayList();
clientslist=clientsService.findAllClient();
if(clientslist==null&clientslist.size()==0){
clientsid="0000001";
}
else{
for(int i=0;i<clientslist.size();i++){
list.add(Integer.parseInt(clientslist.get(i).getClientid().trim()));
}
int i=1;
while(true){
boolean b=true;
for(int j=0;j<list.size();j++){
if(list.get(j)==i){
b=false;
break;
}
}
if(b){
id=i;
break;
}
i++;
}
clientsid=String.valueOf(id);
for(int j=0;j<7-clientsid.length();j++){
clientsid="0"+clientsid;
}
}
return clientsid;
}
}
clientid是主键，但是nchar。不能自增长
主键字段不能为空，检查下为什么你插入了null。