📄 offlogbean.java
字号:
package com.officelog;
/**
* @author wsp
*
* To change this generated comment edit the template variable "typecomment":
* Window>Preferences>Java>Templates.
* To enable and disable the creation of type comments go to
* Window>Preferences>Java>Code Generation.
*/
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.sql.*;
import java.util.*;
public class OffLogBean {
/**
* Constructor for ChkUser.
*/
public OffLogBean() { }
public boolean chkUser(HttpServletRequest req, HttpServletResponse resp)
{
String username="";
String password="";
String truename="";
int flag=0;
boolean isUser=false;
username=req.getParameter("username").trim();
password=req.getParameter("password");
System.out.println("username="+username+"__password="+password);
DbADO dbAdo=new DbADO();
try
{
dbAdo.connect();
String sql="select * from users where username='"+username+"' and password='"+password+"'";
ResultSet rs=dbAdo.select(sql);
if(rs.next())
{
truename=rs.getString("truename");
flag=rs.getInt("flag");
isUser=true;
System.out.println("truname="+truename+"___flag="+flag);
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
dbAdo.close();
}
HttpSession httpsession = req.getSession();
httpsession.setAttribute("truename",truename);
httpsession.setAttribute("flag",new Integer(flag));
httpsession.setAttribute("username",username);
Integer Flag=null;
Flag=(Integer)httpsession.getAttribute("flag");
flag=Flag.intValue();
System.out.println("flag="+flag);
return isUser;
}
public boolean companyAdd(HttpServletRequest req, HttpServletResponse resp)
{
boolean isadmin=isAdmin(req,resp);
if(!isadmin)
return isadmin;
DbADO dbAdo=new DbADO();
Vector allAdmin=null;
allAdmin=new Vector();
int id=0;
String truename="";
try
{
dbAdo.connect();
String sql="select * from users where flag=1";
ResultSet rs=dbAdo.select(sql);
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);
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
dbAdo.close();
}
return isadmin;
}
public boolean companySave(HttpServletRequest req, HttpServletResponse resp,String title,String content,String content2,String writer,String writefrom)
{
boolean isadmin=isAdmin(req,resp);
if(!isadmin)
return isadmin;
String authorid=req.getParameter("id");
String sql="insert into company (content,content2,title,hits,dateandtime,authorid,writer,writefrom,state) values ";
sql=sql+"('"+content+"','"+content2+"','"+title+"',0,current Timestamp,"+authorid+",'"+writer+"','"+writefrom+"','no')";
System.out.println("insert 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 total(HttpServletRequest req, HttpServletResponse resp)
{
HttpSession httpsession = req.getSession();
Integer Flag=null;
Flag=(Integer)httpsession.getAttribute("flag");
int flag=Flag.intValue();
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
String sql1="";
String sql2="";
if(flag<=2)
{
sql1="select * from company order by dateandtime";
sql2="select count(companyid) from company";
}
else if(flag>2)
{
sql1="select * from company where state='yes' order by dateandtime";
sql2="select count(companyid) from company where state='yes'";
}
System.out.println("sql1 is: "+sql1);
String state="";
Vector sumList=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;
DbADO dbAdo=new DbADO();
dbAdo.connect();
totalRow=dbAdo.total(sql2);
if(totalRow % pageRow==0)
{
maxPage=totalRow/pageRow;
}
else
{
maxPage=totalRow/pageRow+1;
}
System.out.println("toal() 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("total() startRow: "+startRow);
System.out.println("total() endRow"+endRow);
System.out.println("total() thisPage "+thisPage);
System.out.println("total() totalRow: "+totalRow);
ResultSet rs=dbAdo.select(sql1);
try{
if(startRow>=1)
{
rs.absolute(startRow);
int i=startRow;
while(i<=endRow)
{
state="";
sumList.addElement(rs.getString("companyid"));
sumList.addElement(rs.getString("title"));
sumList.addElement(rs.getString("dateandtime"));
sumList.addElement(rs.getString("writer"));
state=rs.getString("state").trim();
if(state.equals("no"))
state="否";
else if(state.equals("yes"))
state="是";
sumList.addElement(state);
sumList.addElement(rs.getString("hits"));
i++;
rs.next();
}
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
dbAdo.close();
}
if(sumList!=null)
req.setAttribute("sumList",sumList);
req.setAttribute("maxPage",new Integer(maxPage));
return islogin;
}
public boolean searchTotal(HttpServletRequest req, HttpServletResponse resp,String title)
{
HttpSession httpsession = req.getSession();
Integer Flag=null;
Flag=(Integer)httpsession.getAttribute("flag");
int flag=Flag.intValue();
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
String sql1="";
if(flag<=2)
sql1="select * from company where title like '%"+title+"%' order by dateandtime";
else if(flag>2)
sql1="select * from company where state='yes' and title like '%"+title+"%' order by dateandtime";
System.out.println("sql1 is: "+sql1);
String state="";
Vector sumList=new Vector();
DbADO dbAdo=new DbADO();
dbAdo.connect();
ResultSet rs=dbAdo.select(sql1);
try{
while(rs.next())
{
state="";
sumList.addElement(rs.getString("companyid"));
sumList.addElement(rs.getString("title"));
sumList.addElement(rs.getString("dateandtime"));
sumList.addElement(rs.getString("writer"));
state=rs.getString("state").trim();
if(state.equals("no"))
state="否";
else if(state.equals("yes"))
state="是";
sumList.addElement(state);
sumList.addElement(rs.getString("hits"));
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
dbAdo.close();
}
if(sumList!=null)
req.setAttribute("sumList",sumList);
if(title!=null)
req.setAttribute("searchTitle",title);
return islogin;
}
public boolean companyView(HttpServletRequest req, HttpServletResponse resp)
{
HttpSession httpsession = req.getSession();
Integer Flag=null;
Flag=(Integer)httpsession.getAttribute("flag");
int flag=Flag.intValue();
boolean islogin=isLogin(req,resp);
if(!islogin)
return islogin;
Vector viewContent=new Vector();
String authorid="";
String companyid=req.getParameter("companyid");
String sql1="update company set hits=hits+1 where companyid="+companyid;
String sql2="select * from company where companyid="+companyid;
DbADO dbAdo=new DbADO();
dbAdo.connect();
dbAdo.update_insert(sql1);
ResultSet rs=dbAdo.select(sql2);
try{
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"));
authorid=rs.getString("authorid");
viewContent.addElement(authorid);
viewContent.addElement(rs.getString("writefrom"));
}
sql2="select * from users where id="+authorid;
rs=dbAdo.select(sql2);
while(rs.next())
{
viewContent.addElement(rs.getString("truename"));
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
dbAdo.close();
}
viewContent.addElement(companyid);
if(viewContent!=null)
req.setAttribute("viewContent",viewContent);
return islogin;
}
public boolean companyState(HttpServletRequest req, HttpServletResponse resp)
{
boolean isadmin=isAdmin(req,resp);
if(!isadmin)
return isadmin;
String companyid=req.getParameter("companyid");
String sql="update company set state='yes' where companyid="+companyid;
DbADO dbAdo=new DbADO();
dbAdo.connect();
dbAdo.update_insert(sql);
dbAdo.close();
String result="您已成功选用总结！";
req.setAttribute("result",result);
return isadmin;
}
public boolean companyEdit(HttpServletRequest req, HttpServletResponse resp)
{
boolean isadmin=isAdmin(req,resp);
if(!isadmin)
return isadmin;
String companyid=req.getParameter("companyid");
Vector allAdmin=null;
allAdmin=new Vector();
Vector viewContent=new Vector();
int id=0;
String truename="";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -