java JFrame自动计算
我在JAVA中使用Netbeans自动计算文本字段时遇到问题
我的问题是,我是否会在文本字段中输入数值进行自动加法,然后在文本字段中输入数值到(票价、税费和comm%),在这里我将进入字段自动计算,所以在单击提交按钮之前,我将如何在文本字段(comm)和(成本价格)中获得这些数值的结果
try { String sql = "insert into ticketing (Date,LPO,PassName,Route,AirlineCode,TicketNum,SellingPrice, Contact, Officer,Fare,Tax,comm%,comm,CostPrice,System,Remart)" + "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
pst = conn.prepareStatement(sql);
//pst.setInt(1, Integer.parseInt(id.getText()));
pst.setString(1, Date.getText());
pst.setString(2, LPO.getText());
pst.setString(3, PassName.getText());
pst.setString(4, Route.getText());
pst.setString(5, AirCode.getText());
pst.setString(6, TikNum.getText());
pst.setString(7, SellPrice.getText());
String Conta;
Conta = Cont.getSelectedItem().toString();
pst.setString (8,Conta);
String Officer;
Officer = Offic.getSelectedItem().toString();
pst.setString (9,Officer);
pst.setString(10, Fare.getText());
pst.setString(11, Tax.getText());
pst.setString(12, commper.getText());
pst.setString(13, comm.getText());
pst.setString(14, CostPrice.getText());
String Sys;
Sys = System.getSelectedItem().toString();
pst.setString (15,Sys);
pst.setString(16, Remark.getText());
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "insertion successful");
conn.close();
}catch (SQLException e){
JOptionPane.showMessageDialog(null, e);
}
怎么能做到呢
谢谢
# 1 楼答案
我不得不用
DocumentFilter
来解决这个问题,我只是在分享我的代码,它可能会在将来帮助一些人,也可能帮助一些人搜索知识