java连数据库实现插入用户信息功能和查找用户信息功能
插入信息功能类似于注册功能,都是先看是否存在用户名,存在才可以注册;
然后进行插入信息;
所有查看用户名是否存在的方法都可以提出来作为一个公共方法;
类:
Join类、
JoinOp类、
Search类、
Main主类、
Join类:
public class Join {
//个人信息表的数据
private String name;
private String phnumber;
private String id;
private String birth;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPhnumber() {
return phnumber;
}
public void setPhnumber(String phnumber) {
this.phnumber = phnumber;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getBirth() {
return birth;
}
public void setBirth(String birth) {
this.birth = birth;
}
}
JoinOp类:
public ArrayList<Join> Charu(String name)
{
//插入系信息方法
ArrayList<Join> list =new ArrayList<Join>();
Tool a=new Tool();
String sql="select * from data where name='"+name+"'";
ArrayList<Map<String, Object>> listdb=a.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,String phnumber,String id,String birth)
{
Tool a=new Tool();
String sql="insert into info(name,phnumber,id,birth) values('"+name+"','"+phnumber+"','"+id+"','"+birth+"')";
int k=a.update(sql);
return k;
}
}
Search类:
重点:
在主类里输出信息十,定义字段时,用到的方法是getName,getBirth, 因为list 是ArrayList<信息类>的类型,里边有get方法
public class Search {
//查询类
public ArrayList<Join> find(String name)
{//查找方法
ArrayList<Join> list=new ArrayList<Join>();
Tool a=new Tool();
String sql="select * from info where name='"+name+"'";
ArrayList<Map<String, Object>> listdb=a.query1(sql);
for (int i = 0; i < listdb.size(); i++) {
Join temp=new Join();
String dbname=listdb.get(i).get("name").toString();
String dbphnumber=listdb.get(i).get("phnumber").toString();
String dbid=listdb.get(i).get("id").toString();
String dbbirth=listdb.get(i).get("birth").toString();
//从数据库获取信息
temp.setName(dbname);
temp.setPhnumber(dbphnumber);
temp.setId(dbid);
temp.setBirth(dbbirth);
//传给temp对象
list.add(temp);
//添加到list中
}
return list;
}
}
Main类:
1、插入按钮监听:
jButton.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
final String name=jTextField1.getText().toString().trim();
final String phnumber=jTextField2.getText().toString().trim();
final String id=jTextField3.getText().toString().trim();
final String birth=jTextField4.getText().toString().trim();
if(name.equals(""))
{
System.out.println("用户名为空");
return;
}
if(phnumber.equals(""))
{
System.out.println("手机号为空");
return;
}
if(id.equals(""))
{
System.out.println("身份证号为空");
return;
}
if(birth.equals(""))
{
System.out.println("出生日期为空");
return;
}
JoinOP joinOP=new JoinOP();
ArrayList<Join> list =joinOP.Charu(name);
if (list!=null&&list.size()>0) {
int k=joinOP.Upinfo(name, phnumber, id, birth);
System.out.println("插入成功");
}
else {
System.out.println("用户已存在,不能插入信息!");
}
}
2、查询按钮监听:
JButton jButton4=new JButton("查询");
jButton4.setBounds(250, 250, 80, 30);
jButton4.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
final String name1=jTextField7.getText().toString().trim();
if(name1.equals(""))
{
System.out.println("用户名为空");
return;
}
Search search=new Search();
ArrayList<Join> list=search.find(name1);
//个人信息表
if (list!=null&&list.size()>0) {
String dbname=list.get(0).getName();
String dbphnumber=list.get(0).getPhnumber();
String dbid=list.get(0).getId();
String dbbirth=list.get(0).getBirth();
System.out.println("用户名名:"+dbname);
System.out.println("手机号:"+dbphnumber);
System.out.println("身份证号:"+dbid);
System.out.println("出生日期:"+dbbirth);
}
else {
System.out.println("用户不存在");
}