?? cata.java
字號:
package popten.web;
import popten.db.DBConnect;
import popten.util.*;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;
public class Cata{
private String cata_id,cata_name,cata_coun;
public String getcata_id() { return cata_id;}
public String getcata_name() { return cata_name;}
public String getcata_coun() { return cata_coun;}
public void setcata_id(String cata_id) { this.cata_id = cata_id; }
public void setcata_name(String cata_name) { this.cata_name = cata_name; }
public void setcata_coun(String cata_coun) { this.cata_coun = cata_coun; }
public Cata(){}
/**
* 讀取一級目錄基本信息
*/
public Vector Cata0All(){
DBConnect dbc = null;
Vector cataVector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("Select * from cata0");
ResultSet rs = dbc.executeQuery();
while(rs.next()){
Cata cata = new Cata();
cata.setcata_id(rs.getString("cata0_id"));
cata.setcata_name(rs.getString("cata0_name"));
cata.setcata_coun(rs.getString("coun"));
cataVector.add(cata);
}
}
catch(Exception e){
System.err.println(e+"error");
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return cataVector;
}
/**
* 添加一級目錄基本信息
*/
public static void addCata0(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String cata0_name = ParamUtils.getString(request,"cata0_name","");
DBConnect dbc = new DBConnect();
ResultSet rs;
if(cata0_name.equals("") || cata0_name==null){
errMsg = errMsg + "□ 您沒有輸入一級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
dbc.prepareStatement("Select * from cata0 where cata0_name=?");
dbc.setBytes(1,cata0_name.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
rs.close();
errMsg = errMsg + "□ 您輸入的一級目錄名已經(jīng)存在！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(!foundErr){
dbc.prepareStatement("INSERT INTO cata0 (cata0_name) VALUES (?)");
dbc.setBytes(1,cata0_name.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 修改一級目錄基本信息
*/
public static void editCata0(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String cata0_name = ParamUtils.getString(request,"cata0_name","");
String cata0_id = ParamUtils.getString(request,"cata0_id","");
DBConnect dbc = new DBConnect();
ResultSet rs;
if(cata0_name.equals("") || cata0_name==null){
errMsg = errMsg + "□ 您沒有輸入一級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(cata0_id.equals("") || cata0_id==null){
errMsg = errMsg + "□ 您沒有輸入序號!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
dbc.prepareStatement("Select * from cata0 where cata0_name=?");
dbc.setBytes(1,cata0_name.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
rs.close();
errMsg = errMsg + "□ 您輸入的一級目錄名已經(jīng)存在！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(!foundErr){
dbc.prepareStatement("UPDATE cata0 SET cata0_name=? WHERE cata0_id=?");
dbc.setBytes(1,cata0_name.getBytes("GBK"));
dbc.setBytes(2,cata0_id.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 讀取二級目錄基本信息
*/
public Vector Cata1All(String cata0_id) throws Exception {
boolean foundErr = false;
String errMsg="";
//String cata0_id = ParamUtils.getString(request,"cata0_id","");
if(cata0_id.equals("") || cata0_id==null || cata0_id.equals("0")){
errMsg = errMsg + "□ 您沒有選擇一級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(foundErr) throw new Exception(errMsg);
DBConnect dbc = null;
Vector cata1Vector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("Select * from cata1 where cata0_id="+cata0_id);
ResultSet rs = dbc.executeQuery();
while(rs.next()){
Cata cata1 = new Cata();
cata1.setcata_id(rs.getString("cata1_id"));
cata1.setcata_name(rs.getString("cata1_name"));
cata1.setcata_coun(rs.getString("coun"));
cata1Vector.add(cata1);
}
}
catch(Exception e){
System.err.println(e+"error");
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return cata1Vector;
}
/**
* 添加二級目錄基本信息
*/
public static void addCata1(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String cata1_name = ParamUtils.getString(request,"cata1_name","");
String cata0_id = ParamUtils.getString(request,"cata0_id","");
DBConnect dbc = new DBConnect();
ResultSet rs;
if(cata1_name.equals("") || cata1_name==null){
errMsg = errMsg + "□ 您沒有輸入二級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(cata0_id.equals("") || cata0_id==null || cata0_id.equals("0")){
errMsg = errMsg + "□ 您沒有選擇一級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
dbc.prepareStatement("Select * from cata1 where cata1_name=?");
dbc.setBytes(1,cata1_name.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
rs.close();
errMsg = errMsg + "□ 您輸入的二級目錄名已經(jīng)存在！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(!foundErr){
dbc.prepareStatement("INSERT INTO cata1 (cata1_name,cata0_id) VALUES (?,?)");
dbc.setBytes(1,cata1_name.getBytes("GBK"));
dbc.setBytes(2,cata0_id.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 修改二級目錄基本信息
*/
public static void editCata1(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String cata1_name = ParamUtils.getString(request,"cata1_name","");
String cata1_id = ParamUtils.getString(request,"cata1_id","");
DBConnect dbc = new DBConnect();
ResultSet rs;
if(cata1_name.equals("") || cata1_name==null){
errMsg = errMsg + "□ 您沒有輸入二級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(cata1_id.equals("") || cata1_id==null){
errMsg = errMsg + "□ 您沒有輸入序號!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
dbc.prepareStatement("Select * from cata1 where cata1_name=?");
dbc.setBytes(1,cata1_name.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
rs.close();
errMsg = errMsg + "□ 您輸入的二級目錄名已經(jīng)存在！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(!foundErr){
dbc.prepareStatement("UPDATE cata1 SET cata1_name=? WHERE cata1_id=?");
dbc.setBytes(1,cata1_name.getBytes("GBK"));
dbc.setBytes(2,cata1_id.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 讀取三級目錄基本信息
*/
public Vector Cata2All(String cata1_id) throws Exception {
boolean foundErr = false;
String errMsg="";
//String cata1_id = ParamUtils.getString(request,"cata1_id","");
if(cata1_id.equals("") || cata1_id==null || cata1_id.equals("0")){
errMsg = errMsg + "□ 您沒有選擇二級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(foundErr) throw new Exception(errMsg);
DBConnect dbc = null;
Vector cata2Vector = new Vector();
try{
dbc = new DBConnect();
dbc.prepareStatement("Select * from cata2 where cata1_id="+cata1_id);
ResultSet rs = dbc.executeQuery();
while(rs.next()){
Cata cata2 = new Cata();
cata2.setcata_id(rs.getString("cata2_id"));
cata2.setcata_name(rs.getString("cata2_name"));
cata2.setcata_coun(rs.getString("coun"));
cata2Vector.add(cata2);
}
}
catch(Exception e){
System.err.println(e+"error");
}
finally{
try{
dbc.close();
}
catch(Exception e){
e.printStackTrace();
}
}
return cata2Vector;
}
/**
* 添加三級目錄基本信息
*/
public static void addCata2(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String cata2_name = ParamUtils.getString(request,"cata2_name","");
String cata1_id = ParamUtils.getString(request,"cata1_id","");
DBConnect dbc = new DBConnect();
ResultSet rs;
if(cata2_name.equals("") || cata2_name==null){
errMsg = errMsg + "□ 您沒有輸入三級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(cata1_id.equals("") || cata1_id==null || cata1_id.equals("0")){
errMsg = errMsg + "□ 您沒有選擇二級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
dbc.prepareStatement("Select * from cata2 where cata2_name=?");
dbc.setBytes(1,cata2_name.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
rs.close();
errMsg = errMsg + "□ 您輸入的三級目錄名已經(jīng)存在！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(!foundErr){
dbc.prepareStatement("INSERT INTO cata2 (cata2_name,cata1_id) VALUES (?,?)");
dbc.setBytes(1,cata2_name.getBytes("GBK"));
dbc.setBytes(2,cata1_id.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
/**
* 修改三級目錄基本信息
*/
public static void editCata2(HttpServletRequest request) throws Exception {
boolean foundErr = false;
String errMsg="";
String cata2_name = ParamUtils.getString(request,"cata2_name","");
String cata2_id = ParamUtils.getString(request,"cata2_id","");
DBConnect dbc = new DBConnect();
ResultSet rs;
if(cata2_name.equals("") || cata2_name==null){
errMsg = errMsg + "□ 您沒有輸入三級目錄名!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(cata2_id.equals("") || cata2_id==null){
errMsg = errMsg + "□ 您沒有輸入序號!<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
if(!foundErr){
dbc.prepareStatement("Select * from cata2 where cata2_name=?");
dbc.setBytes(1,cata2_name.getBytes("GBK"));
rs=dbc.executeQuery();
if(rs.next()){
rs.close();
errMsg = errMsg + "□ 您輸入的三級目錄名已經(jīng)存在！<br>□ 五秒鐘后會自動返回上一頁。<br><meta HTTP-EQUIV=REFRESH CONTENT='5; URL=javascript:history.go(-1)'>";
foundErr = true;
}
}
if(!foundErr){
dbc.prepareStatement("UPDATE cata2 SET cata2_name=? WHERE cata2_id=?");
dbc.setBytes(1,cata2_name.getBytes("GBK"));
dbc.setBytes(2,cata2_id.getBytes("GBK"));
dbc.executeUpdate();
dbc.close();
}
if(foundErr) throw new Exception(errMsg);
}
}?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -