📄 ziliaowanshan2.java
字号:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import java.util.*;
import java.sql.*;
public class ZiliaoWanshan2 extends JFrame implements ActionListener
{
JButton b1=new JButton("确定");
JButton b2=new JButton("取消");
String s2=null;
Statement s;
ResultSet rs;
JTextField jt0, jt1,jt2,jt3,jt4,jt5,jt6,jt;
JLabel lb,lb0,lb1,lb2,lb3,lb4,lb5,lb6,lbda;
JPanel p[]=new JPanel[9];
JPanel ppp=new JPanel();
JComboBox cbb=new JComboBox();
JComboBox cbb2=new JComboBox();
String m;
public ZiliaoWanshan2(String str,String ii)
{
super("资料完善");
s2=str;
m=ii;
cbb.addItem(" 男 ");
cbb.addItem(" 女 ");
cbb2.addItem(" 管理员 ");
cbb2.addItem(" 操作员 ");
jt=new JTextField(20);
jt0=new JTextField(20);
jt3=new JTextField(20);
jt2=new JTextField(20);
jt4=new JTextField(20);
lb=new JLabel("用户名:");
lb0=new JLabel("姓名:");
lb1=new JLabel("性别:");
lb2=new JLabel("地址:");
lb3=new JLabel("电话:");
lb4=new JLabel("E-mail:");
lb5=new JLabel("权限:");
lbda=new JLabel("<html><font color=red>资 料 完 善</font></html>");
Container con=getContentPane();
con.setLayout(new GridLayout(9,1));
for(int i=0;i<=7;i++)
{
p[i]=new JPanel();
p[i].setBackground(new Color(190,190,190));
}
p[0].add(lbda);
ppp=new JPanel();
ppp.setBackground(new Color(190,190,190));
ppp.add(lb);
ppp.add(jt);
p[1].add(lb0);
p[1].add(jt0);
p[2].add(lb1);
p[2].add(cbb);
p[3].add(lb2);
p[3].add(jt2);
p[4].add(lb3);
p[4].add(jt3);
p[5].add(lb4);
p[5].add(jt4);
p[6].add(lb5);
p[6].add(cbb2);
p[7].add(b1);
p[7].add(b2);
if(m.equals("0"))
{
cbb2.setVisible(false);
lb5.setVisible(false);
}
b1.addActionListener(this);
b2.addActionListener(this);
con.add(p[0]);
con.add(ppp);
con.add(p[1]);
con.add(p[2]);
con.add(p[3]);
con.add(p[4]);
con.add(p[5]);
con.add(p[6]);
con.add(p[7]);
super.setVisible(true);
super.setSize(400,500);
// super.setResizable(false);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
{
String sss=(String)cbb.getSelectedItem();
String ss=(String)cbb2.getSelectedItem();
int s1;
if(cbb2.getSelectedIndex()==0)
{
s1=1;
}
else
s1=0;
try
{
String sq="update name1 set xm ='"+jt0.getText()+"',xb='"+sss+"',dz='"+jt2.getText()+"',dh='"+jt3.getText()+"',[E-mail]='"+jt4.getText()+"',qx='"+s1+"' where name ='"+jt.getText()+"' ";
String url="jdbc:odbc:Test";
Connection con=DriverManager.getConnection(url);
Statement s=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
s.executeUpdate(sq);
JOptionPane.showMessageDialog(null,"更新成功");
this.dispose();
}
catch(Exception sqle)
{
System.out.println("code has error!");
}
}
else if(e.getSource()==b2)
{
this.dispose();
}
}
public static void main(String args[])
{
new ZiliaoWanshan2("Admin","1");
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -