📄 cmsdbaccess.java
字号:
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.
* @exception 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);
statement.setBytes(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.
* @exception 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);
statement.setBytes(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.
* @exception 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 m_exportpointStorage Hashtable or null.
*/
protected String checkExport(String filename){
String key = null;
String exportpoint = null;
Enumeration e = m_exportpointStorage.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);
statementDelete = con.prepareStatement(m_cq.get("C_RESOURCES_DELETE_LOST_ID"));
statementDelete.executeUpdate();
} catch (SQLException e) {
throw new CmsException("[" + this.getClass().getName() + "] " + e.getMessage(), CmsException.C_SQL_ERROR, e);
} finally {
if(statementDelete != null) {
try {
statementDelete.close();
} catch(SQLException exc) {
// nothing to do here
}
}
if(con != null) {
try {
con.close();
} catch(SQLException exc) {
// nothing to do here
}
}
}
}
/**
* Copies the file.
*
* @param project The project in which the resource will be used.
* @param onlineProject The online project of the OpenCms.
* @param userId The id of the user who wants to copy the file.
* @param source The complete path of the sourcefile.
* @param parentId The parentId of the resource.
* @param destination The complete path of the destinationfile.
*
* @exception CmsException Throws CmsException if operation was not succesful.
*/
public void copyFile(CmsProject project,
CmsProject onlineProject,
int userId,
String source,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -