📄 anzhuang.java
字号:
if(vec.size()>1){
yewuyuant.setText(vec.get(0));
kehunamet.setText(vec.get(1));
lianxitelt.setText(vec.get(2));
bianhaot.setText(vec.get(3));
guiget.setText(vec.get(4));
anzhuangyuant1.setText(vec.get(5));
yibiaoxinghaot.setText(vec.get(6));
yibiaobianhaot.setText(vec.get(7));
chuanganqiMaxt.setText(vec.get(8));
hao1.setText(vec.get(9));
hao2.setText(vec.get(10));
hao3.setText(vec.get(11));
hao4.setText(vec.get(12));
hao5.setText(vec.get(13));
hao6.setText(vec.get(14));
hao7.setText(vec.get(15));
hao8.setText(vec.get(16));
du1.setText(vec.get(17));
du2.setText(vec.get(18));
du3.setText(vec.get(19));
du4.setText(vec.get(20));
du5.setText(vec.get(21));
du6.setText(vec.get(22));
du7.setText(vec.get(23));
du8.setText(vec.get(24));
ji1.setText(vec.get(25));
ji2.setText(vec.get(26));
ji3.setText(vec.get(27));
ji4.setText(vec.get(28));
ji5.setText(vec.get(29));
ji6.setText(vec.get(30));
ji7.setText(vec.get(31));
ji8.setText(vec.get(32));
cha1.setText(vec.get(33));
cha2.setText(vec.get(34));
cha3.setText(vec.get(35));
cha4.setText(vec.get(36));
cha5.setText(vec.get(37));
cha6.setText(vec.get(38));
cha7.setText(vec.get(39));
cha8.setText(vec.get(40));
tiaoshirent.setText(vec.get(41));
tiaoshidatet.setText(vec.get(42).substring(0,10));
at.setText(vec.get(43));
bt.setText(vec.get(44));
c1t.setText(vec.get(45));
c2t.setText(vec.get(46));
c3t.setText(vec.get(47));
c4t.setText(vec.get(48));//少了2个数据 待处理
d1t.setText(vec.get(49));
d2t.setText(vec.get(50));
et.setText(vec.get(51));
ft.setText(vec.get(52));
gt.setText(vec.get(53));
jianchirent.setText(vec.get(54));
jianchidatet.setText(vec.get(55).substring(0,10));
yibiaoht.setText(vec.get(56));
yibiaoct.setText(vec.get(57));
yibiaocht.setText(vec.get(58));
caozuoyuant.setText(vec.get(59));
telt.setText(vec.get(60));
anzhuangriqit.setText(vec.get(61).substring(0,10));
jieshu.select(vec.get(62));
if(vec.get(62).equals("一节秤体")){
Toolkit tk1=Toolkit.getDefaultToolkit();
Image image11=tk1.createImage("1jie.gif"); /*mytitle.gif图标*/
bag1.setIcon(new ImageIcon(image11));
}else if(vec.get(62).equals("二节秤体")){
Toolkit tk2=Toolkit.getDefaultToolkit();
Image image12=tk2.createImage("2jie.gif"); /*mytitle.gif图标*/
bag1.setIcon(new ImageIcon(image12));
}else if(vec.get(62).equals("三节秤体")){
Toolkit tk3=Toolkit.getDefaultToolkit();
Image image13=tk3.createImage("3jie.gif"); /*mytitle.gif图标*/
bag1.setIcon(new ImageIcon(image13));
}else{
Toolkit tk4=Toolkit.getDefaultToolkit();
Image image14=tk4.createImage("4jie.gif"); /*mytitle.gif图标*/
bag1.setIcon(new ImageIcon(image14));
}
}else{
yewuyuant.setText(yewunames);
kehunamet.setText(kehunames);
}
yewuyuant.setEditable(false);
kehunamet.setEditable(false);
}
public void itemStateChanged(ItemEvent e){ //选择事件
if(e.getSource()==jieshu){
if(jieshu.getSelectedItem()=="一节秤体"){
Toolkit tk=Toolkit.getDefaultToolkit();
Image image1=tk.createImage("1jie.gif"); /*图标*/
bag1.setIcon(new ImageIcon(image1));
}else if(jieshu.getSelectedItem()=="二节秤体"){
Toolkit tk=Toolkit.getDefaultToolkit();
Image image1=tk.createImage("2jie.gif"); /*图标*/
bag1.setIcon(new ImageIcon(image1));
}else if(jieshu.getSelectedItem()=="三节秤体"){
Toolkit tk=Toolkit.getDefaultToolkit();
Image image1=tk.createImage("3jie.gif"); /*图标*/
bag1.setIcon(new ImageIcon(image1));
}else if(jieshu.getSelectedItem()=="四节秤体"){
Toolkit tk=Toolkit.getDefaultToolkit();
Image image1=tk.createImage("4jie.gif"); /*图标*/
bag1.setIcon(new ImageIcon(image1));
}
}
}
public void actionPerformed(ActionEvent e){
if(e.getSource()==lurub){
if(yewuyuant.getText().trim().length()>24){
JOptionPane.showMessageDialog(null,"业务员不能超过24字符");
}else if(kehunamet.getText().trim().length()>50){
JOptionPane.showMessageDialog(null,"客户名不能超过50字符");
}else if(anzhuangyuant1.getText().trim().length()>50){
JOptionPane.showMessageDialog(null,"安装人员不能超过50字符");
}else if(guiget.getText().trim().length()>24){
JOptionPane.showMessageDialog(null,"规格不能超过24字符");
}else if(hao5.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器编号5不能超过12字符");
}else if(hao6.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器编号6不能超过12字符");
}else if(hao7.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器编号7不能超过12字符");
}else if(hao8.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器编号8不能超过12字符");
}else if(du1.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度1不能超过12字符");
}else if(du2.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度2不能超过12字符");
}else if(du3.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度3不能超过12字符");
}else if(du4.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度4不能超过12字符");
}else if(du5.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度5不能超过12字符");
}else if(du6.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度6不能超过12字符");
}else if(du7.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度7不能超过12字符");
}else if(du8.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"传感器灵敏度8不能超过12字符");
}else if(ji1.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础1不能超过12字符");
}else if(ji2.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础2不能超过12字符");
}else if(ji3.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础3不能超过12字符");
}else if(ji4.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础4不能超过12字符");
}else if(ji5.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础5不能超过12字符");
}else if(ji6.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础6不能超过12字符");
}else if(ji7.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础7不能超过12字符");
}else if(ji8.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"承重底板基础8不能超过12字符");
}else if(cha1.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差1不能超过12字符");
}else if(cha2.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差2不能超过12字符");
}else if(cha3.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差3不能超过12字符");
}else if(cha4.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差4不能超过12字符");
}else if(cha5.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差5不能超过12字符");
}else if(cha6.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差6不能超过12字符");
}else if(cha7.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差7不能超过12字符");
}else if(cha8.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"正负差8不能超过12字符");
}else if(tiaoshirent.getText().trim().length()>50){
JOptionPane.showMessageDialog(null,"厂内检验人不能超过50字符");
}else if(tiaoshirent.getText().trim().length()>50){
JOptionPane.showMessageDialog(null,"厂内检验人不能超过50字符");
}else if(at.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"a 不能超过12字符");
}else if(bt.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"b 不能超过12字符");
}else if(c1t.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"c1 不能超过12字符");
}else if(c2t.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"c2 不能超过12字符");
}else if(c3t.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"c3 不能超过12字符");
}else if(c4t.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"c4 不能超过12字符");
}else if(d1t.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"d1 不能超过12字符");
}else if(d2t.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"d2 不能超过12字符");
}else if(et.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"e 不能超过12字符");
}else if(ft.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"f 不能超过12字符");
}else if(gt.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"g 不能超过12字符");
}else if(jianchirent.getText().trim().length()>50){
JOptionPane.showMessageDialog(null,"检尺人不能超过50字符");
}else if(yibiaoht.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"H不能超过12字符");
}else if(yibiaoct.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"C不能超过12字符");
}else if(yibiaocht.getText().trim().length()>12){
JOptionPane.showMessageDialog(null,"CH不能超过12字符");
}else if(caozuoyuant.getText().trim().length()>24){
JOptionPane.showMessageDialog(null,"操作员不能超过24字符");
}else if(telt.getText().trim().length()>24){
JOptionPane.showMessageDialog(null,"操作员电话不能超过24字符");
}else{
String timestr="";
//--------------------当前系统时间---------------------------------------
java.util.Date currentTime =new java.util.Date();
java.text.SimpleDateFormat formatter;
formatter=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
timestr+=formatter.format(currentTime);
//-----------------------------------------------------------------------
StringBuffer sql=new StringBuffer();
sql.append("insert into anzhuangTab(yewuname,kehuname,lianxitel,bianhao,guiget,anzhuangyuan,yibiaoxinghao,yibiaobianhao,chuanganqiMax,hao1,hao2,hao3,hao4,hao5,hao6,hao7,hao8,du1,du2,du3,du4,du5,du6,du7,du8,ji1,ji2,ji3,ji4,ji5,ji6,ji7,ji8,cha1,cha2,cha3,cha4,cha5,cha6,cha7,cha8,tiaoshiren,tiaoshidate,a,b,c1,c2,c3,c4,d1,d2,e,f,g,jianchiren,jianchidate,yibiaoh,yibiaoc,yibiaoch,caozuoyuan,tel,anzhuangriqi,jieshu,updateTime)values('");
sql.append(yewuyuant.getText().trim()).append("','").append(kehunamet.getText().trim()).append("','").append(lianxitelt.getText().trim()).append("','").append(bianhaot.getText().trim()).append("','").append(guiget.getText().trim()).append("','").append(anzhuangyuant1.getText().trim()).append("','");
sql.append(yibiaoxinghaot.getText().trim()).append("','").append(yibiaobianhaot.getText().trim()).append("','").append(chuanganqiMaxt.getText().trim()).append("','").append(hao1.getText().trim()).append("','").append(hao2.getText().trim()).append("','").append(hao3.getText().trim()).append("','").append(hao4.getText().trim()).append("','").append(hao5.getText().trim()).append("','").append(hao6.getText().trim()).append("','").append(hao7.getText().trim()).append("','").append(hao8.getText().trim()).append("','").append(du1.getText().trim()).append("','").append(du2.getText().trim()).append("','").append(du3.getText().trim()).append("','").append(du4.getText().trim()).append("','").append(du5.getText().trim()).append("','").append(du6.getText().trim()).append("','").append(du7.getText().trim()).append("','").append(du8.getText().trim()).append("','");
sql.append(ji1.getText().trim()).append("','").append(ji2.getText().trim()).append("','").append(ji3.getText().trim()).append("','").append(ji4.getText().trim()).append("','").append(ji5.getText().trim()).append("','").append(ji6.getText().trim()).append("','").append(ji7.getText().trim()).append("','").append(ji8.getText().trim()).append("','").append(cha1.getText().trim()).append("','").append(cha2.getText().trim()).append("','").append(cha3.getText().trim()).append("','").append(cha4.getText().trim()).append("','").append(cha5.getText().trim()).append("','").append(cha6.getText().trim()).append("','").append(cha7.getText().trim()).append("','").append(cha8.getText().trim()).append("','").append(tiaoshirent.getText().trim()).append("','").append(tiaoshidatet.getText().trim()).append("','");
sql.append(at.getText().trim()).append("','").append(bt.getText().trim()).append("','").append(c1t.getText().trim()).append("','").append(c2t.getText().trim()).append("','").append(c3t.getText().trim()).append("','").append(c4t.getText().trim()).append("','").append(d1t.getText().trim()).append("','").append(d2t.getText().trim()).append("','").append(et.getText().trim()).append("','").append(ft.getText().trim()).append("','").append(gt.getText().trim()).append("','").append(jianchirent.getText().trim()).append("','").append(jianchidatet.getText().trim()).append("','").append(yibiaoht.getText().trim()).append("','").append(yibiaoct.getText().trim()).append("','").append(yibiaocht.getText().trim()).append("','").append(caozuoyuant.getText().trim()).append("','").append(telt.getText().trim()).append("','").append(anzhuangriqit.getText().trim()).append("','").append(jieshu.getSelectedItem().trim()).append("','").append(timestr).append("')");
ResultSet resSet;
Connection dbConn;
Statement stat;
try{
Class.forName(Yewu.forName);
dbConn=DriverManager.getConnection(Yewu.jdbc);
stat=dbConn.createStatement();
resSet=stat.executeQuery("select yewuname,kehuname from anzhuangTab where kehuname='"+kehunamet.getText().trim()+"'");
if(resSet.next()){
JOptionPane.showMessageDialog(null,"该信息已存在");
}else{
if(stat.executeUpdate(sql.toString())>0){
JOptionPane.showMessageDialog(null," 录入成功");
}
}
stat.close();
dbConn.close();
}catch(Exception ew){
System.out.println(ew);
JOptionPane.showMessageDialog(null,"数据库服务器是否启动");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -