📄 cmsdbaccess.java
字号:
* @param object The property-object.
*
* @return object The property-object.
*
* @throws CmsException Throws CmsException if something goes wrong.
*/
public Serializable addSystemProperty(String name, Serializable object)
throws CmsException {
byte[] value;
Connection con = null;
PreparedStatement statement = null;
try {
// serialize the object
ByteArrayOutputStream bout= new ByteArrayOutputStream();
ObjectOutputStream oout=new ObjectOutputStream(bout);
oout.writeObject(object);
oout.close();
value=bout.toByteArray();
// create the object
con = DriverManager.getConnection(m_poolName);
statement= con.prepareStatement(m_cq.get("C_SYSTEMPROPERTIES_WRITE"));
statement.setInt(1,nextId(C_TABLE_SYSTEMPROPERTIES));
statement.setString(2,name);
// TESTFIX (mfoley@iee.org) Old Code: statement.setBytes(3,value);
m_doSetBytes(statement,3,value);
statement.executeUpdate();
} catch (SQLException e){
throw new CmsException("["+this.getClass().getName()+"]"+e.getMessage(),CmsException.C_SQL_ERROR, e);
} catch (IOException e){
throw new CmsException("["+this.getClass().getName()+"]"+CmsException. C_SERIALIZATION, e);
}finally {
// close all db-resources
if(statement != null) {
try {
statement.close();
} catch(SQLException exc) {
// nothing to do here
}
}
if(con != null) {
try {
con.close();
} catch(SQLException exc) {
// nothing to do here
}
}
}
return readSystemProperty(name);
}
/**
* Adds a user to the database.
*
* @param name username
* @param password user-password
* @param description user-description
* @param firstname user-firstname
* @param lastname user-lastname
* @param email user-email
* @param lastlogin user-lastlogin
* @param lastused user-lastused
* @param flags user-flags
* @param additionalInfos user-additional-infos
* @param defaultGroup user-defaultGroup
* @param address user-defauladdress
* @param section user-section
* @param type user-type
*
* @return the created user.
* @throws thorws CmsException if something goes wrong.
*/
public CmsUser addUser(String name, String password, String description,
String firstname, String lastname, String email,
long lastlogin, long lastused, int flags, Hashtable additionalInfos,
CmsGroup defaultGroup, String address, String section, int type)
throws CmsException {
int id = nextId(C_TABLE_USERS);
byte[] value=null;
Connection con = null;
PreparedStatement statement = null;
try {
// serialize the hashtable
ByteArrayOutputStream bout= new ByteArrayOutputStream();
ObjectOutputStream oout=new ObjectOutputStream(bout);
oout.writeObject(additionalInfos);
oout.close();
value=bout.toByteArray();
// write data to database
con = DriverManager.getConnection(m_poolName);
statement = con.prepareStatement(m_cq.get("C_USERS_ADD"));
statement.setInt(1,id);
statement.setString(2,name);
// crypt the password with MD5
statement.setString(3, digest(password));
statement.setString(4, digest(""));
statement.setString(5,checkNull(description));
statement.setString(6,checkNull(firstname));
statement.setString(7,checkNull(lastname));
statement.setString(8,checkNull(email));
statement.setTimestamp(9, new Timestamp(lastlogin));
statement.setTimestamp(10, new Timestamp(lastused));
statement.setInt(11,flags);
// TESTFIX (mfoley@iee.org) Old Code: statement.setBytes(12,value);
m_doSetBytes(statement,12,value);
statement.setInt(13,defaultGroup.getId());
statement.setString(14,checkNull(address));
statement.setString(15,checkNull(section));
statement.setInt(16,type);
statement.executeUpdate();
}
catch (SQLException e){
throw new CmsException("["+this.getClass().getName()+"]"+e.getMessage(),CmsException.C_SQL_ERROR, e);
}
catch (IOException e){
throw new CmsException("[CmsAccessUserInfoMySql/addUserInformation(id,object)]:"+CmsException. C_SERIALIZATION, e);
} finally {
// close all db-resources
if(statement != null) {
try {
statement.close();
} catch(SQLException exc) {
// nothing to do here
}
}
if(con != null) {
try {
con.close();
} catch(SQLException exc) {
// nothing to do here
}
}
}
return readUser(id);
}
/**
* Adds a user to the database.
*
* @param name username
* @param password user-password
* @param recoveryPassword user-recoveryPassword
* @param description user-description
* @param firstname user-firstname
* @param lastname user-lastname
* @param email user-email
* @param lastlogin user-lastlogin
* @param lastused user-lastused
* @param flags user-flags
* @param additionalInfos user-additional-infos
* @param defaultGroup user-defaultGroup
* @param address user-defauladdress
* @param section user-section
* @param type user-type
*
* @return the created user.
* @throws thorws CmsException if something goes wrong.
*/
public CmsUser addImportUser(String name, String password, String recoveryPassword, String description,
String firstname, String lastname, String email,
long lastlogin, long lastused, int flags, Hashtable additionalInfos,
CmsGroup defaultGroup, String address, String section, int type)
throws CmsException {
int id = nextId(C_TABLE_USERS);
byte[] value=null;
Connection con = null;
PreparedStatement statement = null;
try {
// serialize the hashtable
ByteArrayOutputStream bout= new ByteArrayOutputStream();
ObjectOutputStream oout=new ObjectOutputStream(bout);
oout.writeObject(additionalInfos);
oout.close();
value=bout.toByteArray();
// write data to database
con = DriverManager.getConnection(m_poolName);
statement = con.prepareStatement(m_cq.get("C_USERS_ADD"));
statement.setInt(1,id);
statement.setString(2,name);
statement.setString(3, checkNull(password));
statement.setString(4, checkNull(recoveryPassword));
statement.setString(5,checkNull(description));
statement.setString(6,checkNull(firstname));
statement.setString(7,checkNull(lastname));
statement.setString(8,checkNull(email));
statement.setTimestamp(9, new Timestamp(lastlogin));
statement.setTimestamp(10, new Timestamp(lastused));
statement.setInt(11,flags);
// TESTFIX (mfoley@iee.org) Old Code: statement.setBytes(12,value);
m_doSetBytes(statement,12,value);
statement.setInt(13,defaultGroup.getId());
statement.setString(14,checkNull(address));
statement.setString(15,checkNull(section));
statement.setInt(16,type);
statement.executeUpdate();
}
catch (SQLException e){
throw new CmsException("["+this.getClass().getName()+"]"+e.getMessage(),CmsException.C_SQL_ERROR, e);
}
catch (IOException e){
throw new CmsException("[CmsAccessUserInfoMySql/addUserInformation(id,object)]:"+CmsException. C_SERIALIZATION, e);
} finally {
// close all db-resources
if(statement != null) {
try {
statement.close();
} catch(SQLException exc) {
// nothing to do here
}
}
if(con != null) {
try {
con.close();
} catch(SQLException exc) {
// nothing to do here
}
}
}
return readUser(id);
}
/**
* Adds a user to a group.<BR/>
*
* Only the admin can do this.<P/>
*
* @param userid The id of the user that is to be added to the group.
* @param groupid The id of the group.
* @throws CmsException Throws CmsException if operation was not succesfull.
*/
public void addUserToGroup(int userid, int groupid)
throws CmsException {
Connection con = null;
PreparedStatement statement = null;
// check if user is already in group
if (!userInGroup(userid,groupid)) {
// if not, add this user to the group
try {
// create statement
con = DriverManager.getConnection(m_poolName);
statement = con.prepareStatement(m_cq.get("C_GROUPS_ADDUSERTOGROUP"));
// write the new assingment to the database
statement.setInt(1,groupid);
statement.setInt(2,userid);
// flag field is not used yet
statement.setInt(3,C_UNKNOWN_INT);
statement.executeUpdate();
} catch (SQLException e){
throw new CmsException("[" + this.getClass().getName() + "] "+e.getMessage(),CmsException.C_SQL_ERROR, e);
} finally {
// close all db-resources
if(statement != null) {
try {
statement.close();
} catch(SQLException exc) {
// nothing to do here
}
}
if(con != null) {
try {
con.close();
} catch(SQLException exc) {
// nothing to do here
}
}
}
}
}
/**
* Private helper method for publihing into the filesystem.
* test if resource must be written to the filesystem
*
* @param filename Name of a resource in the OpenCms system.
* @return key in exportpoint Hashtable or null.
*/
protected String checkExport(String filename, Hashtable exportpoints){
String key = null;
String exportpoint = null;
Enumeration e = exportpoints.keys();
while (e.hasMoreElements()) {
exportpoint = (String)e.nextElement();
if (filename.startsWith(exportpoint)){
return exportpoint;
}
}
return key;
}
/**
* Checks, if the String was null or is empty. If this is so it returns " ".
*
* This is for oracle-issues, because in oracle an empty string is the same as null.
* @param value the String to check.
* @return the value, or " " if needed.
*/
protected String checkNull(String value) {
String ret = " ";
if( (value != null) && (value.length() != 0) ) {
ret = value;
}
return ret;
}
/**
* Deletes all files in CMS_FILES without fileHeader in CMS_RESOURCES
*
*
*/
protected void clearFilesTable() throws CmsException {
Connection con = null;
PreparedStatement statementDelete = null;
try {
con = DriverManager.getConnection(m_poolName);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -