java使用JFrame连接mysql数据库，实现简单登陆。

package cn.entity;

//用户实体类
public class Users {
    private int Id;
    private String Name;
    private String Password;
    
	public int getId() {
		return Id;
	}
	public void setId(int id) {
		Id = id;
	}
	public String getName() {
		return Name;
	}
	public void setName(String name) {
		Name = name;
	}
	public String getPassword() {
		return Password;
	}
	public void setPassword(String password) {
		Password = password;
	}
}

package cn;

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

import cn.manager.UsersManager;

//登陆面板
public class Login extends JFrame{
  private JPanel panel;
  private JLabel lblName;
  private JLabel lblPassword;
  private JTextField txtName;
  private JPasswordField txtPassword;
  private JPanel panel2;
  private JButton btnLogin;
  private JButton btnReset;
  
  public Login(){
	  setTitle("登陆页面");
	  panel=new JPanel();
	  lblName=new JLabel("用户名:");
	  txtName=new JTextField(10);
	  lblName.setHorizontalAlignment(JLabel.CENTER);
	  panel.add(lblName);
	  panel.add(txtName);
	  
	  lblPassword=new JLabel("密码:");
	  txtPassword=new JPasswordField(10);
	  lblPassword.setHorizontalAlignment(JLabel.CENTER);
	  panel.add(lblPassword);
	  panel.add(txtPassword);
	  GridLayout g=new GridLayout();//网格布局
	  panel.setLayout(g);//将panel设置为网格布局
	  g.setColumns(2);//设置行
	  g.setVgap(20);//设置水平间距
	  g.setHgap(20);//设置垂直间距
	  
	  panel2=new JPanel();
	  btnLogin=new JButton("登陆");
	  /**
	   * 给登陆按钮添加监听事件
	   * 当按钮被点击时时间被触发
	   * */
	  btnLogin.addActionListener(new ActionListener() {
		@Override
		public void actionPerformed(ActionEvent e) {
			UsersManager um=new UsersManager();//用户管理
			boolean b=um.Login(txtName.getText(), txtPassword.getText());
			
			if(b){//登陆成功,跳转页面
				JOptionPane.showMessageDialog(null, "登陆成功!");
				Index i=new Index();//登陆成功跳转到主页面
			}else{//登陆失败
			    JOptionPane.showMessageDialog(null, "登陆失败!");
			}
		}
	  });
	  btnReset=new JButton("重置");
	  /**
	   * 点击重置按钮时，将文本框中的值设置为空
	   * */
	  btnReset.addActionListener(new ActionListener() {
		@Override
		public void actionPerformed(ActionEvent e) {
			txtName.setText("");
			txtPassword.setText("");
		}
	});
	  panel2.add(btnLogin);
	  panel2.add(btnReset);
	  //将panel2添加到窗体中，并且设置pane2在窗体中的布局样式
	  this.add(panel2,BorderLayout.SOUTH);
	  //将panel添加到窗体中,并且设置panel在窗体中的布局样式
	  this.add(panel,BorderLayout.NORTH);
	  setVisible(true);
	  setBounds(400, 200, 500, 300);
  }
  
  public static void main(String[] args){
	  Login login=new Login();
  }
}

package cn.manager;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import cn.util.UsersUtil;

//用户登陆
public class UsersManager {
	UsersUtil util=new UsersUtil();
	/**
	 * 用户登陆功能
	 * */
	public boolean Login(String name,String pwd){
		boolean flag=false;
		Connection con=null;
		Statement stmt=null;
		ResultSet rs=null;
		con=util.getConnection();
		
		try {
			stmt=con.createStatement();//预定义语句
			//数据库查询语句(根据用户名和密码)
			String sql="select * from Users where Name='"+name+"' and Password='"+pwd+"'";
			rs=stmt.executeQuery(sql);//执行查询语句
			//rs中有数据，则将标记改为true
			if(rs.next()){
				flag=true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
		    util.Close(rs, stmt, con);
		}
		return flag;
	}
}

package cn;

import java.awt.BorderLayout;
import java.awt.CardLayout;
import java.awt.Color;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTree;
import javax.swing.tree.DefaultMutableTreeNode;

import cn.entity.Employee;
import cn.frame.EmployeeAdd;

/**
 * CRM系统主页面
 * */
public class Index extends JFrame{
	private JPanel leftPanel;
	private JTree tree;
	private DefaultMutableTreeNode root;
	private DefaultMutableTreeNode material,employeeNode,departmentNode,jobNodeNode;
	private DefaultMutableTreeNode school,activityNode,managerNode;
    private DefaultMutableTreeNode user,studentNode,classNode;
    private DefaultMutableTreeNode information,regionNode,countNode;
	private DefaultMutableTreeNode system,repwdNode,journalNode;
	//卡片布局
    private CardLayout card=new CardLayout();
	private JPanel mainPanel;//主面板
	
	public Index(){
		setTitle("CRM系统");
		leftPanel=new JPanel();
		root=new DefaultMutableTreeNode("成都网络CRM系统");
		/**1.资料管理*/
		material=new DefaultMutableTreeNode("资料管理");
		employeeNode=new DefaultMutableTreeNode("员工管理");
		departmentNode=new DefaultMutableTreeNode("部门管理");
		jobNodeNode=new DefaultMutableTreeNode("职位管理");
		material.add(employeeNode);
		material.add(departmentNode);
		material.add(jobNodeNode);
		/**1.资料管理*/
		
		/**2.学校管理*/
		school=new DefaultMutableTreeNode("学校管理");
		activityNode=new DefaultMutableTreeNode("学校活动");
		managerNode=new DefaultMutableTreeNode("学校管理");
		school.add(activityNode);
		school.add(managerNode);
		/**2.学校管理*/
		
		/**3.用户管理*/
		user=new DefaultMutableTreeNode("用户管理");
		studentNode=new DefaultMutableTreeNode("学生管理");
		classNode=new DefaultMutableTreeNode("班级管理");
		user.add(studentNode);
		user.add(classNode);
		/**3.用户管理*/
		
		/**4.统计管理*/
		information=new DefaultMutableTreeNode("统计管理");
		regionNode=new DefaultMutableTreeNode("地区统计");
		countNode=new DefaultMutableTreeNode("学校统计");
		information.add(regionNode);
		information.add(countNode);
		/**4.统计管理*/
		
		/**5.系统管理*/
		system=new DefaultMutableTreeNode("系统管理");
		repwdNode=new DefaultMutableTreeNode("修改密码");
		journalNode=new DefaultMutableTreeNode("日志一览");
		system.add(repwdNode);
		system.add(journalNode);
		/**5.系统管理*/
		
		root.add(material);
		root.add(school);
		root.add(user);
		root.add(information);
		root.add(system);
		
		tree=new JTree(root);
		leftPanel.add(tree);
		
	    mainPanel=new JPanel();
	    mainPanel.setLayout(card);
	    //添加右边面板,并且设置面板位置
	    this.add(leftPanel,BorderLayout.WEST);
	    //添加主面板并设置位置
	    this.add(mainPanel,BorderLayout.CENTER);
	    //设置左边面板背景色
	    leftPanel.setBackground(new Color(224,255,255));
	    //设置主面板背景色
	    mainPanel.setBackground(new Color(240,255,255));
	    
		setVisible(true);//设置是否可见
		setBounds(200, 100, 1000, 1000);//设置大小及位置
		//点击时关闭窗口
		setDefaultCloseOperation(EXIT_ON_CLOSE);
	}
    public static void main(String[] args){
	   Index i=new Index();
    }
}