我的无法更新啊,d的值一直是0,那些值可以得到的
究竟是怎么回事。。请大家帮帮忙
private Connection con;
public ZhuCeBean()
{
con= Connecter.getConnection();
}
//修改用户
public void alter(String sid,String upwd,String age,String oicq,String email,String city)
{
try
{
System.out.println("abcd");
PreparedStatement ps1=con.prepareStatement("update users set upwd=?, age=?, oicq=?, email=?, city=? where sid=?");
ps1.setString(1, upwd);
ps1.setString(2, age);
ps1.setString(3, oicq);
ps1.setString(4, email);
ps1.setString(5, city);
ps1.setString(6, sid);
int d=ps1.executeUpdate();
System.out.println(d);
if(d>0)
{
JOptionPane.showMessageDialog(null,"更新成功,现在转入登录界面重新登录!");
System.out.println("abcdefg");
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
究竟是怎么回事。。请大家帮帮忙
private Connection con;
public ZhuCeBean()
{
con= Connecter.getConnection();
}
//修改用户
public void alter(String sid,String upwd,String age,String oicq,String email,String city)
{
try
{
System.out.println("abcd");
PreparedStatement ps1=con.prepareStatement("update users set upwd=?, age=?, oicq=?, email=?, city=? where sid=?");
ps1.setString(1, upwd);
ps1.setString(2, age);
ps1.setString(3, oicq);
ps1.setString(4, email);
ps1.setString(5, city);
ps1.setString(6, sid);
int d=ps1.executeUpdate();
System.out.println(d);
if(d>0)
{
JOptionPane.showMessageDialog(null,"更新成功,现在转入登录界面重新登录!");
System.out.println("abcdefg");
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//增加新用户
public void addusers(String sid,String upwd,String age,String oicq,String email,String city)
{
try
{
//获得预编译查询器
PreparedStatement ps=con.prepareStatement("insert into users values(?,?,?,?,?,?)");
ps.setString(1, sid);
ps.setString(2, upwd);
ps.setString(3, age);
ps.setString(4, oicq);
ps.setString(5, email);
ps.setString(6, city);
int r=ps.executeUpdate();
if(r>0)
{
JOptionPane.showMessageDialog(null,"恭喜您,成功注册,现在转入登录界面重新登录!");
}
}
catch (SQLException e)
{
JOptionPane.showMessageDialog(null, "该用户名已被注册,请重新输入!");
}
}
sid是用户名啊,而且是唯一的。。
我刚按照2楼的试过了,sid值已经传过来了,是表中存在的sid