部分代碼：
……
public?void?actionPerformed(ActionEvent?e){
//?TODO?Auto-generated?method?stub
String?diseaseTypeName=texUserName.getText();
textnew?Disease=new?textnew();
Disease.setDiseaseName(diseaseTypeName);
????????CRUDnew?se=new?CRUDnew();
????????
????????
???? textnew?sc=(textnew)box.getSelectedItem();
???? System.out.println(sc.getDiseaseTypeName());
????????if(e.getSource()==bnt){
???????? ?if(se.useone(Disease)>0){
????????????? JOptionPane.showConfirmDialog(null,"增加成功"?);
????????????? frame.setVisible(false);
????????????? new?Jmenustyle();
????????}
????????}
????????else?if(e.getSource()==bnt1){
??????????? ????frame.setVisible(false);
??????????? ????……
添加數(shù)據(jù)代碼：
public?static?int?useone(textnew??Disease){ //增加
int?i=0;
String?sql="insert?into?Disease?values?('"+Disease.getDiseaseId()+"','"+Disease.getDiseaseTypeName()+"')";
????conn=Datebaseone.info();
try{
PreparedStatement?ps?=?conn.prepareStatement(sql);
i=ps.executeUpdate();
}catch(Exception?es){
System.out.println(es.toString());
}
return?i;
}
錯誤提示：
流感
java.sql.SQLException:?[Microsoft][ODBC?SQL?Server?Driver][SQL?Server]INSERT?語句與?FOREIGN?KEY?約束"FK__Disease__Disease__145C0A3F"沖突。該沖突發(fā)生于數(shù)據(jù)庫"treatment"，表"dbo.DiseaseType",?column?'DiseaseTypeId'。
如何使用下拉列表增加一條數(shù)據(jù)到數(shù)據(jù)庫里（eclipse）
qq_炫月孤影_04050182
2016-09-23 18:30:32