vercomda.java

医药供应链管理系统

package com.captainli.dboperation;

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

import com.captainli.util.GetConnection;
import com.captainli.util.VerComData;

/**
 * vercom表  审核权限表 数据库操作类
 * @author CaptainLi
 *
 */
public class VercomDA {
	private Connection conn = GetConnection.getConn();
	private PreparedStatement pstmt = null;
	private Statement stmt = null;
	private ResultSet rs = null;
	/**
	 * 关闭数据库对象
	 *
	 */
	public void closeDB(){
		try {
			if(rs != null){
				rs.close();
			}
			if(stmt != null){
				stmt.close();
			}
			if(pstmt != null){
				pstmt.close();
			}
			if(conn != null){
				conn.close();
			}
		} catch (Exception e) {
			e.getStackTrace();
		}
	}
	/**
	 * 获得用户审核权限
	 * @param username
	 * @return
	 */
	public VerComData selectVerCom(String username){
		VerComData data = null;
		String sql = "select * from vercom where v_username = ?";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			rs = pstmt.executeQuery();
			while(rs.next()){
				data = new VerComData(rs.getString("v_username"), rs.getBoolean("v_aa"),
										rs.getBoolean("v_ab"), rs.getBoolean("v_ac"), 
										rs.getBoolean("v_ad"), rs.getBoolean("v_ba"), 
										rs.getBoolean("v_bb"), rs.getBoolean("v_bc"), 
										rs.getBoolean("v_bd"), rs.getBoolean("v_be"), rs.getBoolean("v_bf"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
		return data;
	}
	/**
	 * 添加权限
	 * @param data
	 */
	public void addVercom(VerComData data){
		String sql = "insert into vercom values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, data.getV_username());
			pstmt.setBoolean(2, data.isV_aa());
			pstmt.setBoolean(3, data.isV_ab());
			pstmt.setBoolean(4, data.isV_ac());
			pstmt.setBoolean(5, data.isV_ad());
			pstmt.setBoolean(6, data.isV_ba());
			pstmt.setBoolean(7, data.isV_bb());
			pstmt.setBoolean(8, data.isV_bc());
			pstmt.setBoolean(9, data.isV_bd());
			pstmt.setBoolean(10, data.isV_be());
			pstmt.setBoolean(11, data.isV_bf());
			pstmt.execute();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
	}
	/**
	 * 修改员工权限
	 * @param data
	 * @param v_username
	 */
	public void updateVercom(VerComData data, String v_username){
		String sql = "update vercom set v_aa = ?, v_ab = ?, v_ac = ?, v_ad = ?, v_ba = ?, v_bb = ?, v_bc = ?, v_bd = ?, v_be = ?, v_bf = ? where v_username = ?";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setBoolean(1, data.isV_aa());
			pstmt.setBoolean(2, data.isV_ab());
			pstmt.setBoolean(3, data.isV_ac());
			pstmt.setBoolean(4, data.isV_ad());
			pstmt.setBoolean(5, data.isV_ba());
			pstmt.setBoolean(6, data.isV_bb());
			pstmt.setBoolean(7, data.isV_bc());
			pstmt.setBoolean(8, data.isV_bd());
			pstmt.setBoolean(9, data.isV_be());
			pstmt.setBoolean(10, data.isV_bf());
			pstmt.setString(11, v_username);
			pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeDB();
		}
	}
	
	
}