usermgr.java.back

来自「jdo开发实例,一个功能全面的oa系统」· BACK 代码 · 共 45 行

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 ArrayList getUser(String ids)
    {
        ArrayList al = new ArrayList();
        String sql = "select* from innernews where id=" + ids;
        try
        {
            JDBCUtil jdbc = JDBCUtil.getInstance();
            jdbc.connect();
            ResultSet rs = jdbc.query(sql);
            if(rs.next())
            {
                Hashtable ha = new Hashtable();
                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 al;
    }
}