usermgr.java

jdo开发实例,一个功能全面的oa系统

package com.gzrealmap.oa.actions;
import com.gzrealmap.lib.jdbc.JDBCUtil;
import java.sql.Date;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Hashtable;

public class UserMgr
{

    public UserMgr()
    {
    }

    public Hashtable getUser(String ids)
    {
      System.out.println("--------------dddd--------------");
        //ArrayList al = new ArrayList();
        Hashtable ha = new Hashtable();
        String sql = "select * from innernews where id=" + ids;
        try
        {
          System.out.println("-----------in dddd---------------------");
            JDBCUtil jdbc = JDBCUtil.getInstance();
            jdbc.connect();
            ResultSet rs = jdbc.query(sql);
            if(rs.next()){

                ha.put("topic", rs.getString("topic"));
                ha.put("content", rs.getString("content"));
                ha.put("end_time", rs.getDate("end_time").toString());
                ha.put("acc", String.valueOf(rs.getLong("acc")));
                ha.put("type", rs.getString("type"));
                ha.put("accfile", String.valueOf(rs.getLong("accfile")));
                ha.put("filename", rs.getString("filename"));
                ha.put("filetype", rs.getString("filetype"));
                //al.add(ha);
            }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return ha;
    }

    public static String getname(String ID) throws
        Exception {
          String filename = "";
          String sql = "SELECT filename FROM innerNews  where id='" + ID + "'";

          JDBCUtil jdbc = JDBCUtil.getInstance();
          jdbc.connect();
          ResultSet rs = jdbc.query(sql);

          if (rs.next()) {
            filename = rs.getString("filename");
          }
          rs.close();
          jdbc.disconnect();
          return filename;
    }

    public static String getflashname(String ID) throws
        Exception {
          String flashname = "";
          String sql = "SELECT flashname FROM innerNews  where id='" + ID + "'";

          JDBCUtil jdbc = JDBCUtil.getInstance();
          jdbc.connect();
          ResultSet rs = jdbc.query(sql);

          if (rs.next()) {
            flashname = rs.getString("flashname");
          }
          rs.close();
          jdbc.disconnect();
          return flashname;
    }

    public String[] getContent(String id)
    {
        ArrayList al = new ArrayList();
        String[] result=new String[4];
        try
        {
            JDBCUtil sql = JDBCUtil.getInstance();
            sql.connect();
            ResultSet rs = sql.query("select id from newspicture where innerNewId=" + id);
            for(int i=0; rs.next();i++)
            {
                String ids = Integer.toString(rs.getInt("id"));
                result[i]=ids;
            }

        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return result;
    }

}