java Jdbc异常处理
我已经创建了下面的JDBC连接,它现在可以很好地使用下面的代码,我正在使用log4j
,如果JDBC连接出现故障,我想将其记录在日志文件中,而不是显示在控制台中
public class projectDaoJdbcImpl implements projectDao {
static Logger logger = Logger.getLogger(projectDaoJdbcImpl.class);
@Override
public boolean updateproject(updateentity projectObj) throws Exception {
FileInputStream fis = new FileInputStream("C:\\Users\\kdhandap\\database.properties");
Properties props = new Properties();
props.load(fis);
String JDBC_DRIVER = props.getProperty("Driver");
String USER = props.getProperty("Username");
String PASS = props.getProperty("Password");
String url = "jdbc:mysql://" + projectObj.getServerName() + ":3306/tablename";
boolean result = false;
Connection conn = null;
PreparedStatement stmt = null;
String sql = "UPDATE table SET columnname='" + projectObj.getFlagStatus()
+ "' WHERE projectID IN (" + projectObj.projectId() + ")";
try {
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(url, USER, PASS);
stmt = conn.prepareStatement(sql);
if (stmt.executeUpdate() != 0) {
result = true;
}
}
catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException se) {
se.printStackTrace();
}
finally{
stmt.close();
conn.close();
}
return result;
}
试着找一个记录器。警告状态并在日志文件中捕获,但不确定在何处处理
共 (0) 个答案