java连数据库实现删除用户信息功能和更改用户信息功能
**
重点:
**更新信息时,应该建几个方法,每一个字段更改是一个方法,如果都在一个方法里,不被更改的字段,就会变成空值了。
对每一个字段更改时,调用相应的方法。
类:
Delete类、
UpDate类、
Main类、
Delete类:
public class Delete {
public ArrayList<Join> delete(String name) {
ArrayList<Join> list=new ArrayList<Join>();
String sql="select * from info where name='"+name+"'";
Tool tool=new Tool();
ArrayList<Map<String,Object>> listdb=tool.query1(sql);
for (int i = 0; i < listdb.size(); i++) {
Join temp=new Join();
String namedb=listdb.get(i).get("name").toString();
temp.setName(namedb);
list.add(temp);
}
return list;
}
public int Upinfo(String name)
{
int k=0;
Tool tool= new Tool();
String sql="delete from info where name='"+name+"'";
k=tool.update(sql);
return k;
}
}
UpDate类:
public class UpDate {
public ArrayList<Join> Change(String name) {
ArrayList<Join> list=new ArrayList<Join>();
String sql="select * from info where name='"+name+"'";
Tool tool=new Tool();
ArrayList<Map<String, Object>> listdb=tool.query1(sql);
for (int i = 0; i < listdb.size(); i++) {
Join temp=new Join();
String namedb=listdb.get(0).get("name").toString();
temp.setName(namedb);
list.add(temp);
}
return list;
}
public int Upinfo(String name,String phone,String id,String birth)
{
int k=0;
Tool tool=new Tool();
String sql="update info set phnumber='"+phone+"',id='"+id+"',birth='"+birth+"' where name='"+name+"'";
k=tool.update(sql);
return k;
}
}
Main类:
1、删除按钮监听:
jButton5.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
final String name2=jTextField8.getText().toString().trim();
if (name2.equals("")) {
System.out.println("输入为空!");
return;
}
Delete delete=new Delete();
ArrayList<Join> list=delete.delete(name2);
if (list!=null&&list.size()>0) {
int k=delete.Upinfo(name2);
System.out.println("删除成功!");
}
else {
System.out.println("删除失败!");
}
}
});
2、更改按钮监听:
jButton6.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
final String name3=jTextField9.getText().toString();
final String phone1=jTextField10.getText().toString();
final String id1=jTextField11.getText().toString();
final String birth1=jTextField12.getText().toString();
UpDate upDate=new UpDate();
ArrayList<Join> list=upDate.Change(name3);
if (list!=null&&list.size()>0) {
int k=upDate.Upinfo(name3,phone1, id1, birth1);
System.out.println("更改成功!");
}
else {
System.out.println("更改失败!");
}
}
});