急啊!!!!!!!!!为什么更新数据库后,但是数据库里面的仍然没有变\

[热烈的红颜]

class SelfModel extends AbstractTableModel
{
private Vector vector1 = new Vector(),vector2 = new Vector();
ResultSet rs;
public SelfModel()
{
Vector v;
vector2.add("职工编号");
vector2.add("姓名");
vector2.add("性别");
vector2.add("工资");
rs = new DataProcess("Message","Select * From Person").deal();
try{
while (rs.next())
{
v = new Vector();
v.add(rs.getString("ID"));
v.add(rs.getString("NAME"));
v.add(rs.getString("SEX"));
v.add(rs.getString("SALARY"));
vector1.add(v);
}
}catch(Exception e){ e.printStackTrace();
}
}
public int getRowCount()
{
return vector1.size();
}
public int getColumnCount()
{
return vector2.size();
}
public String getColumnName(int col)
{
return (String)vector2.get(col);
}

public Object getValueAt(int row, int column)
{
return ((Vector)vector1.get(row)).get(column);
}
}
class ManagerClassSub2 extends JPanel implements ActionListener//管理员工的工资
{
private JPanel jp1,jp2;
private JLabel jl1,jl2,jl3,jl4;
private JButton jb1,jb2,jb3;
private JTextField jtf1,jtf2,jtf3,jtf4;
private JTable jtb;
private JScrollPane jsp;
public ManagerClassSub2()
{
this.setLayout(null);
jp1 = new JPanel();
jp1.setBorder(BorderFactory.createBevelBorder(BevelBorder.RAISED,Color.red,Color.gray));
jp2 = new JPanel();
jp2.setBorder(BorderFactory.createTitledBorder("查询结果"));
jp1.setBounds(0,0,500,100);
jp2.setBounds(0,100,500,400);
jp1.setLayout(null);
jp2.setLayout(null);
jl1 = new JLabel("职工编号:");
jl2 = new JLabel("姓名：");
jl4 = new JLabel("工资:");
jl3 = new JLabel("性别:");
jtf1 = new JTextField();
jtf2 = new JTextField();
jtf3 = new JTextField();
jtf4 = new JTextField();
jtf1.setEditable(false);
jtf2.setEditable(false);
jtf3.setEditable(false);
jl1.setBounds(10,20,70,20);
jtf1.setBounds(85,20,50,20);
jl2.setBounds(200,20,70,20);
jtf2.setBounds(280,20,100,20);
jl3.setBounds(10,50,80,20);
jtf3.setBounds(85,50,40,20);
jl4.setBounds(200,50,70,20);
jtf4.setBounds(280,50,80,20);
jp1.add(jl1);
jp1.add(jtf1);
jp1.add(jl2);
jp1.add(jtf2);
jp1.add(jl3);
jp1.add(jtf3);
jp1.add(jl4);
jp1.add(jtf4);
SelfModel self = new SelfModel();
jtb= new JTable(self);
jtb.setBackground(Color.ORANGE);
jtb.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jtb.addMouseListener(new MouseAdapter()
{
public void mouseClicked(MouseEvent e)
{

jtf1.setText(new String().valueOf(jtb.getValueAt(jtb.getSelectedRow(),0)));
jtf2.setText(new String().valueOf(jtb.getValueAt(jtb.getSelectedRow(),1)));
jtf3.setText(new String().valueOf(jtb.getValueAt(jtb.getSelectedRow(),2)));
jtf4.setText(new String().valueOf(jtb.getValueAt(jtb.getSelectedRow(),3)));
}
});
jsp = new JScrollPane(jtb);
jsp.setBounds(0,20,350,350);
jb1 = new JButton("查询");
jb2 = new JButton("输入");
jb3 = new JButton("查看工资分布图");
jb1.addActionListener(this);
jb2.addActionListener(this);
jb3.addActionListener(this);
jb1.setBounds(360,20,100,25);
jb2.setBounds(360,55,100,25);
jb3.setBounds(360,90,100,25);
jp2.add(jsp);
jp2.add(jb1);
jp2.add(jb2);
jp2.add(jb3);
add(jp1,this);
add(jp2,this);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==jb1)
{}
if(e.getSource()==jb2)
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection cnn =DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.6:1433;databasename=Message","sa","112233");
PreparedStatement pstmt = cnn.prepareStatement("UPDATE Person SET SALARY=? WHERE NAME=?");
System.out.println(jtf1.getText()+jtf4.getText());
pstmt.setString(1,jtf4.getText());
pstmt.setString(2,jtf1.getText());
pstmt.executeUpdate();
pstmt.close();
cnn.close();
}catch(Exception xe){xe.printStackTrace();}
System.out.println("fsdfsfsdfsdfsdf");
} if(e.getSource()==jb3)
{
Dialog dialog = new Dialog(TestDemo.jf,"工资分布图表",true);
dialog.addWindowListener(
new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
e.getWindow().setVisible(false);
e.getWindow().dispose();
}
}
);
dialog.add(new Matlab());
dialog.setSize(400,400);
dialog.setLocation(200,200);
dialog.setVisible(true);

}
}

}

[destonymi]

是不是没有提交数据？