汽车销售系统java应用程序+SQL2000数据库设计完整版

package car.code; import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.table.*; import java.sql.ResultSet; import java.sql.Statement; public class CustomerInfo extends JFrame { static DefaultTableModel data; private ResultSet rs ; static JTable table; public CustomerInfo() { super("添加客户信息"); setSize(800,600); //this.setBackground(Color.green); setResizable(false); Container c=getContentPane(); c.setLayout(new FlowLayout()); JButton []b={new JButton("添加客户信息"),new JButton("删除客户信息"),new JButton("修改客户信息"),new JButton("按客户名字查询信息"),new JButton("按客户ID查询信息")}; for(int i=0;i<5;i++) c.add(b[i]); String [] s = {"客户编号","客户姓名","客户姓别","身份证号","汽车名字","交易价格","买入日期","买入数量","总价","备注"}; data = new DefaultTableModel(s,0); table = new JTable(data); table.setBackground(Color.white); table.setEnabled(false); table.setPreferredScrollableViewportSize(new Dimension(700,500)); table.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN); //data=new DefaultTableModel(); JScrollPane sp=new JScrollPane(table); c.add(sp); Statement stmt = new Connectdatabase().Connect(); try{ //customer_info user_id user_name user_sex user_indetity user_carname user_buysales user_buydate user_num user_totalsum user_attach rs=stmt.executeQuery("select * from customer_info"); while(rs.next()){ String user_id= rs.getString("user_id"); String user_name = rs.getString("user_name"); String user_sex = rs.getString("user_sex"); String user_indetity = rs.getString("user_indetity"); String user_carname = rs.getString("user_carname"); String user_buysales = rs.getString("user_buysales"); String user_buydate = rs.getString("user_buydate"); String user_num = rs.getString("user_num"); String user_totalsum = rs.getString("user_totalsum"); String user_attach = rs.getString("user_attach"); String[] str = {user_id, user_name, user_sex, user_indetity, user_carname, user_buysales, user_buydate,user_num ,user_totalsum ,user_attach}; data.addRow(str); } } catch(Exception e){ System.out.println("添加异常"); } setVisible(true); setLocation(300,250); b[0].addActionListener(new ActionListener(){ /////////////添加目录 public void actionPerformed(final ActionEvent e){ final tjml2 a=new tjml2(); a.setBounds(430,350,220,240); a.setVisible(true); a.setSize(400,600); a.setResizable(false); } }); b[2].addActionListener(new ActionListener(){ ///////////////修改目录 public void actionPerformed(final ActionEvent e){ System.out.println("update"); final xgml2 a=new xgml2(); a.setBounds(430,350,220,240); a.setVisible(true); a.setSize(400,600); a.setResizable(false); } }); b[1].addActionListener(new ActionListener(){ //////////////删除目录 public void actionPerformed(final ActionEvent e){ final scml2 a=new scml2(); a.setBounds(430,350,220,240); a.setVisible(true); a.setSize(260, 300); a.setResizable(false); } }); b[3].addActionListener(new ActionListener(){ //////////////按名字查询目录 public void actionPerformed(final ActionEvent e){ final checkdname2 a=new checkdname2(); a.setBounds(430,350,220,240); a.setVisible(true); a.setSize(400,600); a.setResizable(false); } }); b[4].addActionListener(new ActionListener(){ //////////////按名字查询目录 public void actionPerformed(final ActionEvent e){ final checkdid2 a=new checkdid2(); a.setBounds(430,350,220,240); a.setVisible(true); a.setSize(400,600); a.setResizable(false); } }); } } // @jve:decl-index=0:visual-constraint="37,15" //添加目录/////////////////添加目录////////////////添加目录/////////////////添加目录////////////////////////////////////////////////////////// class tjml2 extends JFrame implements ActionListener { JLabel lb1,lb2,lb3,lb4,lb5,lb6,lb7,lb8,lb9,lb10,lb11; JTextField tf1,tf2,tf3,tf4,tf5,tf6,tf7,tf8,tf9,tf10; JButton bt1,bt2; tjml2() {//"客户ID","客户姓名","客户姓别","身份证号","汽车名字","交易价格","买入日期","买入数量","总价","备注" setTitle("增加客户信息"); this.getContentPane().setLayout(null); lb1=new JLabel("客户编号");//目录编号 学号 tf1=new JTextField(10); lb2=new JLabel("客户姓名"); //目录名字 姓名 tf2=new JTextField(10); lb3=new JLabel("客户姓别");//目录单价 生日 tf3=new JTextField(10); lb4=new JLabel("身份证号"); tf4=new JTextField(20); lb5=new JLabel("汽车名字"); tf5=new JTextField(20); lb6=new JLabel("交易价格"); tf6=new JTextField(20); lb7=new JLabel("买入日期"); tf7=new JTextField(20); lb8=new JLabel("买入数量"); tf8=new JTextField(20); lb9=new JLabel("总价"); tf9=new JTextField(20); lb10=new JLabel("备注"); tf10=new JTextField(20); lb11=new JLabel("(yyyy-MM-dd)"); bt1=new JButton("插入"); bt2=new JButton("取消"); lb1.setFont(new Font("宋体",Font.BOLD,12)); lb2.setFont(new Font("宋体",Font.BOLD,12)); lb3.setFont(new Font("宋体",Font.BOLD,12)); lb4.setFont(new Font("宋体",Font.BOLD,12)); lb5.setFont(new Font("宋体",Font.BOLD,12)); lb6.setFont(new Font("宋体",Font.BOLD,12)); lb7.setFont(new Font("宋体",Font.BOLD,12)); lb8.setFont(new Font("宋体",Font.BOLD,12)); lb9.setFont(new Font("宋体",Font.BOLD,12)); lb10.setFont(new Font("宋体",Font.BOLD,12)); lb11.setFont(new Font("宋体",Font.BOLD,12)); tf1.setFont(new Font("宋体",Font.BOLD,12)); tf2.setFont(new Font("宋体",Font.BOLD,12)); tf3.setFont(new Font("宋体",Font.BOLD,12)); tf4.setFont(new Font("宋体",Font.BOLD,12)); tf5.setFont(new Font("宋体",Font.BOLD,12)); tf6.setFont(new Font("宋体",Font.BOLD,12)); tf7.setFont(new Font("宋体",Font.BOLD,12)); tf8.setFont(new Font("宋体",Font.BOLD,12)); tf9.setFont(new Font("宋体",Font.BOLD,12)); tf10.setFont(new Font("宋体",Font.BOLD,12)); bt1.setFont(new Font("楷书",Font.BOLD,12)); bt2.setFont(new Font("楷书",Font.BOLD,12)); lb1.setBounds(100,40,100,30);tf1.setBounds(160,40,120,30); lb2.setBounds(100,75,100,30);tf2.setBounds(160,75,120,30); lb3.setBounds(100,110,100,30);tf3.setBounds(160,110,120,30); lb4.setBounds(100,145,100,30);tf4.setBounds(160,145,120,30); lb5.setBounds(100,180,100,30);tf5.setBounds(160,180,120,30); lb6.setBounds(100,215,100,30);tf6.setBounds(160,215,120,30); lb7.setBounds(100,250,100,30);tf7.setBounds(160,250,120,30); lb8.setBounds(100,285,100,30);tf8.setBounds(160,285,120,30); lb9.setBounds(100,320,100,30);tf9.setBounds(160,320,120,30); lb10.setBounds(100,355,100,30);tf10.setBounds(160,355,120,30);