客户信息管理系统(说明文档)

客户信息管理

一、客户类

package com.my.bean;

//客户类

public class Customer {

private int id;

private String customName;

private String customPassword;

private int age;

private String address;

private String phone;

private String email;

public String getCustomName() {

return customName;

}

public void setCustomName(String customName) {

this.customName = customName;

}

public String getCustomPassword() {

return customPassword;

}

public void setCustomPassword(String customPassword) { this.customPassword = customPassword;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

public String getPhone() {

return phone;

}

public void setPhone(String phone) {

this.phone = phone;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

@Override

public String toString() {

// TODO Auto-generated method stub

r eturn this.id+"\t"+this.customName+"\t"+this.customPassword+

"\t"+this.age+"\t"+this.address+"\t"+this.phone+"\t"+this.email; }

}

二、数据库连接类

package com.my.db;

import java.sql.*;

//数据库连接类

public class DBCon {

private Connection con;

public Connection getConnection(){

//方法一：JDBC－ODBC桥接

/*try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载注册数据库驱动

con=DriverManager.getConnection("jdbc:odbc:db","sa","sa");//建立连接

} catch (SQLException ex) {

System.out.println("数据库连接不成功！");

ex.printStackTrace();

} catch (ClassNotFoundException ex) {

System.out.println("驱动找不到！");

ex.printStackTrace();

}*/

//方法二：纯粹的JAVA驱动

try {

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//加载注册数据库驱动

con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost :1433;databaseName=db","sa","sa");//建立连接

} catch (SQLException ex) {

System.out.println("数据库连接不成功！");

ex.printStackTrace();

} catch (ClassNotFoundException ex) {

System.out.println("驱动找不到！");

ex.printStackTrace();

}

return con;

}

}

三、客户信息处理接口

package com.my.dao;

import java.util.List;

import com.my.bean.Customer;

//客房信息处理接口

public interface CustomerDAO {

public boolean addCustomerInfo(Customer c);//添加客户信息

public boolean deleteCustomerInfo(int id);//根据编号删除客户信息

public boolean modifyCustomerInfo(int id,Customer c);//根据编号修改客户信息

public Customer getCustomer(int id);//根据编号查询客户信息

public List getCustomer(String name);//根据姓名查询客户信息

public List selectAll();//查询所有客户信息

}

四、客户信息处理业务类

package com.my.impl;

import java.sql.*;

import java.util.*;

import com.my.bean.Customer;

import com.my.dao.CustomerDAO;

import com.my.db.DBCon;

public class CustomerInfoImpl implements CustomerDAO{

private Connection con;

private Statement st;

private PreparedStatement pstmt;

private ResultSet rs;

private DBCon db;

public CustomerInfoImpl() {

db=new DBCon();

}

。。。。。。//实现接口中的方法，见下列代码

1、添加客户信息

//添加客户信息

public boolean addCustomerInfo(Customer c){

boolean result=false;

con=db.getConnection();

String sql="insert into customer values(?,?,?,?,?,?)";

try {

pstmt=con.prepareStatement(sql);

pstmt.setString(1, c.getCustomName());

pstmt.setString(2, c.getCustomPassword());

pstmt.setInt(3, c.getAge());

pstmt.setString(4, c.getAddress());

pstmt.setString(5, c.getPhone());

pstmt.setString(6, c.getEmail());

int i=pstmt.executeUpdate();

if(i>0){

result=true;

}else{

result=false;

}

if (pstmt != null)

pstmt.close();

if (con != null)

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return result;

}

2、删除客户信息

//删除客户信息

public boolean deleteCustomerInfo(int id){

boolean result=false;

con=db.getConnection();

String sql="delete from customer where id=?";

try {

pstmt=con.prepareStatement(sql);

pstmt.setInt(1, id);

int i=pstmt.executeUpdate();

if(i>0){

result=true;

}else{

result=false;

}

if (pstmt != null)

pstmt.close();

if (con != null)

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return result;

}

3、根据客户编号查询客户信息

//根据客户编号查询客户信息

public Customer getCustomerInfo(int id){

Customer c=new Customer();

con=db.getConnection();

String sql="select * from customer where id=?";

try {

pstmt=con.prepareStatement(sql);

pstmt.setInt(1, id);

rs=pstmt.executeQuery();

while (rs.next()) {

c.setId(rs.getInt(1));

c.setCustomName(rs.getString(2));

c.setCustomPassword(rs.getString(3));

c.setAge(rs.getInt(4));

c.setAddress(rs.getString(5));

c.setPhone(rs.getString(6));

c.setEmail(rs.getString(7));

}

if(rs!=null)

rs.close();

if(pstmt!=null)

pstmt.close();

if(con!=null)

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return c;

}

4、根据客户姓名查询客户信息

public List getCustomer(String name) {

List list=new ArrayList();

con=db.getConnection();

String sql="select * from customer where customName=?";

try {

pstmt=con.prepareStatement(sql);

pstmt.setString(1, name);

rs=pstmt.executeQuery();

while(rs.next()){

Customer c=new Customer();

c.setId(rs.getInt(1));

c.setCustomName(rs.getString(2));

c.setCustomPassword(rs.getString(3));

c.setAge(rs.getInt(4));

c.setAddress(rs.getString(5));

c.setPhone(rs.getString(6));

c.setEmail(rs.getString(7));

list.add(c);

}

if(rs!=null) rs.close();

if(pstmt!=null) pstmt.close();

if(con!=null) con.close();

} catch (SQLException ex) {

Logger.getLogger(CustomerInfoImp.class.getName()).log(Level.SEVERE, null, ex);

}

return list;

}

5、根据客户编号修改客户信息

//根据编号修改客户信息

public boolean modifyCustomerInfo(int id,Customer c){

boolean result=false;

con=db.getConnection();

String sql="update customer set customName=?,customPassword=?," +

"age=?,address=?,phone=?,email=? where id=?";

try {

pstmt=con.prepareStatement(sql);

pstmt.setString(1, c.getCustomName());

pstmt.setString(2, c.getCustomPassword());

pstmt.setInt(3, c.getAge());

pstmt.setString(4, c.getAddress());

pstmt.setString(5, c.getPhone());

pstmt.setString(6, c.getEmail());

pstmt.setInt(7, id);

int i=pstmt.executeUpdate();

if(i>0){

result=true;

}else{

result=false;

}

if (pstmt != null)

pstmt.close();

if (con != null)

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return result;

}

6、查询所有客户信息

//查询所有客户信息

public List selectAll(){

List list=new ArrayList();

con=db.getConnection();

String sql="select * from customer";

try {

st=con.createStatement();

rs=st.executeQuery(sql);

while(rs.next()){

Customer c=new Customer();

c.setId(rs.getInt(1));

c.setCustomName(rs.getString(2));

c.setCustomPassword(rs.getString(3));

c.setAge(rs.getInt(4));

c.setAddress(rs.getString(5));

c.setPhone(rs.getString(6));

c.setEmail(rs.getString(7));

list.add(c);

}

if (rs != null)

rs.close();

if (pstmt != null)

pstmt.close();

if (con != null)

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return list;

}

五、图形界面

1、用户登录

源代码：Login.java

public class Login extends javax.swing.JFrame {

private Connection con;

private PreparedStatement pstmt;

private DBCon db=new DBCon();

private ResultSet rs;

/**

* Creates new form Login

*/

public Login() {

initComponents();

}

。。。。。

//退出按钮

private void jButtonCancleActionPerformed(java.awt.event.ActionEvent evt) { jTextFieldUserName.setText("");

jPassword.setText("");

System.out.println("退出系统");

System.exit(0);

}

//确定按钮

private void jButtonOKActionPerformed(java.awt.event.ActionEvent evt) { String userNameV alue = jTextFieldUserName.getText().trim();

String passValue = new String(jPassword.getPassword());

if (userNameValue.equals("") || passValue.equals("")) {

JOptionPane.showMessageDialog(this, "没有输入用户名或密码!");

} else {

int type = JOptionPane.YES_NO_OPTION;

if (isExistUser(userNameValue, passValue)) {

JOptionPane.showMessageDialog(this, "登录成功");

if (type == JOptionPane.YES_OPTION) {//按钮类型

MainFrame sm = new MainFrame();//界面切换

sm.setVisible(true);//主窗体可见

this.setVisible(false);

}

} else {

JOptionPane.showMessageDialog(this, "用户名或密码错误，请重新输入");

jTextFieldUserName.setText("");

jPassword.setText("");

}

}

}

//根据用户名查询用户是否存在

public boolean isExistUser(String userName,String password) {

boolean result=false;

try{

con=db.getConnection();

String sql="select * from login where userName=? and password=?";

pstmt=con.prepareStatement(sql);

pstmt.setString(1,userName);

pstmt.setString(2, password);

rs=pstmt.executeQuery();

if(rs.next()){

result=true;

}

if(rs!=null) rs.close();

if(pstmt!=null) pstmt.close();

if(con!=null) con.close();

}catch(SQLException e){

e.printStackTrace();

}

return result;

}

2、主界面

源码：MainFrame.java

public class MainFrame extends javax.swing.JFrame {

CustomerInfoImp cii;

Customer c;

Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); //得到屏幕的尺寸

public MainFrame() {

initComponents();

this.setSize(screenSize.width,screenSize.height);

}

……

//客户信息管理

private void ManagerItemActionPerformed(java.awt.event.ActionEvent evt) { CusManFrame ac;

ac = new CusManFrame();

ac.setVisible(true);

}

//关于我们

private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) { AboutUs au=new AboutUs();

au.setVisible(true);

}

//根据姓名进行查询

private void findOnNameActionPerformed(java.awt.event.ActionEvent evt) { FindOnName fn=new FindOnName();

fn.setVisible(true);

}

//根据编号进行查询

private void findOnNOActionPerformed(java.awt.event.ActionEvent evt) { String idstr=JOptionPane.showInputDialog(this,"请输入要查找的编号：","输入对话框",https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

int id=new Integer(idstr);

cii=new CustomerInfoImp();

c=cii.getCustomer(id);

System.out.print(c);

if(c.getId()==0){

JOptionPane.showMessageDialog(this, "您要查找的客户不存在！");

}else{

FindOnID fr=new FindOnID(this);

fr.setVisible(true);

}

}

…….

3、客户信息管理

(1)客户信息管理主界面

源码：CusManFrame.java

public class CusManFrame extends javax.swing.JFrame {

private Connection con;

private Statement stmt;

private PreparedStatement pstmt;

private ResultSet rs;

private DBCon db;

int ID;

public CusManFrame() {

initComponents();

CustomerInfoImp cii=new CustomerInfoImp();

List list=cii.selectAll();

for (Iterator it = list.iterator(); it.hasNext();) {

Customer c = (Customer) it.next();

((DefaultTableModel) cusTable.getModel()).addRow((new Object[]{c.getId(), c.getCustomName(),

c.getAge(), c.getAddress(), c.getPhone(), c.getEmail()}));

}

}

…….

private void exitActionPerformed(java.awt.event.ActionEvent evt) {

this.setVisible(false);

}

//"添加"按钮的事件代码

private void addActionPerformed(java.awt.event.ActionEvent evt) {

AddCusFrame cf=new AddCusFrame();

cf.setVisible(true);

this.setVisible(false);

}

//"删除"按钮的事件代码

private void deleteActionPerformed(java.awt.event.ActionEvent evt) {

int[] a = cusTable.getSelectedRows();

for (int i = 0; i < a.length; i++) {

//删除数据库中的对应记录

int id = (Integer) (cusTable.getValueAt(a[i], 0));

System.out.println(id);

CustomerInfoImp cii = new CustomerInfoImp();

if (cii.deleteCustomerInfo(id)) {//调用方法将客户c从数据库中删除

JOptionPane.showConfirmDialog(this, "删除成功！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

} else {

JOptionPane.showConfirmDialog(this, "删除失败！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

}

((DefaultTableModel) cusTable.getModel()).removeRow(a[i]);//删除表格中的选定行

}

}

//修改客户信息

private void modifyActionPerformed(java.awt.event.ActionEvent evt) {

int i=cusTable.getSelectedRow();

ID=(Integer)(cusTable.getValueAt(i,0));

//打开修改客户信息窗口

ModifyCusFrame mf=new ModifyCusFrame(this);

mf.setVisible(true);

this.setVisible(false);

}

……

(2)添加客户信息界面

源码：AddCusFrame.java

public class AddCusFrame extends javax.swing.JFrame {

private Connection con;

private Statement stmt;

private PreparedStatement pstmt;

private ResultSet rs;

private DBCon db;

public AddCusFrame() {

initComponents();

db=new DBCon();

}

。。。。。。

//添加客户信息

private void addButtonActionPerformed(java.awt.event.ActionEvent evt) {

if (TextName.getText().equals("") || TextPass.getText().equals("") ||

TextAge.getText().equals("")) {

JOptionPane.showConfirmDialog(this, "姓名、密码或年龄不能为空！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

return;

}

//把界面上输入的各项信息赋给某一个客户c

Customer c = new Customer();

CustomerInfoImp cii = new CustomerInfoImp();

c.setCustomName(TextName.getText());

c.setCustomPassword(TextPass.getText());

c.setAge(new Integer(TextAge.getText()));

c.setAddress(TextAddress.getText());

c.setPhone(TextPhone.getText());

c.setEmail(TextEmail.getText());

if (cii.addCustomerInfo(c)) {//调用方法将客户c添加进去

JOptionPane.showConfirmDialog(this, "添加成功！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

} else {

JOptionPane.showConfirmDialog(this, "添加失败！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

}

//清空所有文本框

TextName.setText("");

TextPass.setText("");

TextAge.setText("");

TextAddress.setText("");

TextPhone.setText("");

TextEmail.setText("");

}

//关闭

private void cancleButtonActionPerformed(java.awt.event.ActionEvent evt) { this.setVisible(false);

CusManFrame ac=new CusManFrame();

ac.setVisible(true);

}

。。。。。。

(3)修改客户信息界面

源码：ModifyCusFrame.java

public class ModifyCusFrame extends javax.swing.JFrame {

CusManFrame cf;

CustomerInfoImp cii;

Customer c;

int id;

/**

* Creates new form ModifyCusFrame

*/

public ModifyCusFrame() {

initComponents();

}

public ModifyCusFrame(CusManFrame cf) throws HeadlessException { initComponents();

this.cf=cf;

id=this.cf.ID;

cii=new CustomerInfoImp();

c=cii.getCustomer(id);

this.TextName.setText(c.getCustomName());

this.TextPass.setText(c.getCustomPassword());

this.TextAge.setText(String.valueOf(c.getAge()));

this.TextAddress.setText(c.getAddress());

this.TextPhone.setText(c.getPhone());

this.TextEmail.setText(c.getEmail());

}

。。。。。。

//根据客户编号修改客户信息

private void modifyActionPerformed(java.awt.event.ActionEvent evt) {

c.setCustomName(TextName.getText());

c.setCustomPassword(TextPass.getText());

c.setAge(new Integer(TextAge.getText()));

c.setAddress(TextAddress.getText());

c.setPhone(TextPhone.getText());

c.setEmail(TextEmail.getText());

if (cii.modifyCustomerInfo(id, c)) {//调用方法修改客户信息

JOptionPane.showConfirmDialog(this, "修改成功！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

} else {

JOptionPane.showConfirmDialog(this, "修改失败！", "信息提示", JOptionPane.OK_OPTION, https://www.360docs.net/doc/119276202.html,RMA TION_MESSAGE);

}

}

//关闭

private void cancleActionPerformed(java.awt.event.ActionEvent evt) { this.setVisible(false);

CusManFrame ac=new CusManFrame();

ac.setVisible(true);

}

4、客户信息查询

（1）根据编号查询

源码：FindOnID.java

public class FindOnID extends javax.swing.JFrame {

MainFrame mf;

/**

* Creates new form FindOnName

*/

public FindOnID() {

initComponents();

}

public FindOnID(MainFrame mf) {

initComponents();

this.mf=mf;

Customer c=this.mf.c;

((DefaultTableModel) resultTable.getModel()).addRow((new Object[]{c.getId(), c.getCustomName(),

c.getAge(), c.getAddress(), c.getPhone(), c.getEmail()}));

}

（2）根据姓名查询

源码：

public class FindOnName extends javax.swing.JFrame {

/**

* Creates new form FindOnName

*/

public FindOnName() {

initComponents();

}

。。。。。。

//按照姓名进行查询

private void findActionPerformed(java.awt.event.ActionEvent evt) {

String name=TextName.getText().trim();

//清空表格里的内容

for(int i=resultTable.getRowCount()-1;i>=0;i--){

((DefaultTableModel) resultTable.getModel()).removeRow(i);

}

if(name.equals("")){

JOptionPane.showMessageDialog(this, "请输入您要查找的姓名");

}else{

List list=new ArrayList();

CustomerInfoImp cii = new CustomerInfoImp();

list = cii.getCustomer(name);

if (list.size() == 0) {

JOptionPane.showMessageDialog(this, "您要查找的客户不存在！");

} else {

for (Iterator it = list.iterator(); it.hasNext();) {

Customer c = (Customer) it.next();

((DefaultTableModel) resultTable.getModel()).addRow((new Object[]{c.getId(), c.getCustomName(),

c.getAge(), c.getAddress(), c.getPhone(),

c.getEmail()}));

}

}

}

}

private void cancleActionPerformed(java.awt.event.ActionEvent evt) {

this.setVisible(false);

}

。。。

5、帮助

六、测试类（在具体的系统中，此处的测试代码应该是在图形界面的各个按

钮的动作事件代码中实现）

package com.my.test;

import java.util.*;

import java.util.Scanner;

import com.my.bean.Customer;

import com.my.impl.CustomerInfoImpl;

//测试类

public class CustomerTest {

public static void main(String[] args) {

CustomerInfoImpl cii=new CustomerInfoImpl();

Customer c=new Customer();

c.setCustomName("John");

c.setCustomPassword("666");

c.setAge(21);

c.setAddress("jiangsu,china");

c.setPhone("86338182");

c.setEmail("john@https://www.360docs.net/doc/119276202.html,");

//添加

/*if(cii.addCustomerInfo(c)==true){

System.out.println("添加成功!");

}else{

System.out.println("添加失败!");

}*/

//删除

/*System.out.println("请输入要删除的客户编号:");

Scanner sc=new Scanner(System.in);

int id=sc.nextInt();