📄 adminclass.java
字号:
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
ResultSet rs = null;
String sql = null;
String [] sa = new String [2];
int SpecialID = Fun.StrToInt(s);
if(SpecialID>0)
{
sql = "select * from Special where SpecialID=" + SpecialID;
rs = stmt.executeQuery(sql);
rs.next();
sa[0] = rs.getString(2);
sa[1] = rs.getString(3);
rs.close();
stmt.close();
Conn.close();
return sa;
}
else return null;
}catch(Exception e){
//e.printStackTrace();
return null;
}
}
/*********************************************************
* 函数名：AddBigClass
* 作 用：添加大类
* 参 数：s1，大类ID；s2，大类标题；
* s3，大类说明；s4,操作用户，s5，IP地址
* 返回值：字符串型。返回操作的信息
***********************************************************/
public String AddBigClass(String s1,String s2,String s3,String s4,String s5)
{
try
{
boolean OK = true;
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
Statement stmt1 = Conn.createStatement(1004,1007);
ResultSet rs = null;
String sError = "";
int BigClassID = Fun.StrToInt(s1);
String BigClassName = Fun.CheckReplace(s2);
String BigClassInfo = Fun.CheckReplace(s3);
String [] sa1 = new String [3];
String [] sa2 = new String [3];
sa1[0] = s1;
sa1[1] = s2;
sa1[2] = s3;
sa2[0] = "大类排序";
sa2[1] = "大类标题";
sa2[2] = "大类说明";
String s = Fun.CheckDate(sa1,sa2);
if (BigClassID==0)
{
OK = false;
sError = "类别排序必须是大于 0 的整数!";
}
if (!s.equals("Yes"))
{
OK = false;
sError = s;
}
if(OK)
{
String sql1 = "select * from BigClass where BigClassID=" + BigClassID;
String sql2 = "select * from BigClass where BigClassName='" + BigClassName + "'";
ResultSet rs1 = stmt.executeQuery(sql1);
ResultSet rs2 = stmt1.executeQuery(sql2);
if (rs1.next())
{
rs1.close();
OK = false;
sError = "<li>该排序数字 [ " + s1 + " ] 已经存在，不能重复!";
}
if (rs2.next())
{
rs2.close();
stmt1.close();
OK = false;
sError += "<li>该大类标题 [ " + s2 + " ] 已经存在，不能重复!";
}
}
if(OK)
{
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
String sql = "insert into BigClass (BigClassID,BigClassName,";
sql += "BigClassInfo,AddTime) values (";
sql += BigClassID + ",";
sql += "'" + BigClassName + "',";
sql += "'" + BigClassInfo + "',";
sql += "'" + NowTime + "')";
stmt.executeUpdate(sql);
sLog[0] = Fun.CheckReplace(s4);
sLog[1] = "添加大类[" + BigClassName + "]";
sLog[2] = NowTime;
sLog[3] = Fun.CheckReplace(s5);
sLog[4] = "Yes";
Fun.AddLog(sLog);
stmt.close();
Conn.close();
return "Yes";
}
else return sError;
}catch(Exception e)
{
////e.printStackTrace();
//ystem.out.print(e.getMessage());
return "操作失败!";
}
}
/*********************************************************
* 函数名：EditBigClass
* 作 用：修改大类
* 参 数：s1，大类新ID；s2，大类标题；
* s3，大类说明；s4，大类原ID；s5，原大类标题；
* s6，用户，s7，IP
* 返回值：字符串型。返回操作的信息
***********************************************************/
public String EditBigClass(String s1,String s2,String s3,String s4,String s5,String s6,String s7)
{
try
{
Connection Conn = DBConn.getConn();
Connection Conn1 = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
Statement stmt1 = Conn1.createStatement(1004,1007);
Statement stmt2 = Conn1.createStatement(1004,1007);
ResultSet rs1 = null;
ResultSet rs2 = null;
boolean OK=true;
String sError="";
int NewBigClassID = Fun.StrToInt(s1);
int OldBigClassID = Fun.StrToInt(s4);
String NewBigClassName = Fun.CheckReplace(s2);
String OldBigClassName = Fun.CheckReplace(s5);
String BigClassInfo = Fun.CheckReplace(s3);
String [] sa1 = new String [3];
String [] sa2 = new String [3];
sa1[0] = s1;
sa1[1] = s2;
sa1[2] = s3;
sa2[0] = "大类排序";
sa2[1] = "大类标题";
sa2[2] = "大类说明";
String s = Fun.CheckDate(sa1,sa2);
if (NewBigClassID==0)
{
OK = false;
sError = "类别排序必须是大于 0 的整数!";
}
if (!s.equals("Yes"))
{
OK = false;
sError = s;
}
if (OK)
{
String sql1 = "select * from BigClass where BigClassID=" + NewBigClassID;
String sql2 = "select * from BigClass where BigClassName='" + NewBigClassName + "'";
rs1 = stmt1.executeQuery(sql1);
rs2 = stmt2.executeQuery(sql2);
rs1.last();
rs2.last();
if ((NewBigClassID != OldBigClassID) && rs1.getRow()>0)
{
rs1.close();
stmt1.close();
sError = "<li>该排序数字 [ " + s1 + " ] 已经存在，不能重复!";
OK = false;
}
if ((!OldBigClassName.equals(NewBigClassName)) && rs2.getRow()>0)
{
rs2.close();
stmt2.close();
sError += "<li>该大类标题 [ " + NewBigClassName + " ] 已经存在，不能重复!";
OK = false;
}
}
if(OK)
{
String sql = "update BigClass set ";
sql += "BigClassID='" + NewBigClassID + "',";
sql += "BigClassName='" + NewBigClassName + "',";
sql += "BigClassInfo='" + BigClassInfo + "'";
sql += " where BigClassID=" + OldBigClassID;
String sql1 = "update SmallClass set BigClassID=" + NewBigClassID + " where BigClassID=" + OldBigClassID;
String sql2 = "update News set BigClassID=" + NewBigClassID + " where BigClassID=" + OldBigClassID;
try
{
Conn.setAutoCommit(false); //更改JDBC默认事务提交方式
stmt.executeUpdate(sql);
stmt.executeUpdate(sql1);
stmt.executeUpdate(sql2);
Conn.commit(); //确认事务
Conn.setAutoCommit(true); //设为默认
stmt.close();
Conn.close();
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
sLog[0] = Fun.CheckReplace(s6);
sLog[1] = "修改原大类[" + OldBigClassName + "]为[" + NewBigClassName + "]";
sLog[2] = NowTime;
sLog[3] = Fun.CheckReplace(s7);
sLog[4] = "Yes";
Fun.AddLog(sLog);
return "Yes";
}catch (Exception e) {
Conn.rollback(); //回滚JDBC事务
//e.printStackTrace();
Conn.close();
return "事务操作失败!";
}
}
else return sError;
}catch(Exception e)
{
////e.printStackTrace();
//System.out.print(sql);
return "操作失败!";
}
}
/*********************************************************
* 函数名：DelBigClass
* 作 用：删除大类
* 参 数：s1，大类新ID，s2，操作用户，s3，IP地址
* 返回值：字符串型。返回操作的信息
***********************************************************/
public boolean DelBigClass(String s1,String s2,String s3)
{
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
sLog[0] = s2;
sLog[2] = NowTime;
sLog[3] = s3;
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
boolean OK=true;
int BigClassID = Fun.StrToInt(s1);
String sql1 = "delete from BigClass where BigClassID=" + BigClassID;
String sql2 = "delete from SmallClass where BigClassID=" + BigClassID;
String sql3 = "delete from News where BigClassID=" + BigClassID;
if (BigClassID>0)
{
try{
Conn.setAutoCommit(false); //更改JDBC默认事务提交方式
stmt.executeUpdate(sql1);
stmt.executeUpdate(sql2);
stmt.executeUpdate(sql3);
Conn.commit();
Conn.setAutoCommit(true);
stmt.close();
Conn.close();
sLog[0] = Fun.CheckReplace(s2);
sLog[1] = "删除ID为 [ " + s1 + " ] 的大类";
sLog[2] = NowTime;
sLog[3] = Fun.CheckReplace(s3);
sLog[4] = "Yes";
Fun.AddLog(sLog);
return true;
}catch (Exception e) {
Conn.rollback(); //回滚JDBC事务
//e.printStackTrace();
Conn.close();
return false;
}
}else return false;
}catch(SQLException e)
{
////e.printStackTrace();
sLog[1] = "删除ID为[" + s1 + "]的大类，操作出错!";
sLog[4] = "No";
Fun.AddLog(sLog);
//System.out.print(sql);
return false;
}
}
/*********************************************************
* 函数名：AddSClass
* 作 用：添加大类
* 参 数：s2，小类标题；s3，小类说明
* s4,所属大类，s5,操作用户，s6，IP地址
* 返回值：字符串型。返回操作的信息
***********************************************************/
public String AddSClass(String s2,String s3,String s4,String s5,String s6)
{
try
{
boolean OK = true;
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
Statement stmt1 = Conn.createStatement(1004,1007);
ResultSet rs = null;
String sError = "";
int BigClassID = Fun.StrToInt(s4);
String SClassName = Fun.CheckReplace(s2);
String SClassInfo = Fun.CheckReplace(s3);
String [] sa1 = new String [2];
String [] sa2 = new String [2];
sa1[0] = s2;
sa1[1] = s3;
sa2[0] = "小类标题";
sa2[1] = "小类说明";
String s = Fun.CheckDate(sa1,sa2);
if (!s.equals("Yes"))
{
OK = false;
sError = s;
}
if (BigClassID==0)
{
OK = false;
sError = "所属大类参数传递错误，请重试!";
}
if(OK)
{
String sql2 = "select * from SmallClass where SmallClassName='" + SClassName + "' and BigClassID=" + BigClassID;
ResultSet rs2 = stmt1.executeQuery(sql2);
if (rs2.next())
{
rs2.close();
stmt1.close();
OK = false;
sError += "<li>该小类标题 [ " + s2 + " ] 已经存在，不能重复!";
}
}
if(OK)
{
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
String sql = "insert into SmallClass (SmallClassName,";
sql += "SmallClassInfo,BigClassID,AddTime) values (";
sql += "'" + SClassName + "',";
sql += "'" + SClassInfo + "',";
sql += BigClassID + ",";
sql += "'" + NowTime + "')";
stmt.executeUpdate(sql);
sLog[0] = Fun.CheckReplace(s5);
sLog[1] = "添加小类[" + SClassName + "]";
sLog[2] = NowTime;
sLog[3] = Fun.CheckReplace(s6);
sLog[4] = "Yes";
Fun.AddLog(sLog);
stmt.close();
Conn.close();
return "Yes";
}
else return sError;
}catch(SQLException e)
{
////e.printStackTrace();
//ystem.out.print(e.getMessage());
return "操作失败!";
}
}
/*********************************************************
* 函数名：EditSClass
* 作 用：修改小类
* 参 数：s0，所属大类，s1,小类ID;s2，小类标题；
* s3，小类说明；s4，原小类标题；
* s5，用户，s6，IP
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -