数据源
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
String ds = "java:comp/env/jdbc/qyjwxtDS";
String sql = "select sfqy from xtgl_bmgzmb where bmgzbh = ?";
javax.naming.Context initialContext = null;
DataSource dataSource = null;
try {
initialContext = new InitialContext();
dataSource = (DataSource)initialContext.lookup(ds);
if (dataSource != null) {
conn = dataSource.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, "003");//教师规则模板编号为003
rs = ps.executeQuery();
if (rs.next()) {
String sfqy = rs.getString(1);//是否启用
System.out.println(sfqy);
}
}
} catch (NamingException e) {
log.severe(e);
}catch (SQLException e) {
log.severe(e);
}