actorrightdao.java

实现办公自动化系统

package com.oa.struts.systemManager.actorDAO;
import java.sql.*;

import com.oa.util.DBConn;
public class ActorRightDAO 
{
	public Connection con;
	public Statement stmt;
	public PreparedStatement pstmt;
	public ResultSet rs;
	DBConn db;
	public ActorRightDAO()
	{
		
	}
	
	public boolean insert()
	{
		boolean flag=false;
		db=new DBConn();
		con=db.getConnection();
		try
		{
			stmt=con.createStatement();
			String sql="insert into tb_actor_right values(actright_seq.nextval,actor_seq.nextval-1,rights_seq.nextval-1)";
			int i=stmt.executeUpdate(sql);
			if(i>0)
			{
				flag=true;
			}
			con.commit();
		}
		catch(SQLException e)
		{
			try{
				if(con!=null)
				{
					con.rollback();
				}
			}
			catch(SQLException e1)
			{
				e1.printStackTrace();
			}
			e.printStackTrace();
		}
		finally
		{
			try{
				if(con!=null)
				{con.close();}
				if(stmt!=null)
				{
					stmt.close();
				}
				if(rs!=null)
				{rs.close();}
			}
			catch(SQLException e2)
			{e2.printStackTrace();}
		}
		
		return flag;
	}
}