汽车销售管理系统

汽车销售管理系统

背景

Java基础课程设计

环境

• 数据库：MySQL8.0
• 开发环境：JDK1.8
• 开发工具：MyEclipse

项目结构

项目详情

DAO层

• GoodsDao.java
• GoodsDaoImpl.java
• PurchaseDao.java
• PurchaseImpl.java
• SalesDao.java
• SalesDaoImpl.java
• UserDao.java
• UserDaoImpl.java
  DBConn层
• DBConn.java
  JFrame层
• CircleProgressBar.java
• Data.java
• goodsAdd.java
• goodsDelete.java
• goodsUpdate.java
• HomePage.java
• Login.java
• MyFrame.java
• Purchase.java
• purchaseAdd.java
• purchaseDelete.java
• Sales.java
• salesAdd.java
• salesDelete.java
• userMana.java
  MySQL层
• Goods.java
• Purchase.java
• Sales.java
• User.java

数据库

DBConn.java

数据库连接

package DBConn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConn
{
   
	//连接到数据库
	private static String driver;
	private static String url;
	private static String username;
	private static String password;
	static
	{
   	
		driver = "com.mysql.cj.jdbc.Driver";
		url = "jdbc:mysql://localhost:3306/salesMS?serverTimezone=UTC&useSSL=false";
		username = "root";
		password = "123456";
	}
	public static Connection open()
	{
   
		try {
   
			Class.forName(driver);
			return DriverManager.getConnection(url,username,password);
		} catch (Exception e) {
   
			e.printStackTrace();
		}
		return null;
	}

	public static void close(Connection conn)
	{
   
		if(conn!=null)
		try {
   
			conn.close();
		} catch (SQLException e) {
   
			e.printStackTrace();
		}
	}
}

Login.java

登录界面

package JFrame;

import java.awt.Checkbox;
import java.awt.CheckboxGroup;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;

import DAO.UserDaoImpl;
import DBConn.DBConn;
import MySQL.User;

public class Login extends JFrame implements ActionListener{
   
	private static final long serialVersionUID = -705511349178672604L;
	JLabel bg;
	JTextField t1,t2;
	CheckboxGroup type;
	Checkbox cb1,cb2;
	JButton b1;
	Connection conn;
	public Login(){
   
		ImageIcon bg1 = new ImageIcon(HomePage.class.getResource("userbg2.jpg"));
		ImageIcon bg2 = new ImageIcon(HomePage.class.getResource("signin.jpg"));
		bg = new JLabel(bg1);
		conn = DBConn.open();
		//e1 = new JLabel("用户名：");
		//e2 = new JLabel("密码：");
		t1 = new JTextField(10);
		t2 = new JTextField(10);
		t1.setText("");
		t2.setText("");
		type = new CheckboxGroup();
		cb1 = new Checkbox("user",true,type);
		cb2 = new Checkbox(