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();
}
}