📄 menulist.java
字号:
package Bean;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 该类的作用是用于添加栏目时的下拉框的值
*/
public class MenuList {
private int id;
public String strlist="";
public String topiclist="";
public String yearlist="";
private String menunames="";
private String idmenuname="";
private String idmenunamelink="";
private db.DB dt=new db.DB();
public String getStrlist() {
getDt();
ResultSet rs=dt.getRs("select * from menu where Depth=1 order by OrderList");
if(rs==null){
dt.close();
return "MenuList得到栏目时出错：";
}
try{
//String sql="select * from menu where Depth=1 order by OrderList";
//dc.getConnPool();
//ResultSet sqlRst=dc.QuerySQL(sql);
while(rs.next()){
strlist+="<option value='"+rs.getString("Id")+"'>"
+rs.getString("MenuName")+"</option>";
ChildMenuList(rs.getInt("Id"));//得到子菜单
}
}
catch(Exception e){
System.out.println("MenuList得到栏目时出错："+e.toString());
}
finally{
dt.close();//dc.closeResault();dc.closePstm();dc.closeConn();
}
return strlist;
}
public void setStrlist(String strlist) {
this.strlist = strlist;
}
private void ChildMenuList(int ParentID){
getDt();
ResultSet rs=dt.getRs("select * from menu where ParentID="+ParentID+" order by OrderList");
if(rs==null){
dt.close();System.out.println("在查找子菜单的时候出错ChildMenuList(int "+ParentID+"){");
return;
}
try{
//p_Stm=dc.conn.prepareStatement(sql);
//r_rs=p_Stm.executeQuery();
while(rs.next()){
strlist+="<option value="+rs.getString("Id")+">";
for(int i=2;i<rs.getInt("Depth");i++){
if(i==2) strlist+="├";
else strlist+="-";
}
strlist+="├"+rs.getString("MenuName")+"</option>";
ChildMenuList(rs.getInt("Id"));//用递归调用查找子菜单
}
}
catch(SQLException ex){
System.out.println("在查找子菜单的时候出错："+ex);
}
finally{
try{
rs.close();
dt.close();
}catch(SQLException ex){
dt.close();
System.out.println("在查找子菜单关闭记录集时出错："+ex);
}
}
}
public String getTopiclist(){
getDt();
ResultSet rs=dt.getRs("select * from topic order by OrderList");
if(rs==null){
dt.close();
return("MenuList得到栏目时出错 in getTopiclist()");
}
try{
while(rs.next()){
topiclist+="<option value="+rs.getString("Id")+">"
+rs.getString("TopicName")+"</option>";
}
}
catch(Exception e){
System.out.println("MenuList得到栏目时出错："+e.toString());
}
finally{
dt.close();
}
return topiclist;
}
public void setTopiclist(String topiclist) {
this.topiclist = topiclist;
}
public String getYearlist(){
//String sql="select Tyear from countstatyear";
//dc.getConnPool();
getDt();
ResultSet rs=dt.getRs("select Tyear from countstatyear");
if(rs==null)return "";
try{while(rs.next()){
yearlist+="<option value="+rs.getString("Tyear")+">"+rs.getString("Tyear")+"</option>";
}
}catch(Exception ex){
System.out.print("Menulist 得到年列表时出错 select Tyear from countstatyear"+ex);
return "";
}
finally{
try {rs.close();
}catch (SQLException e){
e.printStackTrace();
}
dt.close();
}
return yearlist;
}
public void setYearlist(String yearlist) {
this.yearlist = yearlist;
}
public String getMenunames() {
//String sql="select Id,MenuName from menu where Depth=1 order by OrderList";
//dc.getConnPool();
getDt();
ResultSet rs=dt.getRs("select Id,MenuName from menu where Depth=1 order by OrderList");
try{//rs=dc.QuerySQL(sql);
if(rs.next()){
menunames="<a href='article_viewlist.jsp?Id="+rs.getString("Id")+"'>"+rs.getString("MenuName")+"</a>";
}
while(rs.next()){
menunames+=" | "+"<a href='article_viewlist.jsp?Id="+rs.getString("Id")+"'>"+rs.getString("MenuName")+"</a>";
}
}catch(Exception ex){
System.out.print("Menulist 得到年栏目名称时出错 select Id,MenuName from menu where Depth=1 order by OrderList"+ex);
return "";
}
finally{
dt.close();
}
return menunames;
}
public void setMenunames(String menunames) {
this.menunames = menunames;
}
public String getIdmenuname() {
return idmenuname;
}
public void setIdmenuname(String idmenuname) {
this.idmenuname = idmenuname;
}
public String getIdmenunamelink() {
return idmenunamelink;
}
public void setIdmenunamelink(String idmenunamelink) {
this.idmenunamelink = idmenunamelink;
}
public void setId(int id){
getDt();
if(id!=-1){
String temp=dt.returnString("select MenuName from menu where Id="+String.valueOf(id));
idmenuname="-><a href='article_viewall.jsp?Id="+id+"'>"+temp+"</a>";
idmenunamelink="->"+"<a href='article_viewall.jsp?Id="+id+"'>"+temp+"</a>";
int parentid=dt.returnInt("select ParentID from menu where Id="+String.valueOf(id));
try{
// String temp=dt.ReturnFieldValueString("menu", "Id", String.valueOf(id), "MenuName");
// idmenuname="->"+temp;
// idmenunamelink="->"+"<a href='article_viewall.jsp?Id="+id+"'>"+temp+"</a>";
// int parentid=dc.ReturnFieldValue("menu", "Id", String.valueOf(id), "ParentID");
// String sql="select Id,MenuName,ParentID from menu where Id="+parentid;
while(true){
ResultSet rs=dt.getRs("select Id,MenuName,ParentID from menu where Id="+parentid);
if(rs.next()){
String temp2=rs.getString("MenuName");
idmenuname="->"+temp2+idmenuname;
idmenunamelink="->"+"<a href='article_viewall.jsp?Id="+id+"'>"+temp2+"</a>"+idmenunamelink;
}else
break;
}
}catch(Exception ex){
System.out.println("在setid中， MenuList中出错："+ex);
}
finally{
idmenuname="首页"+idmenuname;
idmenunamelink="<a href='index.jsp'>首页</a>"+idmenunamelink;
dt.close();
}
}
this.id = id;
}
/**
*
*/
public db.DB getDt(){
if(dt==null)dt=new db.DB();
return dt;
}
/**
* 对某一字段进行排序上升一位，用于栏目同级之间的排序
*/
public void MenuUpOneSort(int Id){
getDt();
int ParentID=dt.returnInt("select ParentID from menu where id="+String.valueOf(Id));
//this.ReturnFieldValue("menu", "Id", String.valueOf(Id), "ParentID");
ResultSet rs = null;
try{
rs=dt.getRs("select * from menu where ParentID="+String.valueOf(ParentID)+" order by OrderList");
int Pre_ID,Pre_Order,T_Order;
int index=0;
while(rs.next()){
index++;
if(rs.getInt("Id")==Id) break;
}
if(index>1) {
rs.previous();
Pre_ID=rs.getInt("Id");
Pre_Order=rs.getInt("OrderList");
rs.next();
T_Order=rs.getInt("OrderList");
rs.close();
dt.commit("update menu set OrderList="+String.valueOf(Pre_Order)+" where Id="+String.valueOf(Id)+
";update menu set OrderList="+String.valueOf(T_Order)+" where Id="+String.valueOf(Pre_ID));
}
}catch(SQLException ex){
System.out.println("对某一字段进行排序上升一位，用于栏目同级之间的排序时发生错误。"+ex);
}
}
/**对某一字段进行排序下降一位，用于栏目同级之间的排序*/
public void MenuDownOneSort(int Id){
getDt();
int ParentID=dt.returnInt("select ParentId from menu where ID="+String.valueOf(Id));
//ReturnFieldValue("menu", "Id", String.valueOf(Id), "ParentID");
//String sql="select * from menu where ParentID="+String.valueOf(ParentID)+" order by OrderList";
try{
ResultSet rs = dt.getRs("select * from menu where ParentID="+String.valueOf(ParentID)+" order by OrderList");
int Allrows=dt.getRowCount();//得到当前SQL的行数
int Pre_ID,Pre_Order,T_Order;
int index=0;
while(rs.next()){
index++;
if(rs.getInt("Id")==Id)
break;
}if(index<Allrows){
T_Order=rs.getInt("OrderList");
rs.next();
Pre_ID=rs.getInt("Id");
Pre_Order=rs.getInt("OrderList");
rs.close();
dt.commit("update menu set OrderList="+String.valueOf(Pre_Order)+" where Id="+String.valueOf(Id)+
";update menu set OrderList="+String.valueOf(T_Order)+" where Id="+String.valueOf(Pre_ID));
}
}catch(SQLException ex){
System.out.println("对某一字段进行排序下降一位，用于栏目同级之间的排序时发生错误。"+ex);
}
}
/**对一个个字段进行排序，上升一位*/
public void OrderUpOne(String table,String field,int Id){
getDt();
String sql="select * from "+ table + " Order by " + field;
try{
ResultSet rs = dt.getRs("select * from "+ table + " Order by " + field);
int Pre_ID,Pre_Order,T_Order;
int index=0;
while(rs.next()){
index++;
if(rs.getInt("Id")==Id)
break;
}if(index>1){
rs.previous();
Pre_ID=rs.getInt("Id");
Pre_Order=rs.getInt(field);
rs.next();
T_Order=rs.getInt(field);
rs.close();
dt.commit("update "+table+" set "+field+"="+String.valueOf(Pre_Order)+" where Id="+String.valueOf(Id)+
";update "+table+" set "+field+"="+String.valueOf(T_Order)+" where Id="+String.valueOf(Pre_ID));
}
}catch(SQLException ex){
System.out.println("对某一字段进行排序上升一位，用于栏目同级之间的排序时发生错误。"+ex);
}
}
public void OrderDownOne(String table,String field,int Id){
getDt();
try {
ResultSet rs = dt.getRs("select * from "+table+" Order by "+field);
int Allrows=dt.getRowCount();//得到当前SQL的行数
int Pre_ID,Pre_Order,T_Order;
int index=0;
while(rs.next()){
index++;
if(rs.getInt("Id")==Id)
break;
}
if(index<Allrows){
T_Order=rs.getInt("OrderList");
rs.next();
Pre_ID=rs.getInt("Id");
Pre_Order=rs.getInt("OrderList");
rs.close();
dt.commit("update "+table+" set "+field+"="+String.valueOf(Pre_Order)+" where Id="+String.valueOf(Id)+
";update "+table+" set "+field+"="+String.valueOf(T_Order)+" where Id="+String.valueOf(Pre_ID));
}
}catch(SQLException ex){
System.out.println("对某一字段进行排序下降一位，用于栏目同级之间的排序时发生错误。"+ex);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -