leavelanguagebean.java

用jsp+javabean做的一个网上花店

package com;

import java.util.ArrayList;
import java.util.Collection;
import java.sql.*;

public class leavelanguageBean
{
    private Connection con;

    public leavelanguageBean()
    {
        try
        {
            con = DBConnection.getConnection();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }

    public Collection getAllLanguage()
    {
        LeaveLanguageClass leaveLanguage;
        ArrayList arraylist = new ArrayList();
        try 
        {
            Statement statement = con.createStatement();
            ResultSet resultset = statement.executeQuery("select * from leaveLanguage");

            while (resultset.next())
            {
                leaveLanguage = new LeaveLanguageClass();
                int i = resultset.getInt(1);
                String m = resultset.getString(2);
                String n = resultset.getString(3);
                String x = resultset.getString(4);
                String y = resultset.getString(5);
                String t = resultset.getString(6);

                leaveLanguage.setLeaveLanguageId(i);
                leaveLanguage.setName(m);
                leaveLanguage.setQq(n);
                leaveLanguage.setEmail(x);
                leaveLanguage.setLeaveLanguage(y);
                leaveLanguage.setDateTime(t);

                arraylist.add(leaveLanguage);
            }

            con.close();
        }

        catch (Exception e) {
            e.printStackTrace();
        }
        return arraylist;
    }
    
    public Collection getLanguageByUsersName(String name)
    {
        LeaveLanguageClass leaveLanguage;
        ArrayList arraylist = new ArrayList();
        try 
        {
            Statement statement = con.createStatement();
            ResultSet resultset = statement.executeQuery("select * from leaveLanguage where name='"+name+"'");

            while (resultset.next())
            {
                leaveLanguage = new LeaveLanguageClass();
                int i = resultset.getInt(1);
                String m = resultset.getString(2);
                String n = resultset.getString(3);
                String x = resultset.getString(4);
                String y = resultset.getString(5);
                String t = resultset.getString(6);

                leaveLanguage.setLeaveLanguageId(i);
                leaveLanguage.setName(m);
                leaveLanguage.setQq(n);
                leaveLanguage.setEmail(x);
                leaveLanguage.setLeaveLanguage(y);
                leaveLanguage.setDateTime(t);

                arraylist.add(leaveLanguage);
            }

            con.close();
        }

        catch (Exception e) {
            e.printStackTrace();
        }
        return arraylist;
    }
    
    public Collection getLanguageByDateTime(String year,String month,String day)
    {
        LeaveLanguageClass leaveLanguage;
        ArrayList arraylist = new ArrayList();
        String datetime="Time:"+year+"-"+month+"-"+day; 
        try 
        {
            Statement statement = con.createStatement();
            ResultSet resultset = statement.executeQuery("select * from leaveLanguage where dateTime like '"+datetime+"%'");

            while (resultset.next())
            {
                leaveLanguage = new LeaveLanguageClass();
                int i = resultset.getInt(1);
                String m = resultset.getString(2);
                String n = resultset.getString(3);
                String x = resultset.getString(4);
                String y = resultset.getString(5);
                String t = resultset.getString(6);

                leaveLanguage.setLeaveLanguageId(i);
                leaveLanguage.setName(m);
                leaveLanguage.setQq(n);
                leaveLanguage.setEmail(x);
                leaveLanguage.setLeaveLanguage(y);
                leaveLanguage.setDateTime(t);

                arraylist.add(leaveLanguage);
            }

            con.close();
        }

        catch (Exception e) {
            e.printStackTrace();
        }
        return arraylist;
    }
    
    public void addLanguage(String m,String n,String x,String y)throws Exception
    {
        try
        {
        	java.util.Date date=new java.util.Date();
			int year=date.getYear()+1900;
			int month=date.getMonth()+1;
			int day=date.getDay()+26;
			int hour=date.getHours();
			int minute=date.getMinutes();
			int second=date.getSeconds();
			String time="Time:"+year+"-"+month+"-"+day+" " +hour+":"+minute+":"+second;

            PreparedStatement stm=con.prepareStatement("insert into leaveLanguage values(?,?,?,?,?)");
            stm.setString(1,m);
            stm.setString(2,n);
            stm.setString(3,x);
            stm.setString(4,y);
            stm.setString(5,time);

            try
            {
               stm.executeQuery();
            }
            catch(Exception e)
            {
            }


        }
        catch(Exception e)
        {
            e.printStackTrace();
            throw e;
        }
    }
    
    public void addAdminLanguage(String m)throws Exception
    {
        try
        {
        	java.util.Date date=new java.util.Date();
			int year=date.getYear()+1900;
			int month=date.getMonth()+1;
			int day=date.getDay()+26;
			int hour=date.getHours();
			int minute=date.getMinutes();
			int second=date.getSeconds();
			String time="Time:"+year+"-"+month+"-"+day+" " +hour+":"+minute+":"+second;

            PreparedStatement stm=con.prepareStatement("insert into leaveLanguage values(?,?,?,?,?)");
            stm.setString(1,"管理员");
            stm.setString(2,"12345678");
            stm.setString(3,"[e-mail]");
            stm.setString(4,m);
            stm.setString(5,time);

            try
            {
               stm.executeQuery();
            }
            catch(Exception e)
            {
            }


        }
        catch(Exception e)
        {
            e.printStackTrace();
            throw e;
        }
    }
        public void deleteLanguage(String s)
    {
    	try
    	{
    		int i=Integer.parseInt(s);
    		//System.out.println(i+"  @@@@@@@@@@@@");
	    	Statement statement = con.createStatement();
	        statement.execute("delete from leaveLanguage where leaveLanguageId='" + i + "'");
    	}
		catch(Exception e)
		{
			e.printStackTrace();
		}
    }
}