连接数据库实现登录页面增删改查

1、创建用户

创建用户的id 登录名和密码

package model;

public class User {
private int id;
private String name;
private String psw;
public User(int id, String name, String psw) {
	super();
	this.id = id;
	this.name = name;
	this.psw = psw;
	
}
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public String getPsw() {
	return psw;
}
public void setPsw(String psw) {
	this.psw = psw;
}

}

2、连接数据库

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Jbutil {
	static String url="jdbc:mysql://localhost:3306/db_shop";
	static String user="root";
	static String password="root";
	static {
		try {Class.forName("com.mysql.jdbc.Driver");//加载数据库的驱动程序才能给数据库链接
		
		}catch(ClassNotFoundException e) {
			e.printStackTrace();
			
		}
		
	}
	public static Connection getCon() {
		Connection con=null;//用来访问数据库的应用程序接口
		try {
			
			con=DriverManager.getConnection(url,user,password);
			
			
		}
		catch(SQLException e) {
			e.printStackTrace();
		}
		return con;
	}

关闭数据库

public static void close(Connection con,Statement st,ResultSet rs) {//Statement在数据库链接的基础上发送sql语句Resultset返回一种对象储存查询结果，具有储存功能
		try {
			if(rs!=null) {
				rs.close();
				
			}
			if(st!=null) {
				st.close();
				
			}
			if(con!=null) {
				con.close();
				
			}
			
		}catch(SQLException e) {
			e.printStackTrace();
			
		}
		
	}
}

3、创建接口

创建接口的目的是：
提供简单、规范性 ，提高维护、拓展性 ，增强安全、严密性

package daointerface;

import model.User;

public interface Userdaointer {
	boolean insert(User user);
	boolean delete(String uid);
	boolean delete(User user);
	boolean update(User user);
	User query(String uid);
	
}

4、创建类连接接口并实现增删改查

package imple;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import daointerface.Userdaointer;

import model.User;
import util.Jbutil;

public class UserDaoimpl implements Userdaointer {

	public boolean insert(User user) {
		// TODO Auto-generated method stub
		
	int id =user.getId();
		String name=user.getName();
		String psw =user.getPsw();
	
		Connection con=Jbutil.getCon();
		String sql="insert into admin_info1 values('"+id+"','"+name+"','"+psw+"')";
		Statement st=null;
		int x=0;
		try {st = con.createStatement();
		x=st.executeUpdate(sql);
			
			
		} 
		
		catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			Jbutil.close(con,st,null);
			
		}
		if(x==1) {
			return true;
			
		}
		
		return false;
	}

	public boolean delete(String name) {
		// TODO Auto-generated method stub
		String sql="delete from admin_info1 where name='"+name+"'";
		Connection con=Jbutil.getCon();
		Statement st=null;
		int x=0;
		try {
			st=con.createStatement();
			x=st.executeUpdate(sql);
			
			
		}catch(SQLException e) {
			
			e.printStackTrace();
		}
		finally {
			Jbutil.close(con,st,null);
			
		}
		if(x==1) {
			return true;
			
		}
		
		return false;
		
	}

	public boolean delete(User user) {
		// TODO Auto-generated method stub
		String name=user.getName();
		String sql="delete from admin_info1 where uid='"+name+"'";
		Connection con=Jbutil.getCon();
		Statement st=null;
		int x=0;
		try {
			st=con.createStatement();
			x=st.executeUpdate(sql);
			
			
		}catch(SQLException e) {
			e.printStackTrace();
			
		}	
		finally {
			Jbutil.close(con,st,null);
			
		}
		if(x==1) {
			return true;
			
		}		
					return false;
	}

	public boolean update( User user) {
		// TODO Auto-generated method stub
		
	    int id=user.getId();
		String name=user.getName();
		String psw=user.getPsw();
		String sql="update admin_info1 set id='"+id+"',name='"+name+"',psw='"+psw+"'where name='"+name+"'";
		Connection con=Jbutil.getCon();
		Statement st=null;
		int x=0;
		try {
			st=con.createStatement();
			x=st.executeUpdate(sql);
			
			
		}catch(SQLException e) {
			e.printStackTrace();
			
		}	
		finally {
			Jbutil.close(con,st,null);
			
		}
		if(x==1) {
			return true;
			
		}		
		return false;
	}

	public User query(String name1) {
		// TODO Auto-generated method stub
				String sql="select * from admin_info1 where name'"+name1+"'";
				Connection con=Jbutil.getCon();
				Statement st=null;
				ResultSet rs=null;
			    int id=(Integer) null;
				String name=null;
				String psw=null;
			
				try {
					st = con.createStatement();
					rs=st.executeQuery(sql);
					if(rs==null) {
						return null;
					}
					while(rs.next()) {
						
						id=rs.getInt(1);
						
						name=rs.getString(2);
					
					psw=rs.getString(3);
						
						
					}
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				if(name==null) {
					return null;
				}
				
				User user=new User(id,name,psw);
				Jbutil.close(con, st, rs);
			
				return user;
	}
	



}