roleright.java

(Java+SQL)-大型企业JAVA的ERP系统

//Source file: D:\work\五洋\javaBean\src\RoleRight.java

package src.com;

import java.sql.*;
import java.io.*;

public class RoleRight extends ShangObject
{
   
   /**
角色编号
   */
   private int roleId;
   
      
   /**
角色名称
   */
   private String roleName;
   
   
   
   public RoleRight() 
   {
        primarykey1Name = "roleId"; 
	primarykey1Type = 0; 
	tableName = "RoleRight";  
	viewName = "RoleRight";
	numInOnePager = 10;
   
   }
   
  public int loadAttr() {
      try {
         roleId = rs.getInt("roleId");
         roleName = getRsString(rs,"roleName");
      	 
      } catch(SQLException e) {
   	 e.printStackTrace();
   	 System.out.println("query failed!");
   	 return -1;
      }
      return 1;
      }

  /*
      新增角色
      	@loginName varchar(30) 
	,@ip varchar(20) 
	,@machineName varchar(30) 
	,@roleId   int
	,@roleName  varchar(30) 
  */
  public int insert(){
	String sql= "{?=call sp_InsertRoleRight(?,?,?,?,?)}";
     try{
	CallableStatement updStmt=conn.prepareCall(sql);
	updStmt.registerOutParameter(1, java.sql.Types.INTEGER);/** 注册OUT参数 */
	setStmtString(updStmt, 2, theGlobal.loginName);
	setStmtString(updStmt, 3, theGlobal.ip);
	setStmtString(updStmt, 4, theGlobal.machineName);
        updStmt.setInt(5,roleId);
        setStmtString(updStmt,6,roleName);
        updStmt.executeUpdate();
        int rtcode = updStmt.getInt(1);
	updStmt.close();
	return rtcode; 
      }catch(SQLException E){
      	System.out.println(E.getMessage());
      	return -102;
      }

}

/*
    修改
    	@loginName varchar(30) 
	,@ip varchar(20) 
	,@machineName varchar(30) 
	,@roleId   int
	,@roleName  varchar(30)  
*/  
  public int update() {
  	
     String sql= "{?=call sp_UpdateRoleRight(?,?,?,?,?)}";
     try{
	CallableStatement updStmt=conn.prepareCall(sql);
	updStmt.registerOutParameter(1, java.sql.Types.INTEGER);/** 注册OUT参数 */
	setStmtString(updStmt, 2, theGlobal.loginName);
	setStmtString(updStmt, 3, theGlobal.ip);
	setStmtString(updStmt, 4, theGlobal.machineName);
        updStmt.setInt(5,roleId);
        setStmtString(updStmt,6,roleName);
        updStmt.executeUpdate();
        int rtcode = updStmt.getInt(1);
	updStmt.close();
	return rtcode; 
      }catch(SQLException E){
      	System.out.println(E.getMessage());
      	return -102;
      }
}


   /**
* Access method for the roleId property.
*
* @return   the current value of the roleId property
   */
   public int getRoleId() {
      return roleId;}
   
   /**
* Sets the value of the roleId property.
*
* @param aRoleId the new value of the roleId property
   */
   public void setRoleId(int aRoleId) {
      roleId = aRoleId;}
   

   
   /**
* Access method for the roleName property.
*
* @return   the current value of the roleName property
   */
   public String getRoleName() {
      return roleName;}
   
   /**
* Sets the value of the roleName property.
*
* @param aRoleName the new value of the roleName property
   */
   public void setRoleName(String aRoleName) {
      try{
      	roleName = new String(aRoleName.getBytes("8859_1"));
      }catch(UnsupportedEncodingException e) {
      	System.out.println("error in getbytes");
      }
      }
 
}