affiche.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;
import java.sql.*;
import javax.sql.*;
import javax.servlet.http.*;
import java.text.*;
import java.util.*;
public class Affiche {
    private conn c=null;
    private Connection con = null;
    private Statement stm = null;
    private ResultSet rs = null;
    private String strSql=null;
    private java.util.Date st2=null;
    private HashMap hashmap=null;
    private Collection ret=null;
    public Affiche() {
        try {
            c = new conn();
            con = c.getConncetion();
        } catch (connException e) {
            System.out.println(e.toString());
        }
    }

    //解决乱码
    private static String convert(String str) {
        try {
            byte[] bytesStr = str.getBytes("ISO-8859-1");
            return new String(bytesStr, "gb2312");
        } catch (Exception ex) {
            return str;
        }
    }
//查询
    public void Select(HttpServletRequest request)
    {
        ret=new ArrayList();

        strSql = "select * from Affiche";
        try
        {
            stm=con.createStatement();
               rs=stm.executeQuery(strSql);
               while(rs.next())
               {
                   ret.add(String.valueOf(rs.getInt("Id")));
                   ret.add(String.valueOf(rs.getInt("Id")));
                   ret.add(rs.getString("Affiche_Content"));
                   ret.add(rs.getDate("Date_time"));
               }
               request.setAttribute("ret",ret);
        }
        catch(Exception e){System.out.println(e.toString());}

    }

    public void insert(HttpServletRequest request)
    {
        String Affiche_Content=convert((String)request.getParameter("Content").trim());

        String Date_time=convert((String)request.getParameter("Date_time").trim());
        if (Date_time.equals("")==false) { //规范日期格式，与数据库匹配
            Date_time = Date_time + " 01:00:00";
            try {
                //将字符转化为日期类型
                SimpleDateFormat bartDateFormat = new SimpleDateFormat(
                        "yyyy-mm-dd hh:mm:ss");
                st2 = bartDateFormat.parse(Date_time);
                java.sql.Date date = new java.sql.Date(st2.getTime());
                strSql = "insert into Affiche(Affiche_Content,Date_time) values(?,?)";
                PreparedStatement stm=con.prepareStatement(strSql);
                stm.setString(1, Affiche_Content);
                stm.setDate(2,date);
                stm.execute();
            } catch (Exception e) {
                System.out.println(e.toString());
            }
        } else {
            try {
                DateFormat dateFormatter = DateFormat.getDateTimeInstance(
                        DateFormat.LONG, DateFormat.LONG);
                // 取得系统时间
                java.util.Date utilDate = new java.util.Date();
                // 转换成数据库时间
                java.sql.Date date = new java.sql.Date(utilDate.getTime());
                strSql ="insert into Affiche(Affiche_Content,Date_time) values(?,?)";
                PreparedStatement stm = con.prepareStatement(strSql);
                stm.setString(1, Affiche_Content);
                stm.setDate(2, date);
                stm.execute();
            } catch (Exception e) {System.out.println(e.toString());}
        }
      }
      //删除记录
      public void delete(HttpServletRequest request)
      {
          int id=Integer.parseInt(request.getParameter("cmd1"));//从页面上提取出来Id
          System.out.println("id"+id);
          strSql="delete from Affiche where Id="+id;
          try
          {
              stm = con.createStatement();
              stm.executeUpdate(strSql);
          }catch(Exception e){System.out.println(e.toString());}
      }

}