用eclipse连接Navicat后创建可视化界面的增删改查操作

 连接成功过后，建立如图所示的包和类。

 BLL  中students代码如下：

package BLL;

public class students {

}

BLL  中users代码如下：

package BLL;

import java.sql.SQLException;

public class users {
	
	DAO.users dao=new DAO.users();
			
	public String getPasswordByName(String name){

    return  dao.getPasswordByName(name);
		
	}
	public model.users getUserByName(String name)throws SQLException {
		return dao.getUserByName(name);
	}
	public int addUsers(model.users one) {
		// TODO Auto-generated method stub
		return dao.addUsers(one);
	}	
	
	
	public int upUsers(model.users one) {
		return dao.upUsers(one);
	}
		
	
	
	public int deUsers(model.users one) {
		// TODO Auto-generated method stub
		return dao.deUsers(one);

	}
		
	
	}

DAO中dbhelper代码：

package DAO;
import java.sql.*;
public class dbhelper { 
	//连接到数据库服务器
	public static Connection getConnection() {    
        Connection conn = null;
        try {
            String driver = "com.mysql.jdbc.Driver"; // 数据库驱动
            String url = "jdbc:MYSQL://localhost:3306/studb";//数据库
            String user = "root"; // 自己数据库的用户名
            String password = "123456"; // 自己数据库的用户对应的密码
            Class.forName(driver);// 加载数据库驱动
            if (null == conn) {
            	conn = DriverManager.getConnection(url, user, password);
            }
        } catch (ClassNotFoundException e) {
            System.out.println("Sorry,can't find the Driver!");
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        } 
        return conn;
    } 
	//增删改【Add、Del、Update】，实现数据的增删改
    public static int executeNonQuery(String sql) throws SQLException {
        int result = 0;
        Connection conn = null;
        Statement stmt = null;
        try {
            conn = getConnection();
            stmt = con