📄 competenceda.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.struts.form.LoginForm;
import com.captainli.util.CompetenceData;
import com.captainli.util.GetConnection;
/**
* competence表数据库操作类
* @author CaptainLi
*
*/
public class CompetenceDA {
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 form
* @return
*/
public CompetenceData selectCom(LoginForm form){
CompetenceData data = null;
String sql = "select * from competence where c_username = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, form.getL_username());
rs = pstmt.executeQuery();
while(rs.next()){
data = new CompetenceData( rs.getString("c_username"),
rs.getBoolean("c_a"),
rs.getBoolean("c_aa"),
rs.getBoolean("c_ab"),
rs.getBoolean("c_ac"),
rs.getBoolean("c_ad"),
rs.getBoolean("c_ae"),
rs.getBoolean("c_b"),
rs.getBoolean("c_ba"),
rs.getBoolean("c_bb"),
rs.getBoolean("c_bc"),
rs.getBoolean("c_bd"),
rs.getBoolean("c_c"),
rs.getBoolean("c_ca"),
rs.getBoolean("c_cb"),
rs.getBoolean("c_cc"),
rs.getBoolean("c_cd"),
rs.getBoolean("c_ce"),
rs.getBoolean("c_cf"),
rs.getBoolean("c_cg"),
rs.getBoolean("c_d"),
rs.getBoolean("c_da"),
rs.getBoolean("c_db"),
rs.getBoolean("c_dc"),
rs.getBoolean("c_dd"),
rs.getBoolean("c_de"),
rs.getBoolean("c_df"),
rs.getBoolean("c_dg"),
rs.getBoolean("c_dh"),
rs.getBoolean("c_di"),
rs.getBoolean("c_e"),
rs.getBoolean("c_ea"),
rs.getBoolean("c_eb"),
rs.getBoolean("c_ec"),
rs.getBoolean("c_ed"),
rs.getBoolean("c_ee"),
rs.getBoolean("c_ef"),
rs.getBoolean("c_eg"),
rs.getBoolean("c_eh"),
rs.getBoolean("c_ei"),
rs.getBoolean("c_ej"),
rs.getBoolean("c_f"),
rs.getBoolean("c_fa"),
rs.getBoolean("c_fb"),
rs.getBoolean("c_fc"),
rs.getBoolean("c_fd"),
rs.getBoolean("c_fe")
);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeDB();
}
return data;
}
/**
* 获得用户权限
* @param form
* @return
*/
public CompetenceData selectCom(String username){
CompetenceData data = null;
String sql = "select * from competence where c_username = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
rs = pstmt.executeQuery();
while(rs.next()){
data = new CompetenceData( rs.getString("c_username"),
rs.getBoolean("c_a"),
rs.getBoolean("c_aa"),
rs.getBoolean("c_ab"),
rs.getBoolean("c_ac"),
rs.getBoolean("c_ad"),
rs.getBoolean("c_ae"),
rs.getBoolean("c_b"),
rs.getBoolean("c_ba"),
rs.getBoolean("c_bb"),
rs.getBoolean("c_bc"),
rs.getBoolean("c_bd"),
rs.getBoolean("c_c"),
rs.getBoolean("c_ca"),
rs.getBoolean("c_cb"),
rs.getBoolean("c_cc"),
rs.getBoolean("c_cd"),
rs.getBoolean("c_ce"),
rs.getBoolean("c_cf"),
rs.getBoolean("c_cg"),
rs.getBoolean("c_d"),
rs.getBoolean("c_da"),
rs.getBoolean("c_db"),
rs.getBoolean("c_dc"),
rs.getBoolean("c_dd"),
rs.getBoolean("c_de"),
rs.getBoolean("c_df"),
rs.getBoolean("c_dg"),
rs.getBoolean("c_dh"),
rs.getBoolean("c_di"),
rs.getBoolean("c_e"),
rs.getBoolean("c_ea"),
rs.getBoolean("c_eb"),
rs.getBoolean("c_ec"),
rs.getBoolean("c_ed"),
rs.getBoolean("c_ee"),
rs.getBoolean("c_ef"),
rs.getBoolean("c_eg"),
rs.getBoolean("c_eh"),
rs.getBoolean("c_ei"),
rs.getBoolean("c_ej"),
rs.getBoolean("c_f"),
rs.getBoolean("c_fa"),
rs.getBoolean("c_fb"),
rs.getBoolean("c_fc"),
rs.getBoolean("c_fd"),
rs.getBoolean("c_fe")
);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeDB();
}
return data;
}
/**
* 权限设置
* @param data
*/
public void addCom(CompetenceData data){
String sql = "insert into competence values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, data.getC_username());
pstmt.setBoolean(2, data.isC_a());
pstmt.setBoolean(3, data.isC_aa());
pstmt.setBoolean(4, data.isC_ab());
pstmt.setBoolean(5, data.isC_ac());
pstmt.setBoolean(6, data.isC_ad());
pstmt.setBoolean(7, data.isC_ae());
pstmt.setBoolean(8, data.isC_b());
pstmt.setBoolean(9, data.isC_ba());
pstmt.setBoolean(10, data.isC_bb());
pstmt.setBoolean(11, data.isC_bc());
pstmt.setBoolean(12, data.isC_bd());
pstmt.setBoolean(13, data.isC_c());
pstmt.setBoolean(14, data.isC_ca());
pstmt.setBoolean(15, data.isC_cb());
pstmt.setBoolean(16, data.isC_cc());
pstmt.setBoolean(17, data.isC_cd());
pstmt.setBoolean(18, data.isC_ce());
pstmt.setBoolean(19, data.isC_cf());
pstmt.setBoolean(20, data.isC_cg());
pstmt.setBoolean(21, data.isC_d());
pstmt.setBoolean(22, data.isC_da());
pstmt.setBoolean(23, data.isC_db());
pstmt.setBoolean(24, data.isC_dc());
pstmt.setBoolean(25, data.isC_dd());
pstmt.setBoolean(26, data.isC_de());
pstmt.setBoolean(27, data.isC_df());
pstmt.setBoolean(28, data.isC_dg());
pstmt.setBoolean(29, data.isC_dh());
pstmt.setBoolean(30, data.isC_di());
pstmt.setBoolean(31, data.isC_e());
pstmt.setBoolean(32, data.isC_ea());
pstmt.setBoolean(33, data.isC_eb());
pstmt.setBoolean(34, data.isC_ec());
pstmt.setBoolean(35, data.isC_ed());
pstmt.setBoolean(36, data.isC_ee());
pstmt.setBoolean(37, data.isC_ef());
pstmt.setBoolean(38, data.isC_eg());
pstmt.setBoolean(39, data.isC_eh());
pstmt.setBoolean(40, data.isC_ei());
pstmt.setBoolean(41, data.isC_ej());
pstmt.setBoolean(42, data.isC_f());
pstmt.setBoolean(43, data.isC_fa());
pstmt.setBoolean(44, data.isC_fb());
pstmt.setBoolean(45, data.isC_fc());
pstmt.setBoolean(46, data.isC_fd());
pstmt.setBoolean(47, data.isC_fe());
pstmt.execute();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeDB();
}
}
/**
* 修改员工权限
* @param data
* @param c_username
*/
public void updateCom(CompetenceData data, String c_username){
String sql = "update competence set c_a = ?, c_aa = ?, c_ab = ?, c_ac = ?, c_ad = ?, c_ae = ?, " +
"c_b = ?, c_ba = ?, c_bb = ?, c_bc = ?, c_bd = ?, " +
"c_c = ?, c_ca = ?, c_cb = ?, c_cc = ?, c_cd = ?, c_ce = ?, c_cf = ?, c_cg = ?, " +
"c_d = ?, c_da = ?, c_db = ?, c_dc = ?, c_dd = ?, c_de = ?, c_df = ?, c_dg = ?, c_dh = ?, c_di = ?, " +
"c_e = ?, c_ea = ?, c_eb = ?, c_ec = ?, c_ed = ?, c_ee = ?, c_ef = ?, c_eg = ?, c_eh = ?, c_ei = ?, c_ej = ?, " +
"c_f = ?, c_fa = ?, c_fb = ?, c_fc = ?, c_fd = ?, c_fe = ? where c_username = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setBoolean(1, data.isC_a());
pstmt.setBoolean(2, data.isC_aa());
pstmt.setBoolean(3, data.isC_ab());
pstmt.setBoolean(4, data.isC_ac());
pstmt.setBoolean(5, data.isC_ad());
pstmt.setBoolean(6, data.isC_ae());
pstmt.setBoolean(7, data.isC_b());
pstmt.setBoolean(8, data.isC_ba());
pstmt.setBoolean(9, data.isC_bb());
pstmt.setBoolean(10, data.isC_bc());
pstmt.setBoolean(11, data.isC_bd());
pstmt.setBoolean(12, data.isC_c());
pstmt.setBoolean(13, data.isC_ca());
pstmt.setBoolean(14, data.isC_cb());
pstmt.setBoolean(15, data.isC_cc());
pstmt.setBoolean(16, data.isC_cd());
pstmt.setBoolean(17, data.isC_ce());
pstmt.setBoolean(18, data.isC_cf());
pstmt.setBoolean(19, data.isC_cg());
pstmt.setBoolean(20, data.isC_d());
pstmt.setBoolean(21, data.isC_da());
pstmt.setBoolean(22, data.isC_db());
pstmt.setBoolean(23, data.isC_dc());
pstmt.setBoolean(24, data.isC_dd());
pstmt.setBoolean(25, data.isC_de());
pstmt.setBoolean(26, data.isC_df());
pstmt.setBoolean(27, data.isC_dg());
pstmt.setBoolean(28, data.isC_dh());
pstmt.setBoolean(29, data.isC_di());
pstmt.setBoolean(30, data.isC_e());
pstmt.setBoolean(31, data.isC_ea());
pstmt.setBoolean(32, data.isC_eb());
pstmt.setBoolean(33, data.isC_ec());
pstmt.setBoolean(34, data.isC_ed());
pstmt.setBoolean(35, data.isC_ee());
pstmt.setBoolean(36, data.isC_ef());
pstmt.setBoolean(37, data.isC_eg());
pstmt.setBoolean(38, data.isC_eh());
pstmt.setBoolean(39, data.isC_ei());
pstmt.setBoolean(40, data.isC_ej());
pstmt.setBoolean(41, data.isC_f());
pstmt.setBoolean(42, data.isC_fa());
pstmt.setBoolean(43, data.isC_fb());
pstmt.setBoolean(44, data.isC_fc());
pstmt.setBoolean(45, data.isC_fd());
pstmt.setBoolean(46, data.isC_fe());
pstmt.setString(47, c_username);
pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeDB();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -