addsublmaction.java

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

package com.comingnet.action;

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

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

public class AddSublmAction extends ActionSupport {

	private static final long serialVersionUID = -555128615619655834L;
	
	private String sublmmc="";
	
	private int lmid=0;

	public String getSublmmc() {
		return sublmmc;
	}

	public void setSublmmc(String sublmmc) {
		this.sublmmc = sublmmc;
	}

	public int getLmid() {
		return lmid;
	}

	public void setLmid(int lmid) {
		this.lmid = lmid;
	}

	@Override
	public String execute() throws Exception {
		Connection conn=null;
		PreparedStatement stmt=null;
		String flag="";
		int slmid=KeyGenerator.getInstance().getNextKey("w_sublmb");
		
		try {
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("insert into w_sublmb(slmid,slmmc,sjlmid) values(?,?,?)");
			stmt.setInt(1, slmid);
			stmt.setString(2, sublmmc);
			stmt.setInt(3, lmid);
			stmt.executeUpdate();
			flag=SUCCESS;
		} catch (Exception e) {
			System.out.println(e.toString());
			flag=ERROR;
		}
		return flag;
	}
	
	

}