📄 offlogbean.java
字号:
String sql1="select * from users where flag=1";
String sql2="select * from company where companyid="+companyid;
DbADO dbAdo=new DbADO();
try
{
dbAdo.connect();
ResultSet rs=dbAdo.select(sql1);
while(rs.next())
{
id=rs.getInt("id");
truename=rs.getString("truename");
allAdmin.addElement(new Integer(id));
allAdmin.addElement(truename);
System.out.println("admin is: "+id+" "+truename);
}
if(allAdmin!=null)
req.setAttribute("allAdmin",allAdmin);
rs=dbAdo.select(sql2);
while(rs.next())
{
viewContent.addElement(rs.getString("content"));
viewContent.addElement(rs.getString("content2"));
viewContent.addElement(rs.getString("title"));
viewContent.addElement(rs.getString("hits"));
viewContent.addElement(rs.getString("dateandtime"));
viewContent.addElement(rs.getString("authorid"));
viewContent.addElement(rs.getString("writer"));
viewContent.addElement(rs.getString("writefrom"));
viewContent.addElement(rs.getString("companyid"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
dbAdo.close();
}
if(viewContent!=null)
req.setAttribute("viewContent",viewContent);
return isadmin;
}
public boolean companyUpdate(HttpServletRequest req, HttpServletResponse resp,String title,String content,String content2,String writer,String writefrom)
{
boolean isadmin=isAdmin(req,resp);
if(!isadmin)
return isadmin;
String companyid=req.getParameter("companyid");
String authorid=req.getParameter("id");
String sql="update company set title='"+title+"',content='"+content+"',content2='"+content2+"'";
sql=sql+",authorid="+authorid+",writer='"+writer+"',writefrom='"+writefrom+"',dateandtime=current Timestamp where companyid="+companyid;
System.out.println("update sql is: "+sql);
DbADO dbAdo=new DbADO();
dbAdo.connect();
dbAdo.update_insert(sql);
dbAdo.close();
String result="编辑公司总结成功!";
req.setAttribute("result",result);
return isadmin;
}
public boolean companyDel(HttpServletRequest req, HttpServletResponse resp)
{
boolean isadmin=isAdmin(req,resp);
if(!isadmin)
return isadmin;
String companyid=req.getParameter("companyid");
String sql="delete from company where companyid="+companyid;
System.out.println("update sql is: "+sql);
DbADO dbAdo=new DbADO();
dbAdo.connect();
dbAdo.update_insert(sql);
dbAdo.close();
String result="删除公司总结成功!";
req.setAttribute("result",result);
return isadmin;
}
public boolean ownAdd(HttpServletRequest req, HttpServletResponse resp)
{
HttpSession httpsession = req.getSession();
String username=(String)httpsession.getAttribute("username");
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
String partid="";
DbADO dbAdo=new DbADO();
Vector ownUser=new Vector();
try
{
dbAdo.connect();
String sql="select * from users where username='"+username+"'";
ResultSet rs=dbAdo.select(sql);
while(rs.next())
{
ownUser.addElement(rs.getString("id"));
ownUser.addElement(rs.getString("username"));
ownUser.addElement(rs.getString("truename"));
ownUser.addElement(rs.getString("flag"));
partid=rs.getString("partid");
ownUser.addElement(partid);
System.out.println("partid="+partid);
}
sql="select * from part where partid="+partid;
rs=dbAdo.select(sql);
while(rs.next())
{
ownUser.addElement(rs.getString("partname"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
dbAdo.close();
}
if(ownUser!=null)
req.setAttribute("ownUser",ownUser);
return islogin;
}
public boolean ownSave(HttpServletRequest req, HttpServletResponse resp,String sumcontent,String plancontent,String title,String author,String user)
{
HttpSession httpsession = req.getSession();
String username=(String)httpsession.getAttribute("username");
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
System.out.println("title is: "+title);
String partname="";
String partid=req.getParameter("partid");
String flag=req.getParameter("flag");
System.out.println("user is: "+user);
String userid=req.getParameter("userid");
DbADO dbAdo=new DbADO();
dbAdo.connect();
String sql="select * from part where partid="+partid;
ResultSet rs=dbAdo.select(sql);
try
{
while(rs.next())
{
partname=rs.getString("partname");
System.out.println("partname is: "+partname);
}
}
catch(Exception e)
{
e.printStackTrace();
}
sql="insert into own (sumcontent,plancontent,reply1,reply2,title,partname,partid,flag,author,username,userid,dateandtime,state) values ";
sql=sql+"('"+sumcontent+"','"+plancontent+"','无','无','"+title+"','"+partname+"',"+partid+","+flag+",'"+author+"','"+user+"',"+userid+",current Timestamp,'no')";
System.out.println("insert sql is: "+sql);
dbAdo.update_insert(sql);
dbAdo.close();
String result="添加个人总结成功!";
req.setAttribute("result",result);
return islogin;
}
public boolean ownTotal(HttpServletRequest req, HttpServletResponse resp)
{
HttpSession httpsession = req.getSession();
String username=(String)httpsession.getAttribute("username");
Integer Flag=null;
Flag=(Integer)httpsession.getAttribute("flag");
int flag=Flag.intValue();
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
String managerReply=req.getParameter("managerReply");
if(managerReply==null)
managerReply="0";
String path="own_sum";
String sql1="";
String sql2="";
String sql="select partid from users where username='"+username+"'";
DbADO dbAdo=new DbADO();
dbAdo.connect();
int partid=dbAdo.total(sql);
System.out.println("partid is: "+partid);
if(flag<=2)
{
sql1="select * from own where state='yes' order by dateandtime";
sql2="select count(ownid) from own where state='yes'";
path="company";
}
else if(flag>=3)
{
sql1="select * from own where username='"+username+"' order by dateandtime";
sql2="select count(ownid) from own where username='"+username+"'";
}
if(flag==3&&managerReply.equals("1"))
{
sql1="select * from own where state='yes' and partid="+partid+" order by dateandtime";
sql2="select count(ownid) from own where state='yes' and partid="+partid;
path="dept";
}
System.out.println("sql1 is: "+sql1);
String state="";
Vector ownList=new Vector();
String page=req.getParameter("page");
if(page==null)
page="1";
int pageRow=8;
int totalRow=0;
int thisPage=new Integer(page).intValue();
int maxPage=0;
int startRow=1;
int endRow=pageRow;
totalRow=dbAdo.total(sql2);
if(totalRow % pageRow==0)
{
maxPage=totalRow/pageRow;
}
else
{
maxPage=totalRow/pageRow+1;
}
System.out.println("ownTotal() maxPage: "+maxPage);
if(thisPage<1)
thisPage=1;
if(thisPage>maxPage)
thisPage=maxPage;
req.setAttribute("thisPage",new Integer(thisPage));
thisPage=maxPage-thisPage+1;
if(thisPage>1&&thisPage<maxPage)
{
startRow=(thisPage-1)*pageRow+1;
endRow=thisPage*pageRow;
}
else if(thisPage>=maxPage)
{
startRow=(maxPage-1)*pageRow+1;
endRow=totalRow;
}
System.out.println("ownTotal() startRow: "+startRow);
System.out.println("ownTotal() endRow"+endRow);
System.out.println("ownTotal() thisPage "+thisPage);
System.out.println("ownTotal() totalRow: "+totalRow);
ResultSet rs=dbAdo.select(sql1);
try{
if(startRow>=1)
{
rs.absolute(startRow);
int i=startRow;
while(i<=endRow)
{
state="";
ownList.addElement(rs.getString("ownid"));
ownList.addElement(rs.getString("reply1"));
ownList.addElement(rs.getString("reply2"));
ownList.addElement(rs.getString("title"));
ownList.addElement(rs.getString("partid"));
ownList.addElement(rs.getString("author"));
ownList.addElement(rs.getString("userid"));
ownList.addElement(rs.getString("dateandtime"));
state=rs.getString("state").trim();
if(state.equals("no"))
state="未提交";
else if(state.equals("yes"))
state="已提交";
ownList.addElement(state);
i++;
rs.next();
}
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
dbAdo.close();
}
if(ownList!=null)
req.setAttribute("ownList",ownList);
req.setAttribute("managerReply",managerReply);
req.setAttribute("path",path);
req.setAttribute("maxPage",new Integer(maxPage));
return islogin;
}
public boolean searchOwn(HttpServletRequest req, HttpServletResponse resp,String title)
{
HttpSession httpsession = req.getSession();
String username=(String)httpsession.getAttribute("username");
Integer Flag=null;
Flag=(Integer)httpsession.getAttribute("flag");
int flag=Flag.intValue();
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
String managerReply=req.getParameter("managerReply");
String path=req.getParameter("path");
String sql1="";
String sql="select partid from users where username='"+username+"'";
DbADO dbAdo=new DbADO();
dbAdo.connect();
int partid=dbAdo.total(sql);
System.out.println("partid is: "+partid);
if(flag<=2)
{
sql1="select * from own where state='yes' and title like '%"+title+"%' order by dateandtime";
}
else if(flag>=3)
{
sql1="select * from own where username='"+username+"' and title like '%"+title+"%' order by dateandtime";
}
if(flag==3&&managerReply.equals("1"))
{
sql1="select * from own where state='yes' and partid="+partid+" and title like '%"+title+"%' order by dateandtime";
}
System.out.println("sql1 is: "+sql1);
String state="";
Vector ownList=new Vector();
ResultSet rs=dbAdo.select(sql1);
try{
while(rs.next())
{
state="";
ownList.addElement(rs.getString("ownid"));
ownList.addElement(rs.getString("reply1"));
ownList.addElement(rs.getString("reply2"));
ownList.addElement(rs.getString("title"));
ownList.addElement(rs.getString("partid"));
ownList.addElement(rs.getString("author"));
ownList.addElement(rs.getString("userid"));
ownList.addElement(rs.getString("dateandtime"));
state=rs.getString("state").trim();
if(state.equals("no"))
state="未提交";
else if(state.equals("yes"))
state="已提交";
ownList.addElement(state);
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
dbAdo.close();
}
if(ownList!=null)
req.setAttribute("ownList",ownList);
if(title!=null)
req.setAttribute("searchTitle",title);
req.setAttribute("managerReply",managerReply);
req.setAttribute("path",path);
return islogin;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -