sublmmodaction.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.action;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.db.ProxoolAction;
import com.opensymphony.xwork2.ActionSupport;

public class sublmmodAction extends ActionSupport {

	private static final long serialVersionUID = 5992498120879361156L;

	private int slmid = 0;
	private int lmid = 0;
	private String slmmc;

	public int getSlmid() {
		return slmid;
	}

	public void setSlmid(int slmid) {
		this.slmid = slmid;
	}

	public int getLmid() {
		return lmid;
	}

	public void setLmid(int lmid) {
		this.lmid = lmid;
	}
	
	public String getSlmmc() {
		return slmmc;
	}

	public void setSlmmc(String slmmc) {
		this.slmmc = slmmc;
	}

	@Override
	public String execute() throws Exception {
		String flag = "";
		Connection conn=null;
		PreparedStatement stmt=null;
		ResultSet rs=null;
		try {
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("select slmmc from w_sublmb where slmid="+slmid+" and sjlmid="+lmid);
			rs=stmt.executeQuery();
			while(rs.next())
			{
				slmmc=rs.getString(1);
			}
			setSlmmc(slmmc);
			flag=SUCCESS;
			System.out.println(slmmc+"子栏目名称");
		} catch (Exception e) {
			System.out.println(e.toString());
			flag=ERROR;
		}finally{
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return flag;
	}
}