studentupdateaction.java

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

package com.comingnet.action;

import com.comingnet.bean.UserInfor;
import com.comingnet.intercepter.UserSessionAware;
import com.opensymphony.xwork2.ActionSupport;
import com.comingnet.bean.*;
import java.sql.*;
import com.db.*;
public class StudentUpdateAction extends ActionSupport implements UserSessionAware{
	private UserInfor userSession=null;
	private String auid_test="5";
	private  studentInfor  stuinfor=new studentInfor();
	private int xsid;
	
	public int getXsid() {
		return xsid;
	} 
	public void setXsid(int xsid) {
		this.xsid = xsid; 
	}
	public studentInfor getStuinfor() {
		return stuinfor;
	}
	public void setStuinfor(studentInfor stuinfor) {
		this.stuinfor = stuinfor;
	}
	public String getAuid_test() {
		return auid_test;
	}
	public void setAuid_test(String auid_test) {
		this.auid_test = auid_test;
	}
	public UserInfor getUserSession() {
		return userSession;
	}
	public void setUserSession(UserInfor userSession) {
		this.userSession = userSession;
	}
	
	public String execute()
	{
        Connection conn=null;
        PreparedStatement stmt=null; 
        ResultSet rs=null;
        String flag=ERROR;
		try
        {
        	conn=DBUtils.getConnection();
        	stmt=conn.prepareStatement("select xsxm,xsyj,xszh,a.xxbh as xxbh,bjmc,xsbjbh,xsbz,CONVERT(varchar,xscsrq,20) as xscsrq,xsdh,xsid,xsfmxx,xsjg,xsjtdz,xssfz,xsxb,xsxh from m_student a,m_class b where a.xsbjbh=b.bjid and xsid=?");
        	stmt.setInt(1,getXsid());
        	rs=stmt.executeQuery();
        	if(rs.next())
        	{
        		stuinfor.setXsbjbh(rs.getInt("xxbh"));
        		stuinfor.setXsbjmc(rs.getString("bjmc"));
        		stuinfor.setXsbjbh(rs.getInt("xsbjbh"));
        		stuinfor.setXsbz(rs.getString("xsbz"));
        		stuinfor.setXscsrq(rs.getString("xscsrq"));
        		stuinfor.setXsdh(rs.getString("xsdh"));
        		stuinfor.setXsfmxx(rs.getString("xsfmxx"));
        		stuinfor.setXsid(rs.getInt("xsid"));
        		stuinfor.setXsjg(rs.getString("xsjg"));
        		stuinfor.setXsjtdz(rs.getString("xsjtdz"));
        		stuinfor.setXssfz(rs.getString("xssfz"));
        		stuinfor.setXsxb(rs.getString("xsxb"));
        		stuinfor.setXsxh(rs.getString("xsxh"));
        		stuinfor.setXsxm(rs.getString("xsxm"));
        		stuinfor.setXsyj(rs.getString("xsyj"));
        		stuinfor.setXszh(rs.getString("xszh"));
        		setStuinfor(stuinfor);
        		flag=SUCCESS;
        	}
        }catch(Exception e)
        {
        	System.out.println("-------->"+e);
        }finally
        {
           DBUtils.closeResultSet(rs);
           DBUtils.closeStatement(stmt);
           DBUtils.closeConnection(conn);
        }
		return flag;
	}
	
	

}