suggest.java

本系统是鞋厂管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;

//员工发表意见的地方
public class Suggest extends JFrame implements ActionListener
{
	int i;
	
	DBConnection conn=new DBConnection();
	Connection con=conn.getConn();
	JTextArea jta=new JTextArea();
	Message msg=new Message();
    public Suggest()
    {
    	setTitle("意见栏");
    	setLocation(320,210);
    	setSize(400,300);
    	JLabel jlb=new JLabel("您对本厂有何意见，请发表：");
    	JButton b1=new JButton("提交");
    	JButton b2=new JButton("退出");
    	
    	JPanel p=new JPanel();
    	p.add(b1);
    	p.add(b2);
    	
    	Container c=getContentPane();
    	c.setLayout(new BorderLayout());
    	c.add(jlb,BorderLayout.NORTH);
    	c.add(jta,BorderLayout.CENTER);
    	c.add(p,BorderLayout.SOUTH);
    	
    	b1.addActionListener(this);
    	b2.addActionListener(this);
    }
    
    public String date()//获取本地时间的函数
    {
    	Calendar cal = Calendar.getInstance(); 
    	String date,minute,hour,day,month,year; 
    	year = String.valueOf(cal.get(Calendar.YEAR)); 
    	month = String.valueOf(cal.get(Calendar.MONTH)+1); 
    	day = String.valueOf(cal.get(Calendar.DATE));
    	hour = String.valueOf(cal.get(Calendar.HOUR_OF_DAY));
    	minute = String.valueOf(cal.get(Calendar.MINUTE));
    	date = year+"年"+month+"月"+day+"日"+hour+":"+minute;
    	return date;
    }
    
    
    public void actionPerformed(ActionEvent e)
    {
    	if("提交".equals(e.getActionCommand()))
    	{
    		if(jta.getText().length()>9)//输入内容不能小于十个字符
    		{
    			String sql1="select * from suggest";
        		try
        		{
        			Statement stmt=con.createStatement();
        			ResultSet rs=stmt.executeQuery(sql1);
        			rs.last();
        			i=rs.getInt(1)+1;
        		}
        		catch(SQLException ex){}
        		String sql2="insert into suggest values('"+i+"','"+jta.getText()+"','"+date()+"')";
        		msg.trange(sql2);
        		setVisible(false);
        		String str="发表成功";
    			Alert alert=new Alert(str);
    			alert.setVisible(true);
    		}
    		
    		else
    		{
    			String str="输入内容不能小于十个字符";
    			Alert alert=new Alert(str);
    			alert.setVisible(true);
    		}
    	}
    	
    	if("退出".equals(e.getActionCommand()))
    	{
    		setVisible(false);
    	}
    }
    
    
}