有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

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) 个答案